Web Wiz
  Knowledgebase Knowledgebase      Customer Login Customer Login


Setting Up a System DSN for an Access Database


Now we are going to make a DSN connection for the Classic ASP database tutorials to be able to connect to the database.

I shall assume that you have already created the 'guestbook.mdb' database described in, Connecting to an Access Database.

Well, first you need to open the 'ODBC Data Source Administrator' you will find it under 'Control Panel', 'Administration Tools' and it will be called 'Data Sources ODBC'.
Windows 2000 ODBC Icon
Once you open the ODBC Data Source Administrator select the tab 'System DSN' and click on the 'Add' button at the right hand side of the dialog box.

You will now see another dialog box asking you to select a driver for the data source. Select the 'Microsoft Access Driver (*.mdb)' driver from the list and then click on the next finish button and the bottom of the dialog box.
Create New Data Source dialog box
In the next dialog box 'ODBC Microsoft Access Setup', you will need to set a name for the data source, this will be the name you call from your ASP scripts, I have called this 'guestbook' to fit in with the database tutorials.

You will also need to click on the 'Select...' button in the middle on the left. From here you will be asked to 'Select Database', browse your hardrive for the database, for the tutorials this should be 'guestbook.mdb'.
ODBC Microsoft Access Setup dialog box
Next hit the OK button and you should now see your new ODBC Data Source.
ODBC Data Source Administrator


Share    


Become a Fan on Facebook Follow us on Twitter Find us on Google+ Community Forums Web Wiz Blogs Web Wiz News
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 5977755. Registered in England and Wales.
Registered office: Unit B10, 9 Nimrod Way, East Dorset Trade Park, Wimborne, Dorset, BH21 7UH, United Kingdom.

Prices exclude VAT unless otherwise stated. VAT No. 988999105 - $, € prices shown as a guideline only.


Copyright ©2001-2016 Web Wiz Ltd. All rights reserved.