change ODBC connection on all workstations

[mngl1500]

So does anyone know of an easy way to change the ODBC connections on all of my workstations to my new MS SQL server from my old one.

The sql server is running on a WIN 2003 server and the PDC is a Win 2003 SBS.
All of the Workstations are running XP Pro SP2. THe good news is I only have 25 or so workstations I would have to change the ODBC connection on if I end up having to go around to each one.

 

[anotherguy159]

Change the local DNS server to reflect the new IP of the server?

 

[MorfiusX]

You could script it with a VB script, or build an MSI that deploys it. Here is some info on scripting it:
http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov04/hey1110.mspx

 

[mngl1500]

MorfiusX

Thanks that is going to save me a trip to each workstation