Re: Domino and DB2/400

>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.


I haven't used LotusScript, but I've done a decent amount with the Notes
formula language @DB commands to access AS/400 data.  Don't know if that's
helpful, but I did find a few things that might be relevant.  Make sure that
the id you are using for the connection still works, with the password that
you are using (seems basic, but I've seen this broken).  Use the fully
qualified name of the file in your SQL, such as library.file   There was a
guy on the notes.net board with the same error, but he never posted if
(or whether) he got it fixed.  Might be worth a look there at
http://notes.net/46dom.nsf

Also worth trying-- Midrange Computing posted a sample app at
http://www.midrangecomputing.com/ie/98/yrdownload.htm
that uses LotusScript.  I'd download it and see if it works on your system, 
and if it does find out what is different.

Good luck,
Erik Knudson
Symatrix Technology
Portland, OR

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---