I am designing an application where I need to access DB2 information on a separate server from the Domino server. I have read the documentation "Create a Lotus Notes Application to access DB2 using Domino Designer. I’ve load the DB2 Client to my desktop but it is not loaded on the Domino Server yet. I am trying to create the Connection document through the Decs Administrator for the DB2 Connection. The issue that I am having is that I cannot see where it is that you indicate the server name. In the ODBC connection document, it has a field for the Data Source, which is where you would indicate the server. But the DB2 document has a DB2 Database field and not a server field. Can anyone point me in the right direction. Is it because I do not have the DB2 Client on the Domino Server as well?
Subject: Notes app. accessing DB2 connection
-
When you install DB2 client on your machine or Domino server, a DB2 driver gets installed.
-
Now go to Windows ODBC Data sources from Control Panel, to create a DSN. While creating this DSN select the driver as DB2 driver you had installed in above step. This screen will also ask for server name, default DB2 library etc.
-
Now DSN is ready, and it can be mentioned into DECS.
PS:
If it was Oracle instead of DB2, step 2 would have been to make proper entries in tnsnames.ora file.
Regards
Litty Joseph