[warbie118]

Hi, I am having trouble connecting to a Mysql database for a restful api i am developing,

using MySql.Data.MySqlClient;

this is whaat i am using in my dblayer

 <assemblies>
        <add assembly="MySql.Web, Version=6.1.6.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
        <add assembly="MySql.Data, Version=6.1.6.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
      </assemblies>

This is the assemblies in my web.config

<connectionStrings>
    <add name="******" connectionString="Server=*****;Persist Security Info=True;Database=mwarburton;Uid=*****;Pwd=*****" providerName="MySql.Data.MySqlClient"/>
  </connectionStrings>

and this is my connectionstring in web.config

when i try to run my restful api on Postman a google chrome application i get the following error





If someone could please tell me how i can solve this and connect to my database it would be a great help as its getting really frustrating now!!

Thank you!

[codejunky]

Not sure about doing it like that but c# MySQL.Data.MySqlClient;
I connect like

 string constring = @"server=yourserver;port=yourport;userid=youruserid;
            password=yourpassword;database=yourdatabase";

            MySqlConnection connect;
            connect = new MySqlConnection(constring);
            MySqlCommand cmdDataBase = new MySqlCommand("select * from yourdatabase.yourtable", connect);
            MySqlDataReader myReader;
          
            try
            {      
            connect.Open();                              
            myReader = cmdDataBase.ExecuteReader();
          
            while (myReader.Read())
            {
               
            }
           
            }
            catch (MySqlException ex)
            {
                 MessageBox.Show(ex.Message);

            }
            

[andy_pleasants]

I think this is more of a .NET related problem than a MySQL problem. The error says it can't load the required assembly, you might have more look on the .NET board

[Atli]

Andy is right. I've moved this thread over to the .NET forum.