How to create a System DSN for Access database
You can connect to an Access database within
an ASP page with different methods. This article will help you to create a System
Data Source Name (DSN) for an Access database on your local machine.
Open Control Panel window, you will see different icons as shown in Pic 1.
Doubble click on ODBC Data Source Administrator icon.
Pic 1.
Now you will see ODBC Data Source Administrator window (as shown below).
Select System DSN tab, and click Add.
Pic 2.
To Create a new DSN for an Access database, Select Microsoft Access Driver(*.mdb)
and click Finish.
Pic 3.
Now you need to enter a DSN name that you like to use, I am using MyDSN.
You have different options here. If you have already created an Access database
you can select for this DSN or you can create a new Access database. Select the
database you have created and Click ok.
If you like you can supply default login name and password by clicking on Advance
button.
Pic 4.
You will be able to see your new DSN in the list of System DSN.
Click ok.
Pic 5.
After a System DSN has been created you can use it within any ASP page located
on the same computer.
Connecting to database with DSN Connection
Have Questions? Discuss this topic in Dev
Forum
| 
