Client Access to AS400 using ODBC and lsxodbc

HCL Domino Domino Forum
1

I’m trying to make a connection to a table on the AS400 from a Domino 6.5 server. The Client Access version installed on the server is 8.0.

I have checked my userID, password, and source name - they all seem to be correct.

When the Lotusscript agent tries to connect, I get the following error:

“[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified”

The only code we have running right now is just trying to make the connection and it will not perform. We have written similar code on R5 and never ran into this problem.

I have read the other postings on this database, and tried them all - I have put the full dll name “nlsxodbc” in the declarations instead of using “*lsxodbc” and it does not change the error message.

Any help you can give would be great!

2

Subject: Client Access to AS400 using ODBC and lsxodbc

Try to manually re-create ODBC source connection (in Windows Control Panel) and change name on it. Does it work if you run agent manually from Notes client on server?

You can also take a look at “*lsxlc” library which does not require ODBC source and uses connection polling, but I think you need DECS/LEI installed on server.