ODBC settings for all users on one PC

[Guest]

We have a number of W2K machines we're setting up to run two SQL-based applications that require two ODBC settings to be set up. These same machines will be shared by 4-6 users covering for each other and running these applications

Is there a way to set the ODBC settings on the PC so that they only have to be entered once instead of having to be individually entered for each user? Can Group Policy on the PC be used to manage ODBC settings

Jeff Ronan

 

[MS Newsgroups]

The easiest way to set up system DSN:s is to simply add them to the registry
through a logon script. Create the DSN:s manually on a template machine and
document the settings. Then you could script something like:

Dim oShell

Set oShell=createobject("Wscript.shell")
oShell.regwrite="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MyDSN\Driver","C:
\WINDOWS\System32\SQLSRV32.dll","REG_SZ"
oShell.regwrite="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MyDSN\Trusted
Connection",Yes","REG_SZ"

I am sure you can figure out the rest.....

Let me know if you need further info on the scripting bit

Regards

Niclas Lindblom

We have a number of W2K machines we're setting up to run two SQL-based

applications that require two ODBC settings to be set up. These same
machines will be shared by 4-6 users covering for each other and running
these applications.

Is there a way to set the ODBC settings on the PC so that they only have

to be entered once instead of having to be individually entered for each
user? Can Group Policy on the PC be used to manage ODBC settings?