How can I make my Azure MySQL DB connection work?

Question

I set up a MySQL database in my AZURE account, but I cannot connect it in any way. I tried:

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection sqlconnection = new SqlConnection("Database=Banco1; Data Source=br-cdbr-azure-south-a.cloudapp.net;User Id=USERID Password=PASSWORDid");
            Console.WriteLine("1");
            sqlconnection.Open();
            Console.WriteLine("2");
            SqlCommand cmd = new SqlCommand("CREATE TABLE Customer(First_Name char(50), Last_Name char(50), Address char(50), City char(50), Country char(25), Birth_Date datetime); ", sqlconnection);
            Console.WriteLine("3");
            cmd.ExecuteNonQuery();
            Console.WriteLine("4");
            Console.ReadLine();
        }
    }
}

I tried putting prints through the commands, and the program only prints "1" which means I can't get the connection opened... how can I fix that?

The output error:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Error in the network or specifics to the instance when stablishing connection to the SQL Server. The server was not found or was not available. Check if the instance name is correct and if the SQL Server is configured to allow remote connection. (provider: Named Pipes Provider, error: 40 - Could not stablish connection to SQL Server)

What language is this? Edit your question and add an appropriate tag. — miken32
– miken32, Commented Jan 20, 2016 at 20:39
Please edit your question to include more detail, such as the actual error you're getting. Also, where did you set up MySQL: In a VM? If so, how did you open a port to it? As your question currently stands, it's unclear what you're asking, and risks being closed. — David Makogon
– David Makogon, Commented Jan 20, 2016 at 20:47
As a matter of fact it is C#, The problem seems to be not stablishing a server... It should be in a VM, but I cannot find it. — Arthur Perin
– Arthur Perin, Commented Jan 20, 2016 at 21:05

forester123 · Accepted Answer · 2016-01-21 01:58:30Z

1

SqlConnection is used for connecting SQL Database, for MySQL Database, you need to use MySqlConnection. Please first install MySql Connect/NET and then add reference

Now you can connect to your Mysql database successfully with the code below:

MySqlConnection con = new MySqlConnection("your_mysql-connect_string");

answered Jan 21, 2016 at 1:58

forester123

1,58910 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How can I make my Azure MySQL DB connection work?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related