Using Sql.Request with iSeries ODBC driver

pts.
Tags:
AS/400
Microsoft Office
I am attempting to use the sql.request fucntion in excel (add-in from xlodbc.xla) to access data on a AS/400 using the iSeries ODBC driver, but I can't get it to work. I beleive the problem is in the connection_string. I am using "DSN=iSeries; UID=guest; PWD=123" but it does not seem to connect to the AS/400 properly. I am using ODBC driver "Client Access ODBC Driver (32 bit)" version 9.00.09.00.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Can you clarify “does not seem to connect to the AS/400 properly”? What DOES happen? Are you getting error messages? If so, what are they? Did you test the DSN? If not, do so. Does it connect successfully? Without more info, there’s no way to know if it’s your connection string or a permissions issue or a network problem.

Also, have you tried a DSN-less connection? I believe the connection string would be something like;
oConn.Open “Driver={Client Access ODBC Driver (32-bit)};” & _
“System=myAS400;” & _
“Uid=myUsername;” & _
“Pwd=myPassword”
Yes, you need to include the entire name of the driver, just as it appears above.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following