November 18, 2008 at 5:26 pm
Hi all,
User has reported an error from the application error log:
SQL Code:|0|SQL Error:|(0) - [Microsoft][ODBC SQL Server Driver]Invalid cursor position|
Read on MLIST: ||||
MLIST is a table, I believe the code is reading this table and throwing this error.
Has anyone come across this error before???
Thanks a lot.
November 18, 2008 at 5:48 pm
November 18, 2008 at 7:24 pm
Hi JP, thanks for the link. But I still do not know how I can get through this. Is it specifically because of GetChunk method?? I'm also not sure what this method does.
Sorry I'm very new to SQL Server. If anyone can give me any suggestion, I will greatly appreciate it.
Is there any logs in SQL server, where I can look into more details of the error?? Because this error I got from the application end.
Thank you very much.
November 19, 2008 at 7:25 am
Hi,
I just looked at the SQL Code on the application side. It is a 50lines code and straightforward, basically does:
select * from mlist where col1= value, col2=value
execute begin
insert into slist values ( ) --The record read above is being
inserted here into this new
table slist.
delete from mlist where --The record is deleted in mlist.
commit work;
unlock mlist;
unlock slist;
-- There are 4000 records in mlist for the where clause condition. But only 2000 records have been inserted into slist. When we close the session and open a new session and run the code, the rest of 2000 records are inserted.
Could be any resource issue?? Or is it possible to increase number of cursors, if that may be the cause?
Thank for all your help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply