Cannot connect to MySQL database in C#.NET

Question

So I'm following this tutorial: http://support.microsoft.com/kb/314145/

and I get an unexpected error: A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

My class looks like this:

    class Database
{
    public Database()
    {
        string connectionString = "Password=pass;User ID=userid;Initial Catalog=soksko;Data Source=(local)";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);
            Console.WriteLine("State: {0}", connection.State);
        }

        Console.WriteLine("Database: OK");
    }

}

I googled, but I couldnt find anything valuable. I am using MySQL database, it is on the same computer and I am using VS 2013. I successfully added my database to Server Explorer with the same connection information that I use above, but I get exception, when I try to open the connection.

First of all use try catch and set a breakpoint in the exception handler. this should give you some insights — Christian Rapp
– Christian Rapp, Commented Nov 6, 2014 at 22:01
I tried that. It's the open method that throws the exception. — Jonas
– Jonas, Commented Nov 6, 2014 at 22:01
The problem is that even if I use try/catch, it is still the same message above. I do not get where it comes from. — Jonas
– Jonas, Commented Nov 6, 2014 at 22:06

therogoman · Accepted Answer · 2014-11-06 22:07:37Z

2

SqlConnection is for MS SQL Server. For MySql you need to use a MySqlConnection class provided by the MySQL connector (http://dev.mysql.com/doc/connector-net/en/index.html)

using MySql.Data.MySqlClient;

using(MySqlConnection myConnection = new MySqlConnection(myConnectionString))
{
    myConnection.Open();
    // execute queries, etc
}

answered Nov 6, 2014 at 22:07

therogoman

664 bronze badges

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

1 Comment

Jonas Over a year ago

My bad... I appreciate your input.

Community · Accepted Answer · 2017-05-23 10:33:41Z

1

See this link for how a MySQL connection string should look:

ASP.NET use SqlConnection Connect Mysql

See this link for an explanation of the oft mis-used Data Source=(local):

http://blogs.msdn.com/b/sql_protocols/archive/2008/09/19/understanding-data-source-local-in-sql-server-connection-strings.aspx

hint you're not using SQL-Server so it won't work for you

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Nov 6, 2014 at 22:02

ebyrob

262 bronze badges

Comments

David Libido · Accepted Answer · 2014-11-06 22:05:37Z

0

The tutorial you're using is for Sql Server, not MySQL.

answered Nov 6, 2014 at 22:05

David Libido

4792 silver badges13 bronze badges

Collectives™ on Stack Overflow

Cannot connect to MySQL database in C#.NET

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related