MySQL Bugs: #39871: Lost connection to MySQL server calling multiple Stored Procedure with .NET

Bug #39871	Lost connection to MySQL server calling multiple Stored Procedure with .NET
Submitted:	6 Oct 2008 7:55	Modified:	6 Oct 2008 15:08
Reporter:	Chintan Shah	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	ODBC 3.51, MYSQL 5.0	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Calling multiple Stored Procedure with .NET

Description:
"Lost connection to MySQL server" and "MySQL server has gone away" error while calling multiple Stored Procedure with ASP.NET (connection with ODBC Driver). I am using Microsoft Enterprise Libaray 3.1.

How to repeat:
Whenever I am loading page which uses more than one stored procedure I get "Lost connection to MySQL server" OR "MySQL server has gone away" Error.
Please suggest the steps to avaoid this error in ASP.NET.

Hi Chintan and thanks for your report.

This sounds so familiar that I think it's already fixed. Can you please do the following:
  - Grab latest c/ODBC 5.1 driver from snapshots page and try it.
  - If it fails, attach small database dump and ASP page so I can test it.

Thank you.

"Lost connection to MySQL server" and "MySQL server has gone away" error solved after updarading to ODBC 5.1.

But new problem arise after updrading. All bit datatype fields return true regardless of its original value. I am using ODBC 5.1 with ASP.NET. MYSQL Version is 5.0.22.

Chintan, let me check on this.

Chintan, the "BIT" problem you describe is reported in Bug#36470 and assigned to developer to be fixed. As original problem is solved I'm closing the report.