Connecting to multiple Informix servers via I-Connect - Repost
Posted in 1997
Topics: Server Administration
I am using PB 5.0.02 on Win NT (4.0) using Informix On-line 7.12 (native drivers). I have a common object that takes care of making all the necessary database connections for any of our applications. Right now, everything works fine for our Informix connections from 16-bit environments using INET. But, using ICONNECT, I'm having a problem dynamically specifying which informix server to connect to. Even though all the servers are correctly defined in the SetNet32, if I try to connect to database that is on a server otherthan the one set as the default Informix Server. I set the SQLCA.ServerName to the Informix host name, but I don't know how to correctly specify the Informix Server, Protocol, or Service. With I-Net, I could specify the server (xxx_prod), the host (xxxsqnt6), the protocol (tcp-ip), and service (xxxpsrv), by manipulating the INFORMIX.INI file and setting the SQLCA.ServerName to the HOST name. Now, with I-CONNECT, how do I specify the server, host, protocol, and service? I am interested to know WHERE did you find out what parms needed to be set and in what format? (Our DBA's aren't very knowledgable folks when it comes to practical things like connecting from an application!). TIA, Phil Yandel | "I believe that life is 10% what happens Sr Application Developer | to me and 90% how I react to it." Amercian Medical Association | - Chuck Swindoll phil_yandel@ama-assn.org | All opinions are my own... PhilCYa@aol.com | ...no one else wants them