Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Operation is not allowed in this context.
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 23 March 2010 :  02:35:34  Show Profile
I have recently upgraded from Access to MySQL and am getting -

ADODB.Recordset error '800a0c93'

Operation is not allowed in this context.

/forum/topic.asp, line 392

Line 392 is

arrReplyData = rsReplies.GetRows(intGetRows)



Anyone have any ideas ?

After a little investigation, it appears to possibly be a problem with the cursor type.

The query before the faulty line is -

rsReplies.Open strSql & strSql2 & strSql3 & strSql4 & strSql5, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText


Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation

Edited by - endomorph on 23 March 2010 02:45:22

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 23 March 2010 :  04:52:37  Show Profile
Can you post a link to a *.txt copy of your topic.asp file so's we can have a look at the surrounding code?


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 23 March 2010 :  06:37:39  Show Profile  Visit HuwR's Homepage
checkout some of these posts too
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=61812
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=60741
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts

Posted - 23 March 2010 :  12:40:53  Show Profile  Visit modifichicci's Homepage
change

if iPageTotal > 0 then
set rsReplies = Server.CreateObject("ADODB.Recordset")
rsReplies.Open strSql & strSql2 & strSql3 & strSql4 & strSql5, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText

to

if iPageTotal > 0 then
set rsReplies = Server.CreateObject("ADODB.Recordset")
rsReplies.CursorLocation=AdUseClient
rsReplies.Open strSql & strSql2 & strSql3 & strSql4 & strSql5, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText

adding the red line

Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 23 March 2010 :  12:45:33  Show Profile
Solved.

Well sort of. After reading some of the quoted posts, I ran a "Update Forum Counts" and it all works fine !

Strange ....

Thanks anyway guys

Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000 Version 3.4.07