[Mono-list] MySql Connector

[Reggie Burnett]

Damien

 

This has recently been fixed.  The problem here is that  your sproc is
generating warnings and the connector is trying to use a datareader to read
those warnings and report them to  you.  In this case, the connector is not
correctly marking the connection as free.  What version of the connector are
you using?

 

From: mono-list-bounces at lists.ximian.com
[mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Damien Churchill
Sent: Friday, October 20, 2006 4:54 AM
To: Mono-list at lists.ximian.com
Subject: [Mono-list] MySql Connector

 

I was wondering has anyone else has experienced this:

 

Unhandled Exception: MySql.Data.MySqlClient.MySqlException: There is already
an open DataReader associated with this Connection which must be closed
first.

  at MySql.Data.MySqlClient.MySqlCommand.CheckState () [0x00000] 

  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior
behavior) [0x00000] 

  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] 

  at (wrapper remoting-invoke-with-check)
MySql.Data.MySqlClient.MySqlCommand:ExecuteReader ()

  at MySql.Data.MySqlClient.Driver.ReportWarnings () [0x00000]

 

I receive this error when trying to execute a stored procedure (other SQL
statements work fine, even other stored procedures). It works fine on
windows with .NET but on mono (windows or linux) I receive that error.

 

If anyone has any help or tips that would be much appreciated.

 

Cheers in advance.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20061020/7559325a/attachment.html