Create Your DSNs at Runtime
Version Compatibility: Visual Basic 6
This easy to implement snippet of code sets up your DSN (datasource name) at runtime. Before running this code, be sure to set Sub Main() as the startup object and change the database name and login info as needed.
Instructions: Copy the declarations and code below and paste directly into your VB project.