9:05 am Wednesday, August 20, 2008


  Navigation
  Help?
Contact Aaron for all inquiries.
 

  News

ASP Inline Calendar 3.9 Beta 1
ASP Games
ASP Inline Corporate Calendar 3.8 BETA 1 Demo
Calendar Updates
 

A Better World By Design
 
  Creating Your First ASP Page Tutorial
AaronOutpost : ASP / Tutorials / Setting Up a System DSN for an Access Database

Setting Up a System DSN for an Access Database
By: Aaron B. Copyright AaronOutpost.com

Open the ODBC Data Source Administrator

Windows 98 it is in Control Panel under 32bit ODBC

Windows 2000 it is in Control Panel, Administration Tools and Data Sources ODBC.
 

Windows 98 ODBC Icon Windows 2000 ODBC Icon

In ODBC Data Source Administrator select the tab System DSN

Click on the Add button (right hand side of the dialog box)

Another dialog box asking you to select a driver for the data source will appear and select the Microsoft Access Driver (*.mdb) driver from the list.

Then click on the next finish button and the bottom of the dialog box.
 


ODBC Microsoft Access Setup will appear. Set a name for the data source which will also be the name you use in your ASP scripts.

Click on the Select... button in the middle on the left.

Select Database on your hard drive for the database.
 


Click OK button and you should now see your new ODBC Data Source.
 

 

AaronOutpost : ASP / Tutorials / Setting Up a System DSN for an Access Database

Aaron Outpost West Virginia, USA A Mark of _-Squire-_ Creations Inc.  CopyrightŠ 2005 All Rights Reserved