| Author |
 Topic  |
|
|
endomorph
Junior Member
United Kingdom
128 Posts |
 Posted - 23 March 2010 : 02:35:34
|
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
|
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.” |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 23 March 2010 : 12:40:53
|
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 |
|
|
|
endomorph
Junior Member
United Kingdom
128 Posts |
Posted - 23 March 2010 : 12:45:33
|
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 |
|
|
| |
Topic |
|
Topic Locked
