• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 827
  • Last Modified:

Script to install ODBC on workstations

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
tdx2000
Asked:
tdx2000
1 Solution
 
tdx2000Author Commented:
I tried the link and I get a Windows script host error. At line 54, Char95 Error Syntax. How do I fix this?
0
 
tdx2000Author Commented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Just change the two variables LastUser to your respective user and Trusted_connection to "No".
0
 
tdx2000Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now