|
 |
asp_databases thread: Error
Message #1 by mriemann@b... on Mon, 24 Feb 2003 20:10:36
|
|
I am getting this error message when running my asp script.
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
SDelete.asp, line 49
This is the statement at line 49.
oRLog.Open "tblLogScheduleUpdates",oConn,adOpenKeyset,adLockOptimistic
Any ideas.
Thanks
Matt
Message #2 by "Ken Schaefer" <ken@a...> on Tue, 25 Feb 2003 10:39:34 +1100
|
|
www.adopenstatic.com/faq/800a0bb9.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <mriemann@b...>
Subject: [asp_databases] Error
: I am getting this error message when running my asp script.
:
: Error Type:
: ADODB.Recordset (0x800A0BB9)
: Arguments are of the wrong type, are out of acceptable range, or are in
: conflict with one another.
: SDelete.asp, line 49
:
: This is the statement at line 49.
:
: oRLog.Open "tblLogScheduleUpdates",oConn,adOpenKeyset,adLockOptimistic
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by "Sagar" <sagarjv@h...> on Tue, 25 Feb 2003 10:11:29 +0800
|
|
Hi,
Instead of using Type, use Constants in the ur statement(oRLog.Open "tblLogScheduleUpdates",oConn,adOpenKeyset,adLockOptimistic)
Cursor Type
Type - Constatnt
adOpenDynamic - 1
adOpenForwardOnly - 2
adOpenKeyset - 3
adOpenStatic - 4
adOpenUnspecified - 5
Lock Type
Type - Constatnt
adLockBatchOptimistic - 1
adLockOptimistic - 2
adLockPessimistic - 3
adLockReadOnly - 4
adLockUnspecified - 5
Hope it solves ur problem.
Bye,
Sagar
----- Original Message -----
From: <mriemann@b...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, February 24, 2003 8:10 PM
Subject: [asp_databases] Error
> I am getting this error message when running my asp script.
>
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
> SDelete.asp, line 49
>
> This is the statement at line 49.
>
> oRLog.Open "tblLogScheduleUpdates",oConn,adOpenKeyset,adLockOptimistic
>
> Any ideas.
>
> Thanks
>
> Matt
>
Message #4 by "Matt Riemann" <mriemann@b...> on Tue, 25 Feb 2003 08:25:27 -0800
|
|
Thanks
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Monday, February 24, 2003 3:40 PM
To: ASP Databases
Subject: [asp_databases] Re: Error
www.adopenstatic.com/faq/800a0bb9.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <mriemann@b...>
Subject: [asp_databases] Error
: I am getting this error message when running my asp script.
:
: Error Type:
: ADODB.Recordset (0x800A0BB9)
: Arguments are of the wrong type, are out of acceptable range, or are
in
: conflict with one another.
: SDelete.asp, line 49
:
: This is the statement at line 49.
:
: oRLog.Open "tblLogScheduleUpdates",oConn,adOpenKeyset,adLockOptimistic
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
 |