• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Connection String Generator

Connection String Generator

by Leo Mrozek (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Beginner
Date Added: Wed 3^rd February 2021
Rating: (9 Votes)

These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script.
The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.

Assumes
Assumes that you know the basic parameters to connect to the database you need to connect to (i.e. Login, Password, Server, database name, etc)

Download Connection String Generator

Download Connection String Generator (385 Bytes)

Connection String Generator Comments

No comments have been posted about Connection String Generator. Why not be the first to post a comment about Connection String Generator.

Post your comment