'Object was open' when executing a stored procedure with large amounts of data.

• greg.wollman

  Old Hand

  Points: 331

  More actions

  June 13, 2008 at 7:10 am

  #381130

  I am getting an error 'Object was open' when executing a stored procedure with large 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

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 13, 2008 at 9:00 am

  #828584

  Seems like a client side issue. Nothing to do with SQL Server.

  
  * Noel