Database Discussion - ADODB.Recordset error �800a0cc1�

Print Page | Close Window

ADODB.Recordset error �800a0cc1�

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12284
Printed Date: 28 March 2026 at 1:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ADODB.Recordset error �800a0cc1�

Posted By: VBScript
Subject: ADODB.Recordset error �800a0cc1�
Date Posted: 22 October 2004 at 12:29pm

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/debug/forum/includes/Forum_Permissions.inc.asp, line 46

I am having a problem, I cant find out what the problem is. The items exist in the database

'Create ADODB Database Connection Object
Set PadoCon = Server.CreateObject("ADODB.Connection")

'Open database using ADODB Database Connection
PadoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strDBname

'Create database record object
Set rsPermissions = Server.CreateObject("ADODB.Recordset")

If CLng(lngSSID) = 0 Then
'There is no user so set lngSSID to unregistered
lngSSID = "UNREGISTERED"
Else
t1 = CLng(lngSSID)
lngSSID = t1
End If

'Define database query
PstrSQL = "SELECT tblPermissions.* FROM tblPermissions WHERE (StblPermissions.Group_ID=" & CLng(lngDBGroupID) & "OR tblPermissions.Member_ID=" & lngSSID & ") AND tblPermissions.Forum_ID=" & CLng(FID)

response.write lngDBGroupID & "*" & CLng(lngDBGroupID) & "*" & lngSSID

'Open database connection using query
rsPermissions.Open strSQL, PadoCon

If NOT rsPermissions.EOF Then
'Get permissions
response.write rsPermissions.RecordCount & FID
strView = rsPermissions("View")
strPost = rsPermissions("Post")
End If

'Close database connections
Set rsPermissions = Nothing
PadoCon.Close
Set PadoCon = Nothing
%>

Replies:

Posted By: Misty
Date Posted: 22 October 2004 at 1:26pm

Look at http://www.webwiz.net/asp/faq/access_database_faq.asp#FAQ8 - http://www.webwiz.net/asp/faq/access_database_faq.asp#F AQ8 . This will give you some information about the error that you are getting. You need to check all of your recordsets to make sure that they actually exist.

Posted By: VBScript
Date Posted: 22 October 2004 at 2:06pm

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

You were right but know i am getting this

Posted By: VBScript
Date Posted: 23 October 2004 at 4:57am

I have solved the problem