Trying to connect to mysql db with C#

Question

When I debug through the code just hangs on connection.Open();

I am using the connector - using MySql.Data.MySqlClient;

Thanks in advance.

        string strProvider = "Data Source=" + host + ";Database=" + database + ";User ID=" + user + ";Password=" + password;

        MySqlConnection connection = new MySqlConnection(strProvider);
        MySqlCommand command = connection.CreateCommand();
        MySqlDataReader Reader;
        command.CommandText = "select * from products";
        connection.Open();
        Reader = command.ExecuteReader();
        while (Reader.Read())
        {

            string thisrow = "";
            for (int i = 0; i < Reader.FieldCount; i++)
                thisrow += Reader.GetValue(i).ToString() + ",";
            listBox1.Items.Add(thisrow);
        }
        connection.Close();

Try to set command.CommandTimeout, and see if you get a timeout. If you do, check if you can use telnet or netcat to connect SQLite. — TCS
– TCS, Commented Jan 20, 2011 at 7:37

Rumplin · Accepted Answer · 2011-01-20 07:36:09Z

3

This will help http://www.connectionstrings.com/mysql

You need to change your connection string for MySQL

answered Jan 20, 2011 at 7:36

Rumplin

2,78822 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Trying to connect to mysql db with C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related