locked
Error While connecting to the mysql database ... Need a solution for this problem ASAP... Please... RRS feed

  • Question

  • User1149920811 posted


    Connector/Net no longer supports server versions prior to 5.0
    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.NotSupportedException: Connector/Net no longer supports server versions prior to 5.0

    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:


    [NotSupportedException: Connector/Net no longer supports server versions prior to 5.0]
    MySql.Data.MySqlClient.NativeDriver.Open() +1307
    MySql.Data.MySqlClient.Driver.Open() +22
    MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) +210
    MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +289
    MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() +113
    MySql.Data.MySqlClient.MySqlPool.GetConnection() +72
    MySql.Data.MySqlClient.MySqlConnection.Open() +555
    System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +52

    [EntityException: The underlying provider failed on Open.]
    System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +161
    System.Data.EntityClient.EntityConnection.Open() +98
    System.Data.Objects.ObjectContext.EnsureConnection() +81
    System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +46
    System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +44
    System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +315
    System.Linq.Enumerable.ToList(IEnumerable`1 source) +58
    web.Repository.GetRecords(String str) in D:\jay\DavionFinal\web\Repository.cs:123
    web.Search.showdata() in D:\jay\DavionFinal\web\Search.aspx.cs:59
    web.Search.Page_Load(Object sender, EventArgs e) in D:\jay\DavionFinal\web\Search.aspx.cs:23
    System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
    System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
    System.Web.UI.Control.OnLoad(EventArgs e) +91
    System.Web.UI.Control.LoadRecursive() +74
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

    Wednesday, May 7, 2014 12:54 AM

Answers

  • User-821857111 posted

    You need a version of MySQL Connector that is below version 6.3.0. As the error message said, that version and above no longer supports connecting to version 5 of MySQL. You can choose an  earlier version from this page: http://downloads.mysql.com/archives/c-net/

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, May 7, 2014 2:27 AM