Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Script to install ODBC on workstations

Posted on 2010-11-08
7
Medium Priority
?
815 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 12

Accepted Solution

by:
Nathan Riley earned 375 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
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
LVL 71

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
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 to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

688 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