C# SQL Connection not found

Question

How can I connect a SQL database in C#?

My code:

const string connectionString = "Data Source=127.0.0.1;User ID=root;Database=MyDatabase;Password=MyPassword";
var conn = new SqlConnection(connectionString);
conn.Open();
conn.Close();

I get: Error: 40 - could not open a connection to sql server. I tried also in Python and it worked well:

cnx = mysql.connector.connect(user='root', password='MyPassword', host='127.0.0.1', database='MyDatabase')
cursor = cnx.cursor()

What am I missing in C#?

I think "Database" is called Initial Catalog, but besides that it looks correct — jollyjoyce1995
– jollyjoyce1995, Commented May 19, 2022 at 8:14
SqlConnection is for Microsoft SQL Server, but it looks like you've actually got MySQL. You should look into the MySQL drivers available for .NET, e.g. dev.mysql.com/downloads/connector/net — Jon Skeet
– Jon Skeet, Commented May 19, 2022 at 8:15
you can validate your connection string on this page connectionstrings.com/mysql-connector-net-mysqlconnection — Pribina
– Pribina, Commented May 19, 2022 at 8:15

Ajay Gupta · Accepted Answer · 2022-05-19 08:19:35Z

1

Please use MySqlConnection for MySql DB.

            const string connectionString = "Data Source=127.0.0.1;User ID=root;Database=MyDatabase;Password=MyPassword";         
            MySqlConnection conn = new MySqlConnection(connectionString );
            conn.Open();

            string sqlcommand = "SELECT Query";
            MySqlCommand cmd = new MySqlCommand(sqlcommand , conn);

answered May 19, 2022 at 8:19

Ajay Gupta

8617 silver badges12 bronze badges

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

1 Comment

franta96 Over a year ago

Yes, with MySQL it works. Thank you.

Dark Storm · Accepted Answer · 2022-05-19 08:40:38Z

0

please follow this example

using MySql.Data.MySqlClient;

var connectionString = "server=serveradress;database=dbName;user id=sqluser;password=abc;";

using (var connection = new MySqlConnection(connectionString))
{
    connection.Open();
    
    using var command = new MySqlCommand("SELECT COUNT(*) FROM tableName ", connection);
    var Count = command.ExecuteScalar();

    Console.WriteLine($"There are {Count } movies");
}

server adress in general is 127.0.0.1 ,if you are working locally

here the source page : example and also consider reading this page here docs

answered May 19, 2022 at 8:40

Dark Storm

3375 silver badges12 bronze badges

Collectives™ on Stack Overflow

C# SQL Connection not found

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related