Connect to the AS/400 with userID & password

[d1004]

I want to pass the userID & password to AS/400, so what I do is put them into my connection
string parameter. However, I can't seem to get it.
This is my code:

"Provider=IBMDA400;Data Source=blah;Transport Product=Client Access;SSL=DEFAULT; userID = variable1; Database Password = variable2"

Thank you!

 

[onpnt]

you need to concatinate the variables into the string. If you have it as you show it there is no recognition that they are varaibles.

"Provider=IBMDA400;Data Source=blah;Transport Product=Client Access;SSL=DEFAULT; userID =" & _
variable1 & ";" & "Database Password =" & _
variable2 & ";"

not entirely sure on that syntax. not able to test it. they made me leave my 400 a week or so ago.
---------------------------------------
{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee"alert(Nstr); }
---------------------------------------
for the best results to your questions: FAQ333-2924

http://www.onpntwebdesigns.com