To read the article online, visit http://www.4GuysFromRolla.com/webtech/111198-1.shtml

Using ASP to Connect to an Access Database


Active Server Pages allows you to interact with any ODBC-compliant database, be it SQL Server, Access, Oracle, or Informix. Often times developers are connecting to a SQL Server database, but there are many who are connecting to Access databases as well. This article, written by Gary Van Sluis, describes how to connect to an Access database.

For the accompanying source code to work, you will need to implement the following steps:

  • 1.) Create ODBC Settings wtih DSN name = Northwind
  • 2.) Copy "Employee Sales By Country" Query and Rename it to "Employee" (had some problems with spaces in names so I use just one name with no spaces)
  • 3.) Cut and pasted following code samples to two pages (proc.asp) and (proc2.asp)
  • 4.) And sample away
  • There are two files which you will need: Proc.asp and Proc2.asp. Here is the source code:

  • Proc.zip
  • Proc2.zip

  • Article Information
    Article Title: 4GuysFromRolla.com - Using ASP to Connect to an Access Database
    Article Author: Gary Van Sluis
    Published Date: Wednesday, November 11, 1998
    Article URL: http://www.4GuysFromRolla.com/webtech/111198-1.shtml


    Copyright 2017 QuinStreet Inc. All Rights Reserved.
    Legal Notices, Licensing, Permissions, Privacy Policy.
    Advertise | Newsletters | E-mail Offers