Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator

I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem.

I’ve looked through the internet and found the following page that has some instructions on how I should proceed: http://www.ryslander.com/how-to-install-and-configure-db2-odbc-driver/.

I followed these instructions and I am able to create a new System DSN, however when I try to configure it it seems as if my configurations don’t work at all. For example, when I click on the “Configure” button on my System DSN and I add a TCP/IP protocol configuration on the “Advanced Settings” tab and click “Ok”, no errors appear, but when I click on “Configure” again my TCP/IP setting has vanished.

This happened to all my other configurations, such as database name, username, password etc.

Could you help me figure out what I am doing wrong?

Note: my user is in the administrator group and I am using a Windows Server 2008 R2 Enterprise x64.

UPDATE

I managed to create a User DSN and connect to the database. However the problem with the System DSN remains.

Answer

It is far easier to use the built in DB2 commands to set up DSNs, as long as you aren’t afraid of the command line. Open a DB2 Command Window, and then:

  1. db2 catalog tcpip node n1 remote <hostname or ip> server <port number>

  2. db2 catalog database <database> at node n1 (where n1 is the node name from step 1)

  3. db2 catalog system odbc data source <database>

Attribution
Source : Link , Question Author : Felipe , Answer Author : Ian Bjorhovde

Leave a Comment