800A0BB9 error ?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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!