c# MySql.Data not loading

Question

using System;
using MySql.Data.MySqlClient;
namespace Input
{
    class MainClass
    {
        public static void Main (string[] args)
        {
            string connectionString = "server=SQL09.FREEMYSQL.NET;database=m44m31;uid=m44m31;pwd=*******"; 
            MySqlConnection conn = new MySqlConnection(connectionString);
            try
            {
                conn.Open();
            }
            catch
            {
                Console.WriteLine("Failed to connect");
            }
        }
    }
}

there is my code and here is the error i keep getting...i'm using mono on ubuntu:

Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.5.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies.
File name: 'MySql.Data, Version=6.5.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'
[ERROR] FATAL UNHANDLED EXCEPTION: System.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, Version=6.5.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies.
File name: 'MySql.Data, Version=6.5.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'

i really don't know what to do and have searched every where, please help!

    [assembly: AssemblyVersion ("6.5.5.0")]
[assembly: InternalsVisibleTo ("MySql.Data.Tests, PublicKey = 0024000004800000940000000602000000240000525341310004000001000100d973bda91f71752c78294126974a41a08643168271f65fc0fb3cd45f658da01fbca75ac74067d18e7afbf1467d7a519ce0248b13719717281bb4ddd4ecd71a580dfe0912dfc3690b1d24c7e1975bf7eed90e4ab14e10501eedf763bff8ac204f955c9c15c2cf4ebf6563d8320b6ea8d1ea3807623141f4b81ae30a6c886b3ee1")]
[assembly: AssemblyConfiguration ("")]
[assembly: AssemblyKeyName ("ConnectorNet")]
[assembly: InternalsVisibleTo ("MySql.Data.CF.Tests, PublicKey = 0024000004800000940000000602000000240000525341310004000001000100d973bda91f71752c78294126974a41a08643168271f65fc0fb3cd45f658da01fbca75ac74067d18e7afbf1467d7a519ce0248b13719717281bb4ddd4ecd71a580dfe0912dfc3690b1d24c7e1975bf7eed90e4ab14e10501eedf763bff8ac204f955c9c15c2cf4ebf6563d8320b6ea8d1ea3807623141f4b81ae30a6c886b3ee1")]
[assembly: InternalsVisibleTo ("MySql.Data.Entity, PublicKey = 0024000004800000940000000602000000240000525341310004000001000100d973bda91f71752c78294126974a41a08643168271f65fc0fb3cd45f658da01fbca75ac74067d18e7afbf1467d7a519ce0248b13719717281bb4ddd4ecd71a580dfe0912dfc3690b1d24c7e1975bf7eed90e4ab14e10501eedf763bff8ac204f955c9c15c2cf4ebf6563d8320b6ea8d1ea3807623141f4b81ae30a6c886b3ee1")]
[assembly: Debuggable (DebuggableAttribute.DebuggingModes.IgnoreSymbolStoreSequencePoints)]
[assembly: CompilationRelaxations (8)]
[assembly: RuntimeCompatibility (WrapNonExceptionThrows = true)]
[assembly: TargetFramework (".NETFramework,Version=v4.0", FrameworkDisplayName = ".NET Framework 4")]
[assembly: AssemblyDescription ("ADO.Net driver for MySQL")]
[assembly: AssemblyCompany ("Oracle")]
[assembly: AssemblyProduct ("")]
[assembly: AssemblyCopyright ("Copyright © 2004, 2010, Oracle and/or its affiliates. All rights reserved.")]
[assembly: AssemblyTrademark ("")]
[assembly: ComVisible (false)]
[assembly: CLSCompliant (false)]
[assembly: AssemblyTitle ("MySql.Data.dll")]
[assembly: AllowPartiallyTrustedCallers ]
[assembly: SecurityRules (SecurityRuleSet.Level1)]
[assembly: AssemblyDelaySign (false)]

It is added to the assembly ^^^^

Check your database name, it is missing the file type extension... — Bhushan Firake
– Bhushan Firake, Commented Dec 9, 2012 at 18:50
database=m44m31 This is database name, right?? So it has to be an extension. — Bhushan Firake
– Bhushan Firake, Commented Dec 9, 2012 at 19:01
i mean like .sdf, .mdf and like so....Hope you got it this time — Bhushan Firake
– Bhushan Firake, Commented Dec 9, 2012 at 19:06

Levi Botelho · Accepted Answer · 2012-12-09 18:39:11Z

2

It appears that you have a broken reference to the MySql.Data dll. Verify that the .csproj file contains the reference to the correct dll and that the dll exists in the proper location. Please post more info if this doesn't fix your problem!

answered Dec 9, 2012 at 18:39

Levi Botelho

25.4k5 gold badges64 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

m44m31 Over a year ago

its added as a reference and i don't think its corrupted...i downloaded it from the official MySQL website...what other info do you need?

m44m31 Over a year ago

Yes it does, What other info do you need?

Levi Botelho Over a year ago

Did you do an MD5 on the download? (I had a corrupted download at one time).

m44m31 Over a year ago

i'm going to re-download and see if it helps

Levi Botelho Over a year ago

Do an MD5 when you do just to be sure.

|

Collectives™ on Stack Overflow

c# MySql.Data not loading

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related