Classic ASP Discussion - 800A0BB9 error ?

Print Page | Close Window

800A0BB9 error ?

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=6167
Printed Date: 31 March 2026 at 11:59am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: 800A0BB9 error ?

Posted By: aspday1
Subject: 800A0BB9 error ?
Date Posted: 05 October 2003 at 12:33am

I just followed the tutorial at
http://www.webwiz.net/asp/tutorials/connecting_to_a_dat abase_pt2.asp

but got an error message:
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/guestbook.asp, line 22

Here is from line 1 to 22:
<html>
<head>
<title>My First ASP Page</title>
</head>
<body bgcolor="white" text="black">
<%
'Dimension variables
Dim adoCon        'Holds the Database Connection Object
Dim rsGuestbook   'Holds the recordset for the records in the database
Dim strSQL          'Holds the SQL query to query the database

'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using a DSN-less connection
'adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("guestbook.mdb")

'Create an ADO recordset object
Set rsGuestbook = Server.CreateObject("ADODB.Recordset")

'Open the recordset with the SQL query
rsGuestbook.Open strSQL, adoCon

Thanks!

Replies:

Posted By: fernan82
Date Posted: 05 October 2003 at 2:57am

It looks like you forgot to write your SQL query...

strSQL = "SELECT blah FROM whatever blah blah....

or whatever....

-------------
FeRnAN
http://www.danasoft.com/">