CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.

Knowledge Base

Breadrumbs:
>>Development (Web and Desktop) >> Web Development >> ASP (Active Server Pages)
ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type

Share With Friends ^{(Updated 6-8-2010)}

Article ID:
42
Date Created
Tuesday, November 16, 2010
Last Updated
Thursday, May 12, 2022
This Article Has been Viewed
1978 times
Short Desc
Using certian codes without the ADOVBS.inc file, you will notice that your code will contain errors that are sometimes hard to cypher through.
Details
When working with certain codes in your ASP page(s) you will need to add the ADOVBS.inc file as an INCLUDE to your page, if this file is missing or not provided or the proper code is not provided from the ADOVBS.inc file, then you will receive this error.

ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/paging.asp, line 22
Recreate Issue
To recreate this issue.

Using either of the following codes will generate the error if the ADOVBS.inc file is not included on your page.

<%
getSQL.Parameters.Append getSQL.CreateParameter("@ID", adInteger, adParamInput, , getS)
%>

<%
rsSearch.CursorLocation = adUseClient
%>
Resolve Issue
To correct this issue so that your page will run without any problems, make sure you have downloaded and added the ADOVBS.inc file to your project
Download here: ADOVBS.inc«.



Adding this file as an INLCUDE to your page with it located in the directory and running either of these scripts
<%
getSQL.Parameters.Append getSQL.CreateParameter("@ID", adInteger, adParamInput, , getS)
%>

<%
rsSearch.CursorLocation = adUseClient
%>

Will allow it to run without issue.

All Topics