I've been working on a VB.Net and VBA applications that I would like for both of them to utilize an informix database on a unix server. I've installed the Informix CLI 2.5 ODBC drivers that include a program called SetNet32.
In our environment we have 3 servers with a total of 5 different databases between the 3. I would like to be able to set the SetNet32 settings from within code. I thought since all the changed settings are allowed within your connection string this would work easily by utilizing these settings. My problem is that if these settings are changed within SetNet32 I get an Informix ODBC error. So no to my question. Is their anyway to connect to an Informix database without having to manually change these settings so that people could continue to use the SetNet32 application for allowing them to download information to spreadsheets but not effect the operation of my application on the same machine.
Another alternative would be for this a batch process to execute this command before opening the application "setnet32 -l c:\AutoCarSettings.nfx". My problem with attacking this project this way is that the application is supposed to open silently and load the data from the nfx file. Instead all I can accomplish is for SetNet32 to open without loading the data.
If you know what I can do to alternate between servers and databases by designating them within either VB.Net code or VBA code I would appreciate it.
In our environment we have 3 servers with a total of 5 different databases between the 3. I would like to be able to set the SetNet32 settings from within code. I thought since all the changed settings are allowed within your connection string this would work easily by utilizing these settings. My problem is that if these settings are changed within SetNet32 I get an Informix ODBC error. So no to my question. Is their anyway to connect to an Informix database without having to manually change these settings so that people could continue to use the SetNet32 application for allowing them to download information to spreadsheets but not effect the operation of my application on the same machine.
Another alternative would be for this a batch process to execute this command before opening the application "setnet32 -l c:\AutoCarSettings.nfx". My problem with attacking this project this way is that the application is supposed to open silently and load the data from the nfx file. Instead all I can accomplish is for SetNet32 to open without loading the data.
If you know what I can do to alternate between servers and databases by designating them within either VB.Net code or VBA code I would appreciate it.
