Re: using multiple Informix DB Servers w/same name, different Host IPs in ODBC

> 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. Try to utilize hosts file (it located in %windir%\\system32\\drivers\\etc). Do not use IP in Data Source definition but hostname. And change IP in hosts file.