ODBC settings for all users on one PC

  • Thread starter Thread starter Guest
  • Start date Start date
G

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



ronanpcs said:
We have a number of W2K machines we're setting up to run two SQL-based
Click to expand...
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
Click to expand...
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?
 
Back
Top