Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2481
  • Last Modified:

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
0
ekriner
Asked:
ekriner
1 Solution
 
jimwassonCommented:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now