Can't connect to database from visual studio c#

Question

I want to connect to database from my c# windows forms application. I tried using

using(SqlConnection conn = new SqlConnection()) {
 conn.ConnectionString = "Data Source=localhost; User Id=root; Password=; Initial Catalog=dbName";
 conn.Open();
}

and when I build my project I get an error that server wasn't found or wasn't accessible.

I tried connecting through data source configuration wizard, but also database can't be found.

I use WAMP server, and I can find my database through phpMyAdmin.

@SachithMW It's a runtime error and it says: `Unhandled exception has occured in your application ... ... A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. ...` — wdc, Apr 11 '17 at 09:51

Sachith Wickramaarachchi · Accepted Answer · 2017-04-11T10:23:54.383

2

You're trying to connect to Microsoft SQL Server.

using System;
using System.Data;

using MySql.Data;
using MySql.Data.MySqlClient;

public class Tutorial1
{
    public static void Main()
    {
        string connStr = "server=localhost;user=root;database=world;port=3306;password=******;";
        MySqlConnection conn = new MySqlConnection(connStr);
        try
        {
            Console.WriteLine("Connecting to MySQL...");
            conn.Open();
            // Perform database operations
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.ToString());
        }
        conn.Close();
        Console.WriteLine("Done.");
    }
}

Check this links,hope this will be helped to you

you can install MySql.Data by ,open Package Manager Console Tools > NuGet Package Manager > Package Manager Console then type Install-Package MySql.Data -Version 6.9.9 in there

edited Apr 11 '17 at 10:23

answered Apr 11 '17 at 09:53

Sachith Wickramaarachchi

5,546
6
39
68

@SachitMW What should I include to use `MYSqlConnection` class? – wdc Apr 11 '17 at 09:55
I don't have that `mysql.data` library, only `System.Data` , trying to find to download it now. – wdc Apr 11 '17 at 10:13
1

@wdc just use nuget inside visual studio https://www.nuget.org/packages/MySql.Data/ – Takarii Apr 11 '17 at 10:16
@Takarii Thank you, will try later. – wdc Apr 11 '17 at 10:19

score 0 · Answer 2 · edited May 23 '17 at 11:54

0

You would need to use a MySqlConnection to connect to a MySQL database, see answer here

How to connect to MySQL Database?

edited May 23 '17 at 11:54

Community

1
1

answered Apr 11 '17 at 09:48

toby

40
5

Can't connect to database from visual studio c#

2 Answers2