Connect to External SQL Database in C#

Question

I've got an SQL server and database setup on an external server (let's call the domain name "hello.com" for the purposes of this), and I want to connect to this server via a C# program. So far I have this (All server/database details are different to the real ones):

private static void SetupSQL()
{
    string connectionString = "server=hello.com; database=db1; uid=user1; pwd=xxxxx;";
    connection = new SqlConnection();
    connection.ConnectionString = connectionString;
    try
    {
        connection.Open();
        Console.WriteLine("Connected");
    }
    catch (Exception e)
    {
        Console.WriteLine(e.Message.ToString());
    }
}

This is giving me an error 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)

I have checked all the connection string, and I am allowed remote access, as I have SQLWorkbench open querying the database right now on the same computer.

Any ideas?

Have you read this: blog.sqlauthority.com/2009/05/21/… ? Edit: No, it's not clear since a SqlConnection is clearly a SQL-Server connection. — Tim Schmelter
– Tim Schmelter, Commented Oct 11, 2012 at 12:24
does SQL SERVER Status is Running? Read This Article Here if you are using MySQL you should Install MySQL Connector. — Sirwan Afifi
– Sirwan Afifi, Commented Oct 11, 2012 at 12:24

Darren · Accepted Answer · 2012-10-11 12:22:42Z

5

You'll need the MySQL driver:

http://dev.mysql.com/downloads/connector/net/

You can then use the the MySqlConnection connection class to connect.

MySqlConnection connection = new MySqlConnection(connectionString);

http://www.codeproject.com/Articles/43438/Connect-C-to-MySQL

answered Oct 11, 2012 at 12:22

Darren

71.2k24 gold badges141 silver badges146 bronze badges

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

Comments

Sleiman Jneidi · Accepted Answer · 2012-10-11 12:24:20Z

3

You can't use SqlConnection object to connect to MySQL database, you should use MySqlConnection instead after you import its dll

answered Oct 11, 2012 at 12:24

Sleiman Jneidi

23.4k14 gold badges60 silver badges80 bronze badges

Collectives™ on Stack Overflow

Connect to External SQL Database in 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