How to Setup Database DSN Connection

How to Setup Data Source Name (DSN) Connection in WinXP using MS-Access Database?

1. go to control panel

2. performance & maintenance

3. administrative tools

4. data source ODBC

click add button.

select driver for Microsoft Access.

Type Data Source Name, for instance we use MYDSNCON as shown from the picture below, then point your microsoft access database file that we are going connect with, at this time we used the AAS.mdb database, by clicking select button. after it done click ok

notice that MYDSNCON are now available from the list and ready to use as the name of your DSN connection. if you use it in Visual Basic just copy the name and paste it in your code.