Using Sql.Request with iSeries ODBC driver
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
November 4, 2005 12:56 PM
UPDATED:
November 7, 2005 10:45 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
