PDA

View Full Version : ADODB.Recordset.1 error '800a0bb9'


malhyp
09-04-2005, 05:39 AM
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?

ranjan
09-04-2005, 09:03 AM
Looks like a permissions problem

http://www.webwizguide.info/asp/faq/server_permissions.asp ('http://www.webwizguide.info/asp/faq/server_permissions.asp')

malhyp
09-05-2005, 09:31 AM
Looks like a permissions problem

http://www.webwizguide.info/asp/faq/server_permissions.asp ('http://www.webwizguide.info/asp/faq/server_permissions.asp')
Thanks for the reply. The link was helpful..

Cheers.