Home Forums SQL Server 2008 SQL Server 2008 Administration Connection pooling troubleshooting in SQL 2008, client unable to reuse a session with SPID... RE: Connection pooling troubleshooting in SQL 2008, client unable to reuse a session with SPID...

  • GabyYYZ (12/10/2009)


    Gift Peddie (12/10/2009)


    GabyYYZ (12/10/2009)


    Gift Peddie (12/10/2009)


    The error you are getting says two things your databases are in compatibility 80 and your application is also old because this problem is fixed for SQL Server 2008 and .NET 3.5. So change to compatibility 100 and rewrite your connection code if your Asp.net application is Asp.net 2.0 because Asp.net 3.5 compiles as 2.0.

    Compatibility was changed from 80 to 100. As for the asp.net 3.5 issue, I'll forward the info to the developers, but was wondering if you had some URL's where you got this information from so I can help them troubleshoot it.

    Thanks.

    Here is the link go to the section that says extension added to SQL Server 2008 and it also says you don't have to make changes to the code but I think the code needs to be checked to make changes as needed to the connection pooling code.

    I almost forgot if the shopping cart is commercial version look into the code used to consume the cart transaction object.

    http://msdn.microsoft.com/en-us/library/ms172070.aspx

    Thanks, I have been scratching my head trying to find a link that talks about this explicitly and I've forwarded it to our developers. As the web servers don't seem to be impacted, I'm downgrading our alerts so we still receive them, but I'm just not paged at 3am. 😀 It's also possible, due to holiday traffic, that greater spikes mean the potential for more issues on the network.

    Microsoft changed the title and docs so anybody can use it, the transaction can be nested at the point of connection. I think minor changes can help you handle the holiday traffic.

    Kind regards,
    Gift Peddie