Solved

Deploying ODBC settings

Posted on 2004-09-02
4
2,441 Views
Last Modified: 2011-10-03
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
Comment
Question by:ekriner
4 Comments
 
LVL 7

Accepted Solution

by:
jimwasson earned 500 total points
Comment Utility
This article shows in great detail how to do this with VBScript:

http://www.databasejournal.com/features/mssql/article.php/2238221
0
 
LVL 4

Expert Comment

by:jonnietexas
Comment Utility
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
 
LVL 3

Expert Comment

by:Da_Weasel
Comment Utility
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
 

Expert Comment

by:JamesNT
Comment Utility
Agreed.  Thanks for the additional clarification.  Fortunately, I have only a dozen machines to deploy this too.

JamesNT
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

A common practice in small networks is making file sharing easy which works extremely well when intra-network security is not an issue. In essence, everyone, that is "Everyone", is given access to all of the shared files - often the entire C: drive …
I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now