Click to See Complete Forum and Search --> : error 800a0bb9


yat
07-04-2008, 07:53 PM
An ASP line of script as follows :

objRS.Open "tblCustomerinfo", objConn,, adLockOptimistic, adCmdTable

does return the error 800a0bb9 as:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

What would need to correct here for that line of code to work ok ?
(I have seen to apparently include the file adovbs.inc but where?...and how? as I tried a number of ways without success...generating more errors, as well as looked a number of threads relating to that...but no real solution so far...)

If anyone knows better...much appreciated,thanks.

yamaharuss
07-05-2008, 07:11 AM
Looks like you have a double comma after objConn

yat
07-05-2008, 03:04 PM
Yes, you are right, there is a double comma and even when removed ,it does return the same error, no difference.
I found that to include the file adovbs.inc is a simple thing as it goes into the asp page on top as: <!--#include virtual=/adovbs.inc"--> or as:
<!--#include file="adovbs.inc" -->
The adovbs.inc is existing with all relevant constants.
Still it makes no difference and the error still here...
Looking at something else...

PS. this piece of code is a part of a script from www.aspwebpro.com and titled ' INSERT RECORD AND RETRIEVE UNIQUE ID ' ,and usually are very good script bases for testing, but this one returns an error which may have nothing to do with the script...continue the good work!...