Azure - ASP.NET MVC connect to mysql database

Question

Actually, i wanted to check is my connection string valid.

There are asp.net mvc web app and mysql db deployed on azure, so i want use second thing in first. So, i added db to visual studio server explorer - db and all tables are visible.

Now i tried to add connectionstring to my project, and, wow, there are two of them i found: First: In Visual studio data connection properties:

server=us-cdbr-azure-central-a.cloudapp.net;user id=userid;persistsecurityinfo=True;database=crawlerdb

Second: In azure workplace's database property:

Database=CrawlerDB;Data Source=us-cdbr-azure-central-a.cloudapp.net;User Id=userid;Password=userpass

And both of them doesn't work. Never lucky. Connection state checking code:

using (SqlConnection conn = new SqlConnection(connstr))
        {
            try
            {
                conn.Open();
                var q = conn.State;
            }
            catch(Exception ex)
            {
                var q = ex.Message;
            }
        }

What am i doing wrong?:) Tell me plz:)

public class CrawledDataContext : DbContext
{
    public CrawledDataContext()
    {
        Database.SetInitializer<CrawledDataContext>(null);
        using (SqlConnection conn = new SqlConnection("server=us-cdbr-azure-central-a.cloudapp.net;user id=bb15193d20f901;persistsecurityinfo=True;database=crawlerdb"))
        {
            try
            {
                conn.Open();
                var q = conn.State;
            }
            catch(Exception ex)
            {
                var q = ex.Message;
            }
        }
    }
    public DbSet<GroupInfo> GroupInfoes { get; set; }
}

Here is 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)"

Actually, i'm using dbcontext, so i added code above into overrided dbcontext class ctor. — Occam's chainsaw
– Occam's chainsaw, Commented Nov 3, 2015 at 1:12
without seeing full method of how you overriding dbcontext it is hard to tell. Do you get any exceptions? — yantaq
– yantaq, Commented Nov 3, 2015 at 2:06

yantaq · Accepted Answer · 2015-11-03 17:41:12Z

2

SqlConnection is for SQL Server Databases. you should use MySqlConnection instead.

using (MySqlConnection conn = new MySqlConnection("server..."){}

edited Nov 3, 2015 at 17:41

answered Nov 3, 2015 at 17:21

yantaq

4,0682 gold badges37 silver badges34 bronze badges

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

1 Comment

Occam's chainsaw Over a year ago

Whoa, that nice, actually question i asked is answered:)

Collectives™ on Stack Overflow

Azure - ASP.NET MVC connect to mysql database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related