Change ODBC Settings on the fly
Posted on 2003-12-12
I have a VB app that is used as an interface for 2 databases. The VB code uses only 1 system dsn so for users to switch between databases, they have to manually re-configure the odbc setting to look at the appropriate database.
In the long-term I will be changing the code but in the short term I would like to speed up the re-configuration process and am thinking a bat file would be fastest.
The question is:
Does anyone here know how to re-configure an odbc/dsn connection to look at another db by using a bat file, or, does anyone have a better short term solution.
Looking forward to your suggestions.
Cheers - Andy