How to connect .Net Webservice with local database

Question

I have to connect my Database to an existing code in .NET. My Database is a MySql DB in PhpMyAdmin.

I am using System.Data.SqlClient in .NET and it seems like I cant get the connection String right for the connection function

private string _connetionString = @"Data Source=localhost;Initial Catalog=Testdb;"
SqlConnection _connection;

public DatabaseService()
{
  _connection = new SqlConnection(_connetionString);
}

Everytime I start my .Net-Service it needs a long time to and eventually the connection fails.

Try using that connection information and see if you can log-in to the db from another tool. That will help you out. — CodingYoshi
– CodingYoshi, Commented Jun 22, 2019 at 16:22
Ah damn, this is not the right information. This is the information from the other server. The problem is, that I am trying to connect some code that a colleague used on his machine, now im trying to use it on my machine with my own setup. — Helmut K.
– Helmut K., Commented Jun 22, 2019 at 16:24

Stano Peťko · Accepted Answer · 2019-06-22 16:49:38Z

2

SqlConnection class (the whole namespace System.Data.SqlClient) is for connection to Microsoft SQL Server. You are using MySQL, so you need to use System.Data.OleDb namespace (OleDbConnection).

How connestion string for MySql look you can check here: https://www.connectionstrings.com/mysql-connector-net-mysqlconnection/

answered Jun 22, 2019 at 16:49

Stano Peťko

1666 bronze badges

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

Comments

debracey · Accepted Answer · 2019-06-22 16:49:54Z

1

That's not the right connection string syntax for MySQL. The sample you've posted looks to be for MSSQL. For MySQL you would need something like:

"server=localhost;uid=username;pwd=password;database=Testdb"

MySQL API Reference for .NET

answered Jun 22, 2019 at 16:49

debracey

6,6372 gold badges32 silver badges58 bronze badges

1 Comment

Helmut K. Over a year ago

Finally. This worked for me. I guess Stano Pet'kos would have worked somehow as well, but this works for me. Thanks a lot. I didn't think of checking the manual of MySQL as well. Smh...

Collectives™ on Stack Overflow

How to connect .Net Webservice with local database

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related