Domino and DB2/400 -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Hi All,

I'm wondering if anyone has successfully accessed DB2/400 tables from a LotusScript using the ODBCConnection classes?

I've created an agent running LotusScript to get data from the 400 but I can't seem to connect properly and I'm having trouble finding help/ resources relevant to the 400 and Domino on the Web. My script uses the ConnectTo method with a data source,user-id and password as parameters. I put in an error trap to try and get some more info but the only message I'm getting back is

"LS: ODBC could not complete the requested operation"

I've registered the data source name as an *Local entry in WRKRDDIRE as specified in the "Installing and Managing Domino for AS/400" manual from Lotus and I'm using my own user-id and password so I know they're valid. I can't see any messages being generated on the 400 either within Domino Console or in QHST or job logs.

Do I have to set up the LSX Toolkit for AS/400? The manual mentioned implies that you don't have to but is a bit vague on this subject

Any suggestions/ advice would be appreciated

Mark Burns

Primary Superannuation Services

Australia

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.