Arguments are of the wrong type???

[EvertonFC]

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.

 

[damber]

You can't use nested SELECTs in MS Access - try using the free SQL SErver 2005 EXpress Edition instead - most of the standard features of SQL Server 2005 (though limited by scale) but none of the cost. Or the free Oracle Express edition, or the free DB2 express edition - or even MySQL, PostGreSQL.

If you want to spend some more money on your hosting, or server licensing, then you could even buy the real things.

In any case they're all better than MS Access.

SQL Server

http://www.microsoft.com/sql/editions/express/default.mspx

DB2

http://www-306.ibm.com/software/data/db2/udb/db2express/download.html

Oracle

http://www.oracle.com/technology/products/database/xe/index.html

A smile is worth a thousand kind words. So smile, it's easy!

 

[EvertonFC]

Many thanks Damber!