Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

ADODB.Recordset.1 error '800a0bb9'

Posted 04 Sep 2005 07:54:29
1
has voted
04 Sep 2005 07:54:29 Malcolm X posted:
Hi to all. Can anyone help with the following error.

I have created a search.asp and results.asp page and continue to get this error when searching the access database.

----------------------------------------------------------------------------
ADODB.Recordset.1 error '800a0bb9'

The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

/html/results.asp, line 7
----------------------------------------------------------------------------

Line seven reads.

1 <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
2 <!--#include file="../Connections/connTimberseek.asp" -->
3 <%
4 Dim Recordset1
5 Dim Recordset1_numRows
6 Set Recordset1 = Server.CreateObject("ADODB.Recordset"
7 Recordset1.ActiveConnection = MM_connTimberseek_STRING
8 Recordset1.Source = "SELECT * FROM Suppliers"
9 Recordset1.CursorType = 0
10 Recordset1.CursorLocation = 2
11 Recordset1.LockType = 1
12 Recordset1.Open()
13 Recordset1_numRows = 0
14 %>
15 <%
16 Dim Repeat1__numRows
17 Dim Repeat1__index
18 Repeat1__numRows = 10
19 Repeat1__index = 0
20 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
21 %>

Can anyone help?

<b></b><b></b><b></b><b></b>

Reply to this topic