Click here to monitor SSC

'Object was open' error in SQL 2005

Last post 09-09-2009, 1:36 PM by dc4444. 2 replies.
Sort Posts: Previous Next
  •  06-06-2008, 5:40 PM Post number 59059

    'Object was open' error in SQL 2005

    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

  •  06-07-2008, 7:34 AM Post number 59123 in reply to post number 59059

    Re: 'Object was open' error in SQL 2005

    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).
  •  09-09-2009, 1:36 PM Post number 74781 in reply to post number 59123

    Re: 'Object was open' error in SQL 2005

    Is their a solution to solve this?
View as RSS news feed in XML