The ODBC settings are stored in the registry. You can export the keys to
a reg file.
Under:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources , you'll find
a key (name of dsn) for each SQL connection.
Under:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI you'll see a key with sub values
corresponds to the value in the above key.
Export the two, open the reg files in notepad and make the neccessary changes
if needed. I recommend merging
the files into one reg file, then ask your users to import (double-click)
it on the destination server(s).
-----
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com Quote:
> I recently moved some of my SQL databases to my new sql2005 box. Now
> I'm looking for a way to send a script to people that will change
> there ODBC connection to the new server.
>
> any way to script this?
>
> Thanks.
>