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

From: "cjones" <cjones@xxxxxxxxxx>
Date: 26 Oct 2005 14:05:14 -0700

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.

.

Follow-Ups:
- Re: using multiple Informix DB Servers w/same name, different Host IPs in ODBC
  - From: david

Prev by Date: Re: Error 356: Unable to create foreign key. Differences not
Next by Date: Re: how to pass an array of integers into a Stored Procedure ?
Previous by thread: Error 356: Unable to create foreign key. Differences not
Next by thread: Re: using multiple Informix DB Servers w/same name, different Host IPs in ODBC
Index(es):
- Date
- Thread

Relevant Pages

Re: Database Window Missing
... If you don't have experience with Access and SQL Server, ... GB upper limit for Access and explaining some of the benefits to SQL ... Open Access and under Window on the Toolbar select one of the Tile ... the database window screen does seem to have the ...
(microsoft.public.access.externaldata)
Re: Database Window Missing
... I also agree 100% on the SQL Server migration. ... GB upper limit for Access and explaining some of the benefits to SQL ... Open Access and under Window on the Toolbar select one of the Tile ... the database window screen does seem to have the horizontal ...
(microsoft.public.access.externaldata)
Re: Switchboard is read only
... Do you have modify permissions on the folder where the mdb ... You should also split the database; ... server, and give each user a copy of the frontend on their computers. ... the I get a larger window with explanation to which I ...
(microsoft.public.access.security)
Re: Force a submit() on parent from child?
... There are too many sites with code to update select lists without reloading the page for me to believe that. ... hope your entry into the database happens before the main page gets submitted. ... order that the data can be POSTED back to the server, and will reappear in the correct fields. ... Although there is no reason why it shouldn't, but if I do an actual submit/update before calling the sub window, I guess I lose the code that had decided to do the window spawn...submit being a sort of 'GOTO' if you like.. ...
(comp.lang.javascript)
Re: Force a submit() on parent from child?
... There are too many sites with code to update select lists without reloading the page for me to believe that. ... hope your entry into the database happens before the main page gets submitted. ... in order that the data can be POSTED back to the server, and will reappear in the correct fields. ... Although there is no reason why it shouldn't, but if I do an actual submit/update before calling the sub window, I guess I lose the code that had decided to do the window spawn...submit being a sort of 'GOTO' if you like.. ...
(comp.lang.javascript)