Hi Julie,
I have sent you a tool to your personal e-mail. Its an ODBC switching utility. I work on a system where I switch between three SQL servers - Live, Test and Development. The system sees the same ODBC connection name but the switcher facilities the updating of the connection details. This is used in a commercial environment and it works very well. I don't know whether its exactly what you are looking for but it might help.
Best
>I have 3 different connection strings that need to be used based and where we are on the network or disconnected laptop. I have been making three seperate exe's to date and would like to have 1 and use a confi file to help me determine which connection runs.
>
>Any ideas would be very helpful
>
>Thanks
-=Gary