ADO Connection and Recordset

This simple snippet demonstrates how to create and setup an ADO Connection to retrieve and display information from a database.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<% Option Explicit %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
  <head>
  <title>ADO: Connection and Recordset</title>
</head>
<body>
<%
  Dim MyConnection
  Dim MyRecordset
  Dim MyConnectionString
  Dim MySQLStatement

  MyConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=C:\Databases\WebSite.mdb;User Id=admin;Password="

  MySQLStatement = "SELECT ID, Column2, Column3 FROM MyTable ORDER BY ID"

  Set MyConnection = Server.CreateObject("ADODB.Connection")
  MyConnection.Open MyConnectionString
  Set MyRecordset = MyConnection.Execute(MySQLStatement)

  If Not MyRecordset.EOF Then
    Do While Not MyRecordset.EOF
      Response.Write("Item: " & MyRecordset.Fields(0).Value & "<br />")
      MyRecordset.MoveNext()
    Loop
  Else
    Response.Write("No Records Found") 
  End If

  MyRecordset.Close()
  MyConnection.Close()
  Set MyRecordset = Nothing
  Set MyConnection = Nothing
%>
</body>
</html>

Where to Next?

Wonder where to go next? You can read existing comments below or you can post a comment yourself on this article.

Doc ID 284
Full URL https://imar.spaanjaars.com/284/ado-connection-and-recordset
Short cut https://imar.spaanjaars.com/284/
Written by Imar Spaanjaars
Date Posted 05/09/2004 15:08
Date Last Reviewed 08/06/2006 13:54
Listened to when writing Bowtie (Postlude) by Big Boi (Track 19 from the album: Speakerboxxx)

Talk Back! Comment on Imar.Spaanjaars.Com

I am interested in what you have to say about this article. Feel free to post any comments, remarks or questions you may have about this article. The Talk Back feature is not meant for technical questions that are not directly related to this article. So, a post like "Hey, can you tell me how I can upload files to a MySQL database in PHP?" is likely to be removed. Also spam and unrealistic job offers will be deleted immediately.

When you post a comment, you have to provide your name and the comment. Your e-mail address is optional and you only need to provide it if you want me to contact you. It will not be displayed along with your comment. I got sick and tired of the comment spam I was receiving, so I have protected this page with a simple calculation exercise. This means that if you want to leave a comment, you'll need to complete the calculation before you hit the Post Comment button.

If you want to object to a comment made by another visitor, be sure to contact me and I'll look into it ASAP. Don't forget to mention the page link, or the Doc ID of the document.

(Plain text only; no HTML or code that looks like HTML or XML. In other words, don't use < and >. Also no links allowed.