[Mono-dev] SqlConnection Pooling Problem?

[Tony Gu]

I got problem to use SqlConnection in mono-1.2.3.1 (seems on pooling).
It hangs on creating new SqlConnection(connectionString) if the "Min Pool Size" greater than 0.
Here is my connectionStrings:
<connectionStrings>
<add name="DefaultDb" connectionString="Data Source=MYDBSITE\DBSERVER; User Id=superuser; Password=mypasswd; Max Pool Size=15; Min Pool Size=3;Pooling=yes;" providerName="System.Data.SqlClient"/>
</connectionStrings>
If I change the "Min Pool Size" as "0", it can create the connection well, but only works the queries before close this connection (connection.Close()). The next time to use this connection (it is not null) will get the Exception "SQL Server does not exist or access denied.". If I restart the application it will execute the first (set) query(s). After close and reopen the connection, got same error.
The same web application runs OK on the early vewrsion(mono-1.1.18) without the "Pool Size" in the Web.Config. If I take the "Pool Size" off the config, the behave is same as "Min Pool Size=0".
Does anybody experience this problem?
 
Tony



 
____________________________________________________________________________________
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20070301/756ddf65/attachment.html