Hello

I am getting the following error message:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/faq/inc_search_form.asp, line 6

The error message refers to this asp file:

<!--#include file="Connections/connDUfaq.asp" -->


<%
set rsCount = Server.CreateObject("ADODB.Recordset")
rsCount.ActiveConnection = MM_connDUfaq_STRING
rsCount.Source = "SELECT (SELECT COUNT(*) FROM FAQS) AS FAQ_COUNT, COUNT(*) AS TYPE_COUNT FROM TYPES"
rsCount.CursorType = 0
rsCount.CursorLocation = 2
rsCount.LockType = 3
rsCount.Open()
rsCount_numRows = 0
%>

so this line, seems to be the culprit:

rsCount.ActiveConnection = MM_connDUfaq_STRING


My connection string (which was not the original connection string in this customised script), is:

<%

Set MyConn = Server.CreateObject("ADODB.Connection")

MyConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=D:\business\abc.com\private\DUfaq.mdb;"

%>

I would be grateful for any advice.

Many thanks.

Quetzal.

That message usually means that there is something wrong in the SQL statement:

rsCount.Source = "SELECT (SELECT COUNT(*) FROM FAQS) AS FAQ_COUNT, COUNT(*) AS TYPE_COUNT FROM TYPES"

And for a related article:

http://www.aspfaq.com/search.asp?q=800a0bb9&x=11&y=10: