iconnect/ODBC
Posted in 2003
We have run into a problem using INFORMIX 3.82 32 BIT driver (3.80 also). If we add a second (or more) DSN (user, system or file) for other hosts, it overwrites the previous host(for example if I had a DSN named bob-dsn with hostname of bob, and added a new DSN with a hostname of sally, when I go back to bob-dsn the hostname is sally. We do have the same Informix server name for multiple boxes, so the 'Host Name' will be the only unique thing for the different servers. Hosts are in the hosts file, service is in the services file. I also tried to use separate services, and that also seems to be a one value thing. Is doing something like: rc=SQLDriverConnect (hdbc, NULL,"DRIVER = {INFORMIX 2.8 32-BIT}; DATABASE=ovs; HOST=clipper;SERVICE=turbo;SERVER=ol_clipper; PROTOCOL=onsoctcp;UID=odbc;PWD=odbc", SQL_NTS, szerrormessage, 256,pcberrormessage,SQL_DRIVER_NOPROMPT) A way to connect to multiple hosts with the same DB/Service? Thanks in advance for the help. Sam Gentsch Informix Database Evangelist 303.223.6641 Voyant Technologies, Inc. "The leader in group voice communication."