Re: Connecting to multiple Informix servers via I-Connect - Repost

philcya@aol.com wrote: > > 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!). > You set up I-Connect in the SetNet32 application. It stores its parameters in the registry. On my machine (Win95) it is in: HKEY_LOCAL_MACHINE.SOFTWARE.INFORMIX.SqlHosts."ServerName". I'm not familiar with WinNT, but I think it has a registry, right? I found out how to set these just by running the Setup program for I-Connect. There it tells you to run SetNet32 to set your parameters. -- Matthew C. Reprogle Delco Electronics - IC Integrated Manufacturing phone: (765)451-9651 Internet: mcreprog@mail.delcoelect.com FAX: (765)451-8230