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.
I managed to create a User DSN and connect to the database. However the problem with the System DSN remains.