How to set up DSN for Database Access

How to set up DSN for Database Access

In order to setup DSN for database access in Windows 2000 for ADO (Active Data Object) or IIS manager, there are few steps to be followed :

Step 1

First of all, go to Administrative Tools then click on Data Sources (ODBC). ODBC configuration panel will appear as shown below:



There are a numbers of database drivers that existed. If your driver is not here, please check with database your vendor.

Step 2

Select Systen DSN and after that click on Add.

We are trying to setup up a system DSN that uses Access Database.

Step 3

To setup up a system DSN that uses Access Database select, select Driver do Microsoft Access (*.mdb) and click on Finish.

Step 4

Then key in the details of the System DSN that you have just created.

Step 5

To let the system know where’s the exact location of a Database, click on Select under Database section. From this dialog box, choose the location of your database.

Step 6

Click on OK. Upon returning to the previous menu, click on OK. Your system DSN is configured.