I am getting an error 'Object was open' when executing a stored procedure with larger am amounts of data. This procedure runs from a VB 6.00 application on SQL 2005. When running the script in SQL there is no problem

rs.Open cmd, Options:=adCmdStoredProc

IMPORTANT: This error ONLY happens with large amount of data. The threshold level is about 250000 rows of data. If more than that amount of data is retreived the error occurs. If less then there is no problem.

Any suggestion would be greatfull

Thanks

I suspect that this is an OLE DB error,

   0x80040E05  -2147217915  An object was open

not a SQL error, which is why it works fine in SQL
e.g.
OLE DB provider "SQLNCLI" for linked server "xxxx" returned message "Object was open."
I've never experienced it myself but I gather that it usually happens when you run more than one data flow in parallel which have lookups on the same table The error occurs while resynchronizing a row, but at least one row was successfully resynchronized. The error refers to a storage object that it was trying to open being already open (because, persumably, both lookups share the same buffer area).