Re: PB 5.03 -> Informix 7.23

Joe Lumbley (jlumbley@netcom.com) wrote: : I'm developing in PB 5.02 on NT with Informix 7.23 and I'm having : trouble connecting to any server unless it is made the "default" : server in setnet32. I'm using an IN7 (not ODBC) connection. : I'm setting everything **but** DBPARM in the SQLCA and custom : system_TransObj transaction. OK, asked and answered. I'll answer my own question. Informix uses the environment variable INFORMIXSERVER to indicate which server it is talking to. Making a server the default in setnet32 sets INFORMIXSERVER to the currently chosen server. But, when I manually make the env change, it still doesn't connect to the right server. Turns out that there is **also** a registry variable: HKEY_CURRENT_USER/Software/Informix/Environment/INFORMIXSERVER When you use the RegistrySet function to set the registry to the correct target machine, PowerBuilder connects properly. jpl -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998 from Prentice Hall/Informix Press. If you have debugging tips, tools, or ideas to share, please send me some e-mail. ---------------------------------------------------------------------------