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

Sections:
Sample Chapters
Commonly Asked Message Board Questions
JavaScript Tutorials
MSDN Communities Hub
Official Docs
Security
Stump the SQL Guru!
XML Info
Information:
Feedback
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] | ASPMessageboard.com | ASPFAQs.com | Advertise | Feedback | Author an Article