Notes agent accessing Sql/Db2 via ODBC - worked in the past but dont work anymore

HCL Domino Domino Forum
1

Hello Everybody,

We have numerous notes agents on the notes production server accessing Sql db’s - Sql Server (via LS DO) and Db2 (via LSXLC). These have worked well in the past up until last week. We have not done any upgrades on the notes server.

The same agent code still works in our development environment connecting to the Sql db’s. They fail in production on the connecting to the odbc. We checked the ODBC datasources on the production server and they work fine.

For example on the LsxLC code for db2, it gives an error (Error 217: Error creating product object) on the lotusscript statement

Dim connect As New LCConnection (“Db2”)

Has anyone faced such an issue of notes agents stopped connecting to odbc ? Would the LSDO and LCLSX dll be corrupt? Can anyone provide some insight?

Thanks

2

Subject: Notes agent accessing Sql/Db2 via ODBC - worked in the past but dont work anymore

Have the permissions changed on the sql db’s?

3

Subject: RE: Notes agent accessing Sql/Db2 via ODBC - worked in the past but dont work anymore

No, permissions are the same. We can access with the same user id and password from the notes development environment into the prod instance of the sql db. I’m able to check the sql data from access too.