SETNET Configuration

Folks, I'm looking for a solution to the problem of linking to different DB's on different boxes using COGNOS report writer. The problem is that the linkages are made through SETNET, and I need two different environment, host and server setups. These setups can be saved to a file, and the file loaded once you're in SETNET itself. However, I'd like my users to click on two separate icons to get to the separate DB's using the different SETNET configs transparently. Does anyone know whether SETNET can be executed with the saved xxx.nfx file as a parameter? Is there another, better solution? TIA, Herb

Blacker, Herb wrote: > > Folks, > > I'm looking for a solution to the problem of linking to different DB's on > different boxes using COGNOS report writer. > The problem is that the linkages are made through SETNET, and I need two > different environment, host and server setups. > These setups can be saved to a file, and the file loaded once you're in > SETNET itself. > However, I'd like my users to click on two separate icons to get to the > separate DB's using the different SETNET configs transparently. > Does anyone know whether SETNET can be executed with the saved xxx.nfx file > as a parameter? > Is there another, better solution? > > TIA, > Herb I don't remember the keys off hand, and the code is not readily accessible at the moment, but we wrote a DB switcher program for Informix by searching for the Win95 registry keys and then changing those to what we want them to be in a Visual c++ program. Basically we have one program that needs to be run on multiple databases, depending on if we want it live or test. The program reads the current keys to decide which you are on and then has a radio buttons for the server to connect to. Once you choose the server it then runs the app for you. Hope this helps Steve