Re: SETNET32 Problems

Set up multiple hosts and multiple servers in setnet32. Make anyone of them the default. Then list all your servers in the DBPATH environment variable. Make sure your services file has information about both the services. Mukta Jason Crickmer wrote: > 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