Script to change ODBC settings on Vista Client Computers

[SADIQ]

I have Windows Vista on my computer and i have lots of SQL databases running which would stress my computer so i brought a new computer to reduce some stress. Well i just moved some database to the new computer, so i made new ODBC server. Is there a way to create a script to change the clients computer's ODBC settings?

[Katty]

All i know is ODBC settings are stored in the registry which are exportable in a .reg file. Its located at :

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

Here you will find the key with the name of DNS for each SQL connection

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

Here you will see a key with sub values
corresponds to the value that exists in the above key.

Export those two keys...

[SADIQ]

Well after exporting the key just pass it on to the clients to run? I don't think this will work as this registry keys will hold the old ODBC and DNS information. How do i get the new information to these keys? Doesn't make sense for me...

[Zecho]

Well after exporting the key just pass it on to the clients to run? I don't think this will work as this registry keys will hold the old ODBC and DNS information. How do i get the new information to these keys? Doesn't make sense for me...

Right. After exporting the registry keys as mentioned by katty, open those .reg files in notepad, make necessary changes and save the file. Now send the new files to the client computers and run it and click yes when it asks to add it to the registry. Done!