DB2 connection and Domino Form

HCL Domino Domino Forum
1

I am trying to get data from db2 in my notes form. I do not want to use ODBC . I used “Dim src As New LCConnection (“oracle”)” to connect to oracle. How can I connect to DB2. Suppose a user input item number in the free form field , agent should run and go get the description for that item from AS400.Thanks for all the help.

2

Subject: DB2 connection and Domino Form

I have done this using JDBC/Java

You have Lotusscript get the data from the form then pass the data to a Java library (you use LS2J for this)

Java will take the passed data, make a connection to DB2/AS400, do what you need done and return the results to Lotusscript. Lotusscript will present the data to the user on the form

I used this method in a very large application that worked very well. It worked much better than a pure Lotusscript method.

If you wish to do your project this way and you need more help, please feel free to e-mail me.

Mike