MySQL Connector Net 1.08 and C#

[divined]

Hello everybody

I want to connect to a MySQL 5.0 database under C# using the MySQL Connector Net 1.08 drivers. I know that I need to use the MySQLConnector object. But that object is not recognized by the compiler and I thus get a compilation error.

Do I need to add some sort of reference in the IDE of the compiler?

George Papadopoulos

[aniskhan]

Connecting to MySQL Using Connector/NET

[divined]

Fine. But the compiler responds with an error when I use the C# code :

MySql.Data.MySqlClient.MySqlConnection conn;
string myConnectionString;
    
myConnectionString = "server=127.0.0.1;uid=root;" +
    "pwd=12345;database=test;";
  
try
{
    conn = new MySql.Data.MySqlClient.MySqlConnection();
    conn.ConnectionString = myConnectionString;
    conn.Open();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
    MessageBox.Show(ex.Message);
}

and the error I get is

Error 1 The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) C:\Documents and Settings\divined\Τα έγγραφά μου\Visual Studio 2005\Projects\MySQL_test\MySQL_test\Program.cs 13 9 MySQL_test


What namespace do I need to use in order for the MySQL namespace to be found?

I added a reference to MySQL.Data.dll now but still the IDE of Visual Studio 2005 Express cannot find the MySQL namespace.

[aniskhan]

Link

[divined]

thanks for the link. A rather focal point for anything related to MySQL Connector.

[Charu0306]

Thats nice, Aniskhan.