Re: ESQL question

HWA wrote: > > I have Informix ESQL ver. 7.20 running on my Windows 95 PC. I can connect to > my Informix database on SCO Unix with no problem. > The problem is, I need to connect to multiple(4) servers and multiple (4) > databases. Is there anyway to do this without having to run SetNet 32 and > changing servers each time? Should I not be able to set up an ODBC driver > for each server/database? You should not need to rerun SetNet32 to change servers. You just need to use an explicit CONNECT statement to connect to the specific server by name or formulate the database string as <database>@<server>. The former is better as the latter will connect first to the default server (defined in the INFORMIXSERVER environment variable) and ask the default server to make a connection to the other server for you as a data passthrough). As long as the server is defined in SetNet32 you will be fine. You can even have multiple concurrent connections from your ESQL/C program to different servers and switch between them on the fly using SET CONNECTION statements. Art S. Kagel