Link to home
Start Free TrialLog in
Avatar of ekriner
ekriner

asked on

Deploying ODBC settings

Hello,
 
Is there a way to deploy ( via a batch file or a script ) ODBC setting on multiple workstations.
This ODBC setting has to be a system DSN
 
 
Thanks
ASKER CERTIFIED SOLUTION
Avatar of jimwasson
jimwasson

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jonnietexas
jonnietexas

You might just export the Registry for that particular setting and then run the reg file on each of the PC's via the login script
I know this is closed already but just thought I would add some clarity to it

Clients have unique ODBC settings:
You need to generate unique ODBC settings for each machine then you should write a script to create the ODBC settings progmatically.

Clients have identical settings:
Create your ODBC entries
Export the necessary entries in [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]
Execute the reg file(s) from your logon script

Is most cases the registry option is the best and simplest solution.
Agreed.  Thanks for the additional clarification.  Fortunately, I have only a dozen machines to deploy this too.

JamesNT