RE: SQL Connection Problems

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steven Cheng[MSFT] (v-schang_at_online.microsoft.com)
Date: 08/05/04 

Date: Thu, 05 Aug 2004 03:15:58 GMT

Hi Warren,

>From the callstacks and error infos you provided, especially the following
lines
==============================
 Error message: There is already an open DataReader associated with
this Connection which must be closed first.
==============================

I think there are two possible causes(since your SQLSERVER is MSDE rather
than server version)
1. There is any code in your web app which doesn't close and release the
opened connection correctly after finish the db maniplulation. For example,
when you're not using the
try{...}catch(){..}finally{release db conn}
or
using(conn = new connection)
{

}

to ensure the release of connection resource, when there is exception occur
during the code, the connection may be locked. this is a potential cause.
So please check this in your code first.

2. Since the MSDE version is a desktop engine, it has its limited
concurrent connections , not sure whether the problem is caused when there
is too many concurrent request on the db manipulate page, you can also have
a check. And here is a tech article discussing on using MSDE in web
application:

#Using MSDE 2000 in a Web Application
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde2kwrk
/html/msde2000webapp.asp

You can have a look to see whether it helps. Also, if you have any new
findings, please feel free to post here. Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx

Relevant Pages

  • RE: Multiprotocol Encryption Through a Firewall
    ... Remote SQL Server 2000 (MSDE 2000) through a firewall with only a single ... connection to a remote SQL Server and I wanted to share the ... Encryption checkbox. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Express Edition 2005
    ... The error codes were not the best when it came to the this area in MSDE. ... I thought there is some hard code of connection in the software ... If you need 25 concurrent connections ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Express Edition 2005
    ... Jasper Smith (SQL Server MVP) ... I thought there is some hard code of connection in the software ... > because when I stress test to the MSDE, I have found the return error code ... If you need 25 concurrent connections ...
    (microsoft.public.sqlserver.connect)
  • Re: Crystal reports problem
    ... >> I also posted this to the CR newsgroup, but I think it might be an MSDE ... >> VB .Net for program development. ... >> the Business Solutions help and found that the database server needs to ... >> set up with a trusted connection. ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE and Sql Server Connection String
    ... to all SQL Server databases--especially those hosted on XP. ... MSDE is configured for mixed mode security if you plan to log on with SQL ... > www.connectionstrings.com and try several of the odbc and oledb connection ... >> We have one small client who is running MSDE. ...
    (microsoft.public.dotnet.framework.adonet)