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.
November 4, 2005 12:56 PM
November 7, 2005 10:45 AM