using multiple Informix DB Servers w/same name, different Host IPs in ODBC
Posted in 2005
I need to solve a situation where we have many detached sites running the same software built around and Informix database. The Database Server Name at all these sites is the same. I need to access these sites from my pc. I have no problem setting up an ODBC Data Source to one of them and getting in but when I set up the Data Source to the second, which has the same Server Name but a different Host Name (IP address) Window will change the IP address in the previously set up ODBC Data Source to that I put in the second ODBC Data Source. I've found Windows seems to only associate one Host Name (IP address) with one Server Name. I need to get around this. In fact I'd like to be able to have connections to several of these sites' databases simultaniously if possible. I give each of them a unique ODBC Data Source Names. Help! and Thanks.