Solved

Script to install ODBC on workstations

Posted on 2010-11-08
7
801 Views
Last Modified: 2012-05-10
I want to roll out an ODBC connection across many workstations that are running Windows XP, VIsta and Windows 7. Can someone send me a sample script that will write this to the registry and not overwrite what is already there?
0
Comment
Question by:tdx2000
7 Comments
 
LVL 11

Accepted Solution

by:
N R earned 125 total points
ID: 34085485
0
 

Author Comment

by:tdx2000
ID: 34106830
I tried the link and I get a Windows script host error. At line 54, Char95 Error Syntax. How do I fix this?
0
 

Author Comment

by:tdx2000
ID: 34121220
I was able to get the script to work but I need to change it from being a trusted connection to use SQL authentication and then allow me to enter the login ID and the password. Please Help.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 69

Expert Comment

by:Qlemo
ID: 34127253
Just change the two variables LastUser to your respective user and Trusted_connection to "No".
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 34129686
0
 

Author Closing Comment

by:tdx2000
ID: 34139831
I was able to use the script to push the odbc connections out with the script. I just had some wrapping issues that once I figured that out it worked great.
0

Featured Post

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

680 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