SQL Server Performance

Connection error

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by alpossp, Oct 27, 2005.

  1. alpossp New Member

    Here is the problem:

    User is in Web Page and receives a time out during the execution of a Non -query

    User closes explorer and tries to enter the site again

    User receives a connection/data reader error stating that "There is already an open Data reader associated with this connection which must be closed first".

    We have added code to explicitly close connections in the finally clause of some catch logic.

    Any help?

    alpossp, Oct 27, 2005
    #2

  2. Luis Martin Moderator

    Take a look of:

    http://www.codingforums.com/showthread.php?t=67627



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Oct 27, 2005
    #2

  3. satya Moderator

    satya, Oct 28, 2005
    #2

Share This Page