Db2 as400

HCL Domino Domino Forum
1

Hi friends…i searched a lot this new forum for help but it seems that, even though someone else already found the problem, none found an answer. I explain…i’ve got many agents running manually that query on AS400 server throught a DB2 connection…now i’m migrating from lotus 4.6.7 release to D6.0.1…i changed the uselsx nlsxdb2 dll to nlsxodbc one…changing the methods needed to raise a connection.Anyway now none of my agents works!!! Everyone stops when a connection is called via LotusScript. Am i missing anything?? is there a bug??? are there anyone working on this problem???

Anyway, i hope someone could help me and all the people having the same trouble.

Thanks in advance.

Best Regards, Daniele.

2

Subject: Don’t use ODBC, instead use nlsxlc. This has a native DB2 driver for it.

3

Subject: RE: Don’t use ODBC, instead use nlsxlc. This has a native DB2 driver for it.

Thanks for your response Bill…but…can i use nlsxlc dll as i used nlsxdb2 dll in version 4 or 5 of notes?? I mean: i simply substitute in script the uselsx “nlsxdb2” line with uselsx “nlsxlc” new line?

regards, Daniele.

4

Subject: No, it is a different programming model

We have a very good module on using the Lotus Connectors in our Advanced LotusScript course:

It does get a bit complicated and you have several options to do data transfers/lookups.

Howard

5

Subject: RE: Don’t use ODBC, instead use nlsxlc. This has a native DB2 driver for it.

That’s kinda odd … Normally, you would use statements like:

uselsx “*lsxodbc”, or

uselsx “*lsxlc”

If you change the code to use LC, there may/will be some programming changes needed.

6

Subject: Not really as Howard said you will have to change some declarations and stuff, but the model is amazingly similar.

7

Subject: Solution and warning!!!

Hi dear friends…thanks a lot for your answers…i must admit i’ve lost many days trying to face this problem…at the end i managed to obtain the connection to AS400; i changed my script using nlsxodbc dll instead of nlsxdb2 one(changing all the methods obviously), second i found that there were some problems with db2 drivers on the server machine…they weren’t able to resolve host name, i had to insert IP address instead of machine name…(so a DNS problem).

Finally i’d like to suggest a link :http://www-12.lotus.com/ldd/doc/domino_notes/5.0.10/readme.nsf/0/19e1171e7ede5c4e85256bac0059e6b3?OpenDocument where it is told about the end of service of db2 lsx…couldn’t they say it more clearly and explicetely…it seems to me a quite important thing to underline…isn’t it???

By the way…thanks a lot to all of you and i send you my best regards.

Daniele.