Knowledgebase
Error: ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Posted by DMXReady Admin on 18 May 2006 10:20 PM
Error:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
 
Solution:
This error usually indicates that
  1. The "Connections/*****.asp" file is missing and not included in the top of the page.

    For example:

    the following line should be located on the top of the "inc_paypalstoremanager.asp" page:

    <!--#include virtual="/Connections/paypalstoremanager.asp" -->


  2. You have made an error while editing the Connections/******.asp file for use with MySQL. Check the connection string and make sure all your parameters are correct.
 For example:
 
If you are modifying the Secure Login Manager connection string for MySQL, it should look like this:
 
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
MM_SecureLoginManager_STRING = "driver={mysql};database=*****;server=*****;uid=*****;pwd=*****;option=16386;"
%>
 
If you are modifying the Photo Gallery Manager connection string for MySQL, it should look like this:
 
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
MM_PhotoGalleryManager_STRING = "driver={mysql};database=*****;server=*****;uid=*****;pwd=*****;option=16386;"
%>
 
(1140 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Help Desk Software by Kayako dmxready.helpserve.com