When you think ASP, think...
Recent Articles
All Articles
ASP.NET Articles
Message Board
Related Web Technologies
User Tips!
Coding Tips

Sample Chapters
Commonly Asked Message Board Questions
JavaScript Tutorials
MSDN Communities Hub
Official Docs
Stump the SQL Guru!
XML Info
Author an Article
ASP ASP.NET ASP FAQs Message Board Feedback
Print this page.
Published: Wednesday, November 11, 1998

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.

- continued -

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

  • ASP.NET [1.x] [2.0] | ASPFAQs.com | Advertise | Feedback | Author an Article