Classic ASP Discussion - ASP troubleshooting

Print Page | Close Window

ASP troubleshooting

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=2470
Printed Date: 29 March 2026 at 2:58pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ASP troubleshooting

Posted By: masson
Subject: ASP troubleshooting
Date Posted: 06 May 2003 at 3:23pm

I'm new to ASP and planning on writing a real program but I've started using the tutorial on using ASP with Access Database. The program is simple, it just lists records in a database

But I get the error:

Microsoft VBScript runtime error '800a01a8'
Object required: ''
/test/guestbook.asp, line 28

The code on line 28 looks like:

rsGuestbook.Open strSQL, adoCon

The preceeding lines are:

Set adoCon = Server.CreateObject("ADODB.Connection")

adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("guestbook.mdb")

strSQL = "SELECT tblComments.Name, tblComments.Comments FROM tblComments;"

I've tried looking up this error on technet and can't find anything. Any help would be great. Thanks!

Replies:

Posted By: ultramods
Date Posted: 06 May 2003 at 7:03pm

For every connection you need to create a objects to hold the connection and the recordset info.

Set rsGuestbook = Server.CreateObject("ADODB.Recordset")

Posted By: masson
Date Posted: 07 May 2003 at 7:02am

Thanks...Actually the line you listed was there, but I just couldn't see it. Must have been staring at the CRT way too long.