none
Timeout on query with blob data RRS feed

  • Question

  • We've recently started having a problem querying tables with blob data from SQL Server Management Studio. If I try and select even just one row, after a few minutes I get this error:

     

    SQL Execution Error.

     

    Executed SQL Statement: ...

    Error Source: System.Data

    Erroy Message: Invalid attempt to Read when reader is closed.

     

    It seems to be some sort of timeout error, if I query the row and select the other columns that don't contain blob data, the result is returned fine. If I remote the machine that the database is on and do the query, the result is returned just fine. Likewise, when I exported the tables to a database running from my workstation, I can pull the data, but it seems that querying the databases remotely is causing a problem. Any ideas? We've only been having this problem for a week or so, but it's happening on all of our servers.

     

     

    Friday, August 3, 2007 5:29 PM