Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2486
  • 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_WeaselSenior Software AnalystCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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