|
 |
asp_databases thread: Couln't use method "MovePrevious"
Message #1 by "Myle" <Myle.Pham@n...> on Mon, 10 Apr 2000 17:48:8
|
|
Please help!!!!!!!!
There was something wrong in my connection which did not allow me to use
the MovePrevious method.
The error message was:
ADODB.Recordset error '800a0c93'
The operation requested by the application is not allowed in this context.
Code In my Global.ASA
Sub Session_OnStart()
SET DbObj = Server.CreateObject("ADODB.Connection")
Set Session("connectdb") = DbObj
End Sub
Other codes
sUid = trim(request.form("Login"))
sPassword = trim(request.form("Password"))
Session("connectdb").Open "DSN=OrclCoreTest;UID=" & sUid & ";PWD=" &
sPassword & ";"
strQuery = "Select customerID......."
SET oRs = Server.CreateObject("ADODB.Recordset")
oRs.Open strQuery, Session("connectdb"),adOpenStatic, , 1
'
'
'
oRs.MovePrevious (this is the problem line)
Appreciated very much in advance
---
Message #2 by David Sussman <davids@i...> on Tue, 11 Apr 2000 09:11:23 +0100
|
|
This might be related to the cursor types. Some cursor types don't allow
moving backwards through the recordset. In general Static does, but I've
not tried it against Oracle. To check it do this:
If oRs.Supports(adMovePrevious) Then
' move previous is supported
If it isn't supported then pick another cursor type.
As an aside, I'd recommend removing the session storage of the
connection. This will cause great scalability problems. ADO has
connection pooling so it's more efficient to open and close the
connection in each page.
Dave
"Myle" wrote in message
news:<6553BCF3E25DD2118F0A00AA00AE6AAA221CD1@t...>...
> Please help!!!!!!!!
>
>
> There was something wrong in my connection which did not allow me to
use
>
> the MovePrevious method.
>
> The error message was:
> ADODB.Recordset error '800a0c93'
> The operation requested by the application is not allowed in this
> context.
>
>
>
>
> Code In my Global.ASA
> Sub Session_OnStart()
> SET DbObj = Server.CreateObject("ADODB.Connection")
> Set Session("connectdb") = DbObj
> End Sub
>
> Other codes
> sUid = trim(request.form("Login"))
> sPassword = trim(request.form("Password"))
>
> Session("connectdb").Open "DSN=OrclCoreTest;UID=" & sUid & ";PWD=" &
> sPassword & ";"
>
>
> strQuery = "Select customerID......."
>
> SET oRs = Server.CreateObject("ADODB.Recordset")
> oRs.Open strQuery, Session("connectdb"),adOpenStatic, , 1
>
> '
> '
> '
> oRs.MovePrevious (this is the problem line)
>
>
> Appreciated very much in advance
>
>
>
> ---
>
> ---
> You are currently subscribed to asp_databases
> $subst('Email.Unsub')
Message #3 by "werner teunissen" <werner@t...> on Mon, 10 Apr 2000 19:36:21 +0200
|
|
i don't have any solution at all but i do want to point you at the fact that
some people maybe disabled the feature of storing session based cookies on
their drive...in this way they would never be able to use any session based
variable i think..
----- Original Message -----
From: "Myle"
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, April 10, 2000 17:00
Subject: [asp_databases] Couldn't use method "MovePrevious"
> Please help!!!!!!!!
>
>
> There was something wrong in my connection which did not allow me to use
> the MovePrevious method.
>
> The error message was:
> ADODB.Recordset error '800a0c93'
> The operation requested by the application is not allowed in this context.
>
>
>
>
> Code In my Global.ASA
> Sub Session_OnStart()
> SET DbObj = Server.CreateObject("ADODB.Connection")
> Set Session("connectdb") = DbObj
> End Sub
>
> Other codes
> sUid = trim(request.form("Login"))
> sPassword = trim(request.form("Password"))
>
> Session("connectdb").Open "DSN=OrclCoreTest;UID=" & sUid & ";PWD=" &
> sPassword & ";"
>
>
> strQuery = "Select customerID......."
>
> SET oRs = Server.CreateObject("ADODB.Recordset")
> oRs.Open strQuery, Session("connectdb"),adOpenStatic, , 1
>
> '
> '
> '
> oRs.MovePrevious (this is the problem line)
>
>
> Appreciated very much in advance
>
>
>
> ---
>
> ---
> You are currently subscribed to asp_databases
$subst('Email.Unsub')
|
|
|
View Cart
