How to Connect Database Using ODBC (Object Database Configuration/Connectivity)

This ODBC method is applicable to Visual Basic .Net and Visual Basic 6.0 using MS Access Databse (.mdb). Please follow the instructions below on how to setup database.
1.  Click Start button, and select Control Panel

2. Once the control panel open, please double click Administrative Tools.

Note: If you can't locate the the administrative tools, please select Classic View at the left side of the control panel pane.

 
 
 
 
 
 
 
 
 
 
 
 
 
 



3. Under the Administrative Tools, double click to select the Data Sources (ODBC) as shown the image below.  After selecting the Data Sources, the ODBC panel window will display.

4. Now we are going to add new datasebase, click Add button and new window willl appear "Create New Data Source", select the Driver do Microsoft Access (*.mdb) for MS Access, click Finish Button.

5. We're almost done, let's configure the ODBC for MS Access, under Data Source Name, type the  MyDatabase, please leave blank the description it's optinal. Now, let's select the path of your database .mdb once you found it select OK button.

6. The image shown below that the Database .mdb is successfully located. Click OK button to Finish the configuration. (MS Access Database Configuration done).

7. Done! You are now ready to connect your visual basic program using this ODBC setup.

Thank you for reading this article How to Connect Database Using ODBC (Object Database Configuration/Connectivity) With URL http://x-tutorials.blogspot.com/2011/06/how-to-connect-database-using-odbc.html. Also a time to read the other articles.