Re: SETNET32 Problems

Herb, Herb wrote: > > Friends, > I am having a problem with Informix's SETNET32. I have two > servers > here, a development and production server. For some applications I > must > connect to the development box other times I need to go to the > production server. Each time I switch servers I have to manually edit > the SETNET32 values. We called INFORMIX and rather than provide a > dynamic solution they actually recommended that we purchase an > additional PC for the client to connect to the second server. This > seems > ludicrous to me. > > Does anyone know how to dynamically change the SETNET32 values on the > client so I can connect to two different servers at different times? > Any help would be appreciated. > I am no Informix guru, but I have had similar problems. I have two machines with Informix Online 7.12 TC5 installed on NT: one is development, and one is 'live.' What I ended up having to do was go in to the registry and CREATE another SQLHOSTS entry. YOu will find these under HKEY_LOCAL_MACHINE\\SOFTWARE\\INFORMIX\\SqlHosts. Just take whatever is listed ('ol_saper', for instance), and copy all of the values in to another key (e.g. 'ol_andy'). Then, just change the values to reflect the settings on each server. I did this on all the machines that need to see both servers (including the two servers). Its a hassle, but it works. The thing that doesn't work, is that some times I run SETNET32 as a particular user, and when I hit 'Ok' or 'Apply,' it says "Unable to write to registry." But, if I in and look, it DID write to the registry. Weird. Hope this helps! Jason -- Jason Crickmer, NSE jason@sapermedia.com Saper Media Group Tel: (512) 302.9800x33 3305 Northland Drive, Suite 500 Fax: (512) 377.5700 Austin, Texas 78731 http://www.sapermedia.com