Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


  Return to Index