I have hosted my web application into server . I got below error on and off but when i refresh the page , the error disappear . Im unable to figure out what is the problem because the error is normal happen after using the application about 10 to 20
mins . But when i run in localhost , there is no problem at all .
I read lot of articles and testing on it but still failed . Pls help . Im using asp.net C# and mysql .
ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException (0x80131937): ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away]
[InvalidOperationException: The connection has been disabled.]
i think there is porblem of connection where you mysql database is reside.Error is come becasue of your database server is slow ot when you done connection with your server and after doing any transection or any thing else you can't clsoe the connection.
Can you provide your web site link?
Thanks & Regards
Vipul Donga
Mark it as an answer, if it helped
if (MyAnswer)
MarkAsAnswer();
else
Repsonse.Write("correct me where i am wrong");
i still got the problem . i have checked with the web hosting company where i have hosted my web application , they asked to check this line from the error message in the coding . I have checked im my coding and could not find the path ( C:\JDMoleculeTask\Webdevelop\JDM\JDM
) . How to check and solve it ?
Pls help
from the error message
DataManager.DBUtil.getTable(String qry) in C:\JDMoleculeTask\Webdevelop\JDM\DataManager\DBUtil.cs:49
JDM.SearchCustomer.Data() in C:\JDMoleculeTask\Webdevelop\JDM\JDM\SearchCustomer.aspx.cs:232
JDM.SearchCustomer.btnSearch_Click(Object sender, EventArgs e) in C:\JDMoleculeTask\Webdevelop\JDM\JDM\SearchCustomer.aspx.cs:67
Member
19 Points
36 Posts
How to fix "ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone...
Oct 07, 2010 12:22 AM|shirleja|LINK
Hi Experts ,
I have hosted my web application into server . I got below error on and off but when i refresh the page , the error disappear . Im unable to figure out what is the problem because the error is normal happen after using the application about 10 to 20 mins . But when i run in localhost , there is no problem at all .
I read lot of articles and testing on it but still failed . Pls help . Im using asp.net C# and mysql .
Million Thanks ..
-----------------------------------------------------------------------------------------------------
ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException (0x80131937): ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away]
[InvalidOperationException: The connection has been disabled.]
System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException) +1160799
System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode) +154
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +13
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) +1147
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) +61
System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) +75
System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
DataManager.DBUtil.getTable(String qry) in C:\JDMoleculeTask\Webdevelop\JDM\DataManager\DBUtil.cs:49
JDM.SearchCustomer.Data() in C:\JDMoleculeTask\Webdevelop\JDM\JDM\SearchCustomer.aspx.cs:232
JDM.SearchCustomer.btnSearch_Click(Object sender, EventArgs e) in C:\JDMoleculeTask\Webdevelop\JDM\JDM\SearchCustomer.aspx.cs:67
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
Version Information: Microsoft .NET Framework Version:2.0.50727.4206; ASP.NET Version:2.0.50727.4209
ASP.NET MySQL ODBC 5.1
Contributor
2380 Points
688 Posts
Re: How to fix "ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has g...
Oct 07, 2010 02:05 AM|vipuldonga|LINK
Hi,
i think there is porblem of connection where you mysql database is reside.Error is come becasue of your database server is slow ot when you done connection with your server and after doing any transection or any thing else you can't clsoe the connection.
Can you provide your web site link?
Vipul Donga
Mark it as an answer, if it helped
if (MyAnswer)
MarkAsAnswer();
else
Repsonse.Write("correct me where i am wrong");
Member
19 Points
36 Posts
Re: How to fix "ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has g...
Oct 12, 2010 12:48 PM|shirleja|LINK
hi ,
i still got the problem . i have checked with the web hosting company where i have hosted my web application , they asked to check this line from the error message in the coding . I have checked im my coding and could not find the path ( C:\JDMoleculeTask\Webdevelop\JDM\JDM ) . How to check and solve it ?
Pls help
from the error message
DataManager.DBUtil.getTable(String qry) in C:\JDMoleculeTask\Webdevelop\JDM\DataManager\DBUtil.cs:49
JDM.SearchCustomer.Data() in C:\JDMoleculeTask\Webdevelop\JDM\JDM\SearchCustomer.aspx.cs:232
JDM.SearchCustomer.btnSearch_Click(Object sender, EventArgs e) in C:\JDMoleculeTask\Webdevelop\JDM\JDM\SearchCustomer.aspx.cs:67