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.
Database Connectivity

A couple of good articles have already been written which describe how to connect to a database. These articles are available at the bottom of this article. Before you read on, let me give a quick overview.

Connecting to a Database:

  • Using a System DSN
    1.) Create a system DSN using the ODBC Wizard in the Control Panel
    2.) Connect to the database using a simple connection string: "DSN=System DSN Name"
  • Using a DSN-less connection (You can use other databases than Access, but the majority of articles and examples only use Access databases when showing how to establish a DSN-less connection)
    1.) Place the Access database file (the *.mdb file) in a web-shared directory
    2.) The connection string is a bit more complex. You need to specify two things: the driver and the physical location of the file (i.e.: C:\WebShare\wwwroot\mydatabase.mdb)

    (If the above makes absolutely no sense to you, don't worry, just read through these articles!)

    Database Connectivity Articles:

  • Connecting to a Database
  • Connecting to an Access Database using ASP
  • A Quick Overview on Connecting to a Database

    Happy Programming!

    FAQ Table of Contents   Database Connectivity: An Overview SQL, the Language of Databases 

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