ODBC Connection To iSeries File Failing After Upgrade

HCL Domino Domino Forum
1

We are having a few problems with a background Notes agent running a bit of lotus script.

The agent runs every X mins, and uses an ODBC connection to grab data from a file sitting on our iSeries (AS400) box, read the file contents n and then send’s emails to people using the data got from the file as the recipient, subject & body, it then remove the entry in the file.

Since we have installed a new iSeries box and upgraded teh version of notes from 6.02 to 6.5 it has stopped working, and after investigating the error i get is “LS:DO- ODBC could not complete the requested operation.”

I think it is having problems getting the odbc connection / opening it, although it could be a config issue on the server setup (although i think we did a straight copy from one box to the other).

Any ideas as this is annoying and dont really want to have to totally re-write the agent if i can help it!!!

2

Subject: RE: ODBC Connection To iSeries File Failing After Upgrade

Note presence of EI Forum for this kind of question.

It would help if you could’ve changed just one thing at a time instead of two – the new server and the new Domino version – to narrow down the possibilities.

Your post is missing important information about what exactly you’re doing and how and where exactly it goes wrong. Please revise according to these guidelines.

Have you done any tests with other programs to see whether they can use the ODBC functions? E.g. can you create a DCR to that database, or use the data source from programs outside of Notes?