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
ekrinerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jimwassonConnect With a Mentor Commented:
This article shows in great detail how to do this with VBScript:

http://www.databasejournal.com/features/mssql/article.php/2238221
0
 
jonnietexasCommented:
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
0
 
Da_WeaselCommented:
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.
0
 
JamesNTCommented:
Agreed.  Thanks for the additional clarification.  Fortunately, I have only a dozen machines to deploy this too.

JamesNT
0
All Courses

From novice to tech pro — start learning today.