odbc

mastermind2005

Hi all

Anyone know how to role out modifications to over 650 pc's with odbc settings without visiting individual pcs?

in windows xp 2003 enviroment?

Cheers

joePC

ODBC connections are stored in the registry so a simple script will do it.

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\

Apply all the DSN's on a PC & export the necessary keys.

Apply a startup script in AD to call the reg file and away you go.

Good luck

mastermind2005

Hey cheers for that answer, could you clarify

"Apply a startup script in AD to call the reg file and away you go"

a bit please

joePC

Write a bat script to call the exported reg file.

e.g.

---

@echo off

call \\server\folder\ODBC.reg

---

This will import / overwrite the ODBC settings.

I assume the PC's are part of a Domain? Apply a logon script to the users you want.

azzeretti

joePC wrote:

Write a bat script to call the exported reg file.

e.g.

---

@echo off

call \\server\folder\ODBC.reg

---

This will import / overwrite the ODBC settings.

I assume the PC's are part of a Domain? Apply a logon script to the users you want.

Not sure this will work,. This will prompt the users to import the reg settings, and if they don't have the correct permissions the import won't work. You will need to push it silently and to assume the appropriate permissions while doing it.
I think I remember doing this with a specialied ADM template, I'll see if I can dig it out.

joePC

True, if they have the correct premissions then add /S to sliently import the reg file.

If you need to run the script with admin privs have a look at http://www.commandline.co.uk/sanur/

Capt'n Midnight

use reg.exe to import the reg file

http://support.microsoft.com/kb/816819 - download links

Reg.exe is contained in \SUPPORT\TOOLS\SUPPORT.CAB on the Win2K