Revising ODBC Settings

[bgfs]

I intend to move an SQL database from one server to another (using Backup and restore). Clients connect via ODBC. as there are a large number of clients, does anyone know of an automated process where the ODBC settings can be changed on the client PC's?

 

[ptheriault]

Create a bat file with the following command. It should update the ODBC settings. then you can push it out to all users with SMS or whatever tool your company uses.

REM ****** Create new MSSQL connection ***********************

C:\REG UPDATE "HKLM\Software\ODBC\ODBC.INI\YOUR ODBC  NAME\Server=New Server"

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[bgfs]

Thanks I'll give it a Try