[Mono-bugs] [Bug 61180][Nor] New - Odbc: Connection Pooling does not work.

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by sebastien.robitaille@croesus.com.

http://bugzilla.ximian.com/show_bug.cgi?id=61180

--- shadow/61180	2004-07-05 16:53:30.000000000 -0400
+++ shadow/61180.tmp.684	2004-07-05 16:53:30.000000000 -0400
@@ -0,0 +1,76 @@
+Bug#: 61180
+Product: Mono: Class Libraries
+Version: unspecified
+OS: Red Hat 9.0
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: Sys.Data
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: sebastien.robitaille@croesus.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Odbc: Connection Pooling does not work.
+
+Description of Problem:
+
+If connection pooling is activated in unixODBC, closing a second 
+connection throws an exception:
+
+System.Data.Odbc.OdbcException: Unable to retreive error information from 
+ODBC driver manager
+in <0x001b3> System.Data.Odbc.OdbcConnection:Close ()
+in <0x00087> MonoOdbcDataSetTest.Class1:TestConnections ()
+
+
+Steps to reproduce the problem:
+1. Activate Connection Pooling in unixODBC
+2. Execute the following code:
+
+try
+{
+	for(int nIndex = 0; nIndex < 1000; nIndex++)
+	{
+		IDbConnection dbConnection = new OdbcConnection
+(connectionString);
+		dbConnection.Open();
+		dbConnection.Close();
+		System.Console.WriteLine(nIndex);
+	}
+}
+catch(Exception exception)
+{
+	System.Console.WriteLine(exception.ToString());
+}
+
+
+Actual Results:
+0
+System.Data.Odbc.OdbcException: Unable to retreive error information from 
+ODBC driver manager
+in <0x001b3> System.Data.Odbc.OdbcConnection:Close ()
+in <0x00087> MonoOdbcDataSetTest.Class1:TestConnections ()
+
+
+Expected Results:
+0
+1
+2
+3
+4
+...
+999
+
+How often does this happen? 
+Always
+
+Additional Information:
+mono 1.0
+redhat9
+unixODBC
+freeTDS
+Sybase