Solved

Script to install ODBC on workstations

Posted on 2010-11-08
7
806 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 70

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

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

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

738 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