none
Could not load file or assembly 'MySql.Data, Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified RRS feed

  • Question

  • Hlo Dere...
    as I have created a resource WebApp+MySql ..

    i have deployed the required things..

    when i had published my asp.net web app to azure web app..

    connected and mysql workbench with azure mysql database..

    but unable to establish the connection between webapp and mysql database on Azure.....

    when logging on web app it cannot fetches the data from database..

    Server Error in '/' Application.

    Could not load file or assembly 'MySql.Data, Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

    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.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

    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.

    Assembly Load Trace: The following information can be helpful to determine why the assembly 'MySql.Data, Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' could not be loaded.
    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
    

    Stack Trace: 
    [FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.]
       TicketPrint.Transaction_table_data(String payment_no) +0
       MT.Ticket.Button1_Click(Object sender, EventArgs e) +46
       System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9782702
       System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +204
       System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +12
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +15
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1639
    


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

    • Moved by CoolDadTx Monday, April 8, 2019 2:06 PM ASP.NET related
    Sunday, April 7, 2019 7:53 PM

All replies

  • Hello,

    Consider asking in the ASP.NET forum, sub-forum Oracle, MySQL, Sybase, Informix and other databases. Also check to ensure MySql version 6.4.4.0 is installed on the server, not just if MySql is installed.


    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    StackOverFlow
    profile for Karen Payne on Stack Exchange

    Sunday, April 7, 2019 10:23 PM
  • i have deployed the required things..

    when i had published my asp.net web app to azure web app..

    No you have not deployed the required things, because otherwise, you would not be getting the exception

    Could not load file or assembly 'MySql.Data, Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.

    Your Web program in development was using the above DLL that it knew about that was there on the development machine. The program knows about the DLL right down to its version number and its publickeytoken that is not there in the Bin folder of the Web program hosted by the IIS Web server when you did the deployment. 

    Where is the DLL in the Bin folder for the Web program on IIS, the program needs? It may be that a dependency DLL the above DLL needs has not been deployed too.

    You can use Dependency Walker to follow the chain.

    http://www.dependencywalker.com/

    Sunday, April 7, 2019 10:47 PM