Solved

Script to install ODBC on workstations

Posted on 2010-11-08
7
766 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
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 68

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

760 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

19 Experts available now in Live!

Get 1:1 Help Now