Re: PB 5.03 -> Informix 7.23
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET, Server Administration
Joe, I think the SetNet32 *only* uses the registry. The INFORMIXSERVER environment variables were used by the 16 bit SetNet products. You may just try setting the registry, and leave the Environment variable alone. Joe Morgan Joe Lumbley wrote: > > 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. > ---------------------------------------------------------------------------