C# connect to mysql server

Question

I need your help on this one.

I got the error message which is stated:

"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 was trying to connect other local computer local host using ip. My code:

 public DbStudent() { UGIcon = new SqlConnection(); UGIcon.ConnectionString = "server= IPAddress;user="id";password="pass";database=MyDB"; } public SqlConnection Open() { UGIcon.Open(); return UGIcon; } public void Close() { UGIcon.Close(); }

Could somebody help me out please?

Your title has MySql and your error is about SQL Server, are you trying to connect to MySQL database using SqlConnection ? — Habib
– Habib, Commented Mar 11, 2013 at 8:00
Yes,is it possible? or can you give me the other way to connect mysql? — Wiranata
– Wiranata, Commented Mar 11, 2013 at 8:02
I don't understand how your code may compile : your connection string contains unescaped quotes... — Kek
– Kek, Commented Mar 11, 2013 at 8:03
Your code is even can't compiled...The connection string should be "server= IPAddress;user=id;password=pass;database=MyDB" — Iswanto San
– Iswanto San, Commented Mar 11, 2013 at 8:05
i'm sorry if i cause the confusion. although i'm just the beginner on it, actually i still quite don't understand. — Wiranata
– Wiranata, Commented Mar 11, 2013 at 8:06

Tomtom · Accepted Answer · 2013-03-11 08:14:18Z

2

You need to download the installation from MySql

There you'll get a driver for the mysql-database

answered Mar 11, 2013 at 8:14

Tomtom

9,4287 gold badges58 silver badges99 bronze badges

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

Comments

Iswanto San · Accepted Answer · 2013-03-11 08:10:15Z

The SqlConnection is used to access SQL Server, for another database use OleDbConnection. So, if you want connect to MySQL use OleDbConnection instead.

 public DbStudent() { UGIcon = new OleDbConnection(); UGIcon.ConnectionString = "Server=IPAddress;Database=MyDB;Uid=id;Pwd=pass;"; }

You can see here for MySQL Connection String

Collectives™ on Stack Overflow

C# connect to mysql server

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related