Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    72

    Unanswered: Arguments are of the wrong type???

    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.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    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:
    Last edited by Bullschmidt; 02-07-06 at 20:48.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •