Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 03-06-2009
SADIQ
 
Posts: n/a
Script to change ODBC settings on Vista Client Computers

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?
Reply With Quote
  #2  
Old 03-06-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: Script to change ODBC settings on Vista Client Computers

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

Code:
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

Code:
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...
Reply With Quote
  #3  
Old 03-06-2009
SADIQ
 
Posts: n/a
Re: Script to change ODBC settings on Vista Client Computers

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...
Reply With Quote
  #4  
Old 03-06-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: Script to change ODBC settings on Vista Client Computers

Quote:
Originally Posted by Sadiq View Post
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!
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Script to change ODBC settings on Vista Client Computers"
Thread Thread Starter Forum Replies Last Post
Export ODBC settings Sarantsatsr Windows XP Support 3 15-12-2011 11:50 PM
Microsoft Access ODBC Driver for Vista 64 bit Richard Vista Help 4 14-06-2010 02:07 AM
How do i Change Windows Vista update settings Anwar Operating Systems 3 05-03-2009 02:13 PM
Vista Computers Unable to see other computers on LAN KaramChand Networking & Security 0 20-02-2009 08:21 PM
Script to move computers to another OU Antonio00 Active Directory 2 20-02-2009 04:23 PM


All times are GMT +5.5. The time now is 08:32 PM.