[Mono-bugs] [Bug 75345][Wis] New - SQLFreeHandle error

[bugzilla-daemon at 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 ndo at rockwellcollins.com.

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

--- shadow/75345	2005-06-21 21:04:46.000000000 -0400
+++ shadow/75345.tmp.9309	2005-06-21 21:04:46.000000000 -0400
@@ -0,0 +1,88 @@
+Bug#: 75345
+Product: Mono: Class Libraries
+Version: 1.0
+OS: 
+OS Details: SuSE 9.2
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Wishlist
+Component: Sys.Data
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: ndo at rockwellcollins.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: SQLFreeHandle error
+
+Please fill in this template when reporting a bug, unless you know what 
+you are doing. 
+Description of Problem: 
+I'm using mono1.1.8. I'm using UnixODBC with MySQLODBC driver to access 
+MySQL 4.1 server. I've a class that retrieve records from just one table 
+using select statement with where clause for conditions. I've a test that 
+create this class and call its method to retrieve data couple of time. 
+The first time, everything went fine. On the second time, the problem 
+reported in OdbcConnection:Close() with the following error: 
+Unhandled Exception: System.Data.Odbc.OdbcException: [unixODBC][Driver 
+Manager]Function sequence error 
+in <0x001c3> System.Data.Odbc.OdbcConnection:FreeHandles () 
+in (wrapper remoting-invoke-with-check) 
+System.Data.Odbc.OdbcConnection:FreeHandles () 
+in <0x00152> System.Data.Odbc.OdbcConnection:Close () 
+in <0x007b1> Airshow.ASXNet.Common.Utilities.AirportInfo:retrieveRecords 
+(DatabaseDriverProvider driverType, DatabaseServiceProvider dbProvider, 
+System.String dbConnection, System.String query, 
+Airshow.ASXNet.Common.Ifaces.Database.Language[] langsId, Single lat, 
+Single lon) 
+in <0x0020c> Airshow.ASXNet.Common.Utilities.AirportInfo:Create 
+(DatabaseDriverProvider driverType, DatabaseServiceProvider dbProvider, 
+System.String dbConnection, Single airportLat, Single airportLon, 
+Airshow.ASXNet.Common.Ifaces.Database.Language[] langIds) 
+in <0x0006a> Airshow.ASXNet.Common.Utilities.AirportInfo:Create 
+(DatabaseDriverProvider driverType, DatabaseServiceProvider dbProvider, 
+System.String dbConnection, Single airportLat, Single airportLon) 
+in <0x00088> MapGeneratorTest.DBTest.MapGenDBTest:Main (System.String[] 
+args) 
+ 
+Steps to reproduce the problem: 
+1. Create a table in MySql server 
+2. Implement a class to retrieve data from table with select statement and 
+a where clause. The implementation is using OdbcCommand, OdbcConnection, 
+and OdbcDataReader. Once all the data is retrieved, before the method 
+returned, call OdbcDataReader.Close() followed by OdbcConnection.Close() 
+3. The error occurred in OdbcConnection.Close() 
+4. The main test class will call the method three times. On the second 
+time the error will occur. 
+ 
+Actual Results: 
+Unhandled Exception: System.Data.Odbc.OdbcException: [unixODBC][Driver 
+Manager]Function sequence error 
+in <0x001c3> System.Data.Odbc.OdbcConnection:FreeHandles () 
+in (wrapper remoting-invoke-with-check) 
+System.Data.Odbc.OdbcConnection:FreeHandles () 
+in <0x00152> System.Data.Odbc.OdbcConnection:Close () 
+in <0x007b1> Airshow.ASXNet.Common.Utilities.AirportInfo:retrieveRecords 
+(DatabaseDriverProvider driverType, DatabaseServiceProvider dbProvider, 
+System.String dbConnection, System.String query, 
+Airshow.ASXNet.Common.Ifaces.Database.Language[] langsId, Single lat, 
+Single lon) 
+in <0x0020c> Airshow.ASXNet.Common.Utilities.AirportInfo:Create 
+(DatabaseDriverProvider driverType, DatabaseServiceProvider dbProvider, 
+System.String dbConnection, Single airportLat, Single airportLon, 
+Airshow.ASXNet.Common.Ifaces.Database.Language[] langIds) 
+in <0x0006a> Airshow.ASXNet.Common.Utilities.AirportInfo:Create 
+(DatabaseDriverProvider driverType, DatabaseServiceProvider dbProvider, 
+System.String dbConnection, Single airportLat, Single airportLon) 
+in <0x00088> MapGeneratorTest.DBTest.MapGenDBTest:Main (System.String[] 
+args) 
+ 
+ 
+Expected Results: 
+ 
+ 
+How often does this happen?  
+All the time. 
+ 
+Additional Information: