Can't access MYSQL server from c# forms application - error in connection string

Question

myConnection = new SqlConnection("user id=champion3_test;" +
                                       "password=test;server=10.168.1.58;" +
                                       "Trusted_Connection=true;" +
                                       "database=champion3_sabdb; " +
                                       "connection timeout=30");

This code gives the error:

Thrown: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" (System.Data.SqlClient.SqlException) Exception Message = "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)", Exception Type = "System.Data.SqlClient.SqlException", Exception WinRT Data = ""

Here are some screenshots that might help with debugging of my server's settings: https://i.sstatic.net/QJ476.jpg

I know that 'champion3_test' is a valid user id 'test' is a valid password for champion3_test the database name is 'champion3_sabdb'

for starters you should not create the SqlConnection like this. I would highly suggest putting this in a config file there are plenty examples on google on how to configure / Database ConnectionString in a App.Config file — MethodMan
– MethodMan, Commented Mar 13, 2013 at 15:08

Matt Burland · Accepted Answer · 2013-03-13 15:06:24Z

4

SQL server isn't MySQL. If you are using MySQL, download the MySQL .NET Connector and use their connection class, MySqlConnection.

To learn how to use the MySQL Connector, you can start here.

answered Mar 13, 2013 at 15:06

Matt Burland

45.3k18 gold badges110 silver badges182 bronze badges

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

Comments

Marcus Vinicius · Accepted Answer · 2013-03-13 15:09:59Z

0

You can download the MySql Connector for .Net here.

Once you've installed the driver, you can connect using the MySql Connector classes:

 string connStr = "server=localhost;user=root;database=world;port=3306;password=******;";
 MySqlConnection conn = new MySqlConnection(connStr);

answered Mar 13, 2013 at 15:09

Marcus Vinicius

1,8981 gold badge20 silver badges36 bronze badges

Collectives™ on Stack Overflow

Can't access MYSQL server from c# forms application - error in connection string

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