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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] +ReportedBy: [EMAIL PROTECTED] +QAContact: [EMAIL PROTECTED] +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: _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
