This may or may not help:

http://www.inquiry.com/techtips/asp_pro/10min/10min0100/10min0100.asp





You are probably using the default forward-only type

recordset.   You need to specify dynamic recordsets,

altho this uses more system resources. 











--- Myle wrote:

> 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

>