ADO ConnectionString Maker for Available DSNs

Category:
Database
Type:
Snippets
Difficulty:
Intermediate
Author:
John Barker

Version Compatibility: Visual Basic 6

More information:
Using this example, you will create and edit ConnectionStrings based on all availiable DSN and ODBC Driver properties. For example, you can connect to an MS Access Database with 3 different ADO Providers. This code gives you a taste of the many variations of ADO ConnectionStrings that can be arranged with your system's ODBC settings.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: