informix odbc entries
hi folks,
i am having an issue with the setup of 3 informix odbc entries.
Informix Client is a pre-req. i install this which includes the informix odbc drivers.
Then I begin adding the system dsn's needed by the client.
odbc1
the server name for odbc1 is shm_on, the host name is odbc1.
I test the connection and it works.
I then configure odbc2. the server name is shm_on and the host name is odbc2.
I test it and it connects successfully.
Now when i check the settings of odbc1 its hostname is odbc2!!
It seems that if you have an 2 or more informix dsn's pointing to the same server name it gives you a nightmare as the settings of the last configured odbc are inherited by every informix odbc pointing to that servername!
has anyone seen this before? Is there a way to have multiple informix dsn's pointing to the same server name.
Any help much appreciated.
i am having an issue with the setup of 3 informix odbc entries.
Informix Client is a pre-req. i install this which includes the informix odbc drivers.
Then I begin adding the system dsn's needed by the client.
odbc1
the server name for odbc1 is shm_on, the host name is odbc1.
I test the connection and it works.
I then configure odbc2. the server name is shm_on and the host name is odbc2.
I test it and it connects successfully.
Now when i check the settings of odbc1 its hostname is odbc2!!
It seems that if you have an 2 or more informix dsn's pointing to the same server name it gives you a nightmare as the settings of the last configured odbc are inherited by every informix odbc pointing to that servername!
has anyone seen this before? Is there a way to have multiple informix dsn's pointing to the same server name.
Any help much appreciated.
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
aogilmor
17 years ago
try applying the settings of the second odbc entry using the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\odbc2
it can help to just set up the odbc data sources manually, then go to the registry and export the keys.
IIRC the registry write part comes after ODBC Data source application in the install sequence, so this shouldn't present any problems.
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\odbc2
it can help to just set up the odbc data sources manually, then go to the registry and export the keys.
IIRC the registry write part comes after ODBC Data source application in the install sequence, so this shouldn't present any problems.
Posted by:
schieb
17 years ago
My rule of thumb for packaging Informix related stuff is to setup all the odbc entries how I want them by doing a normal, functional install of the application. Once I verify it is good and working I export the HKLM\SOFTWARE\ODBC keys to a reg file. Now I prepare the package with Wise. Once the capture is comeplete and I am ready to use the Windows Install editor, I go to the ODBC tab and remove all the odbc entries. Now I can import that .reg file from the good install. This seems to fix everything for me when I have issues come up.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
