Setting up a DSN

STEP 1

To setup a System DSN under Microsoft Windows you first go to Start->Settings->Control Panel and select "ODBC".

STEP 2

Choose the "System DSN" tab at the top of the window. Click on "Add…"

Step 3

Choose "Microsoft Access Driver" from the menu and click "Finish".

Step 4

Now just give your database connection a name in the "Data Source Name" field and a description in the "Description" field. In our case I chose "PHPTest" for the "Data Source Name". This is the name you will reference in your PHP database connection. Now click on "Select".

Step 5

Search for your Access .mdb (in our case "PHPTest.mdb"). Once you have found it select it and click "OK". Click "OK" again on the above screen and you are all set!