Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBScript to create a system DSN with username/password

Status
Not open for further replies.

mdProgrammer

Programmer
Oct 2, 2004
71
US
I'm searching for a script to create a DSN on a computer to automate setting up someone's PC for MS Access. I found one here - - but that doesn't have anything for username and password (I need SQL Server Authentication). Basically, I'm looking to do something like this -
CreateDSN.vbs <DSNName> <DataBaseName> <SQLServer> <User> <Password>
instead of this -
CreateDSN.vbs <DSNName> <DataBaseName> <SQLServer> <User>.
 
I've solved this - I added another line to the registry: "Trusted_Connection","Yes" and added a <Domain Name>\<User Group> user to SQL Server.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top