Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
greg.wollman
Starting Member
5 Posts |
 Posted - 2008-06-06 : 17:41:29
|
| 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:=adCmdStoredProcIMPORTANT: 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 greatfullThanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-06 : 17:43:18
|
| This is not a SQL Server problem, but rather it's a problem in your application. Due to this, I would recommend posting your question in a VB 6 forum. SQL Server has no issue returning large amounts of data, but why would a client want so many rows returned?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
'Object was open' in SQL 2005