Configure Access Database ODBC using VB6 Code
Posted on 2003-12-07
Right now I have an application that uses an Access database and an ODBC connection using VB6.
I currently have to set up the ODBC configuration using Control Panel/ Administrative Tools/Data Sources (ODBC)/User DSN etc in Windows 2000.
This means that when I distribute the application I will have to get other users to go into Control Panel, and configure the ODBC and set the DSN for the proper database.
Has anyone figured out a way to do this from within VB6. It sounds like an API call(?) will be required...
I would like to have the user select the database and then have VB configure the DSN name and driver using code...