I should have mention that DSNs under HKEY_LOCAL_MACHINE are system DSNs,
under the same path in HKEY_LOCAL_USER you can find
user DSNs, if any.
-----
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com Quote:
> 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.
>>