Problem connecting to Remote MySQL with C#

Question

i'm using Visual Studio 2010 and when i bind a DataGridView with my remote mysql db it works fine.
but when i take the connection string from the wizard and try to use it with code i get: "provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server"

this is the connection string i try (i tried many variants):
"Server=myserver.org;Database=my_db;Uid=myuser;Pwd=mypwd;"

any ideas?
thanks

here is the code:
string connectionString = "Server = sql.server.org; Database = my_db; Uid = my_user; Pwd = mypwd;";

        SqlConnection myConnection = new SqlConnection(connectionString);
        SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("Select * from Table", myConnection);
        DataSet myDataSet = new DataSet();
        DataRow myDataRow;

        // Create command builder. This line automatically generates the update commands for you, so you don't 
        // have to provide or create your own.
        SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter);

        // Set the MissingSchemaAction property to AddWithKey because Fill will not cause primary
        // key & unique key information to be retrieved unless AddWithKey is specified.
        mySqlDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

        mySqlDataAdapter.Fill(myDataSet, "Table");

Could you show the non-working code?

Darin Dimitrov
– Darin Dimitrov

2010-09-18 12:34:42 +00:00
Commented Sep 18, 2010 at 12:34 — Darin Dimitrov
– Darin Dimitrov, Commented Sep 18, 2010 at 12:34

pat · Accepted Answer · 2010-09-18 15:02:18Z

0

SOLVED: apparently SqlConnection is not made for MySQL

use: MySqlConnection instead

answered Sep 18, 2010 at 15:02

pat

162 bronze badges

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

Comments

Krutika Patel · Accepted Answer · 2020-08-05 06:05:49Z

0

           string connectionString = "server=localhost;uid=root;pwd=***********;database=terra_incognita_online";
           MySqlConnection sqlConnection = new MySqlConnection();
           sqlConnection.ConnectionString = connectionString;
           sqlConnection.Open();
           Console.WriteLine("open");
           sqlConnection.Close();
           Console.WriteLine("close");

answered Aug 5, 2020 at 6:05

Krutika Patel

4305 silver badges19 bronze badges

Collectives™ on Stack Overflow

Problem connecting to Remote MySQL with C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related