How can I connect to MySql Database .Net

Question

0.00/5 (No votes)

See more:

Hey guys, I am trying to connect to a mySql database through my visual studio application. My connection string is as follows.

SQL

sConnString = @"Server=localhost;Port=3306;Database=test;Uid=username;Pwd=password;";

I get the following error:

Additional information: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Any ideas what I'm doing wrong?

Thanks in advance guys.

Posted 12-Jun-14 6:12am

frostcox

Add a Solution

4 solutions

Solution 2

You might want the provider:
http://dev.mysql.com/downloads/connector/net/[^]

Posted 12-Jun-14 6:27am

PIEBALDconsult

Solution 3

There are many solutions suggested by Google[^]. Try some of them first.

Posted 12-Jun-14 6:39am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Solution 4

Downloaded and installed the MySQL Connector/Net from the MySQL official website
http://dev.mysql.com/downloads/connector/net/6.1.html

Open Visual Studio and click on the new project and give the project a name; it will open the new project, then click on the solution explorer (F4); right-click on "Reference" to add a new reference into the project. Add a reference for those two .dll files to the project (MySql.dll (Win apps), MySql.web.dll (Web apps)).

]]>

Posted 12-Jun-14 8:15am

3796068

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yvan Rodrigues · Accepted Answer · 2014-06-12T06:20:00

Solution 1

You are not telling it what driver to use. It doesn't know how to connect.

First you need to decide if you are using ODBC or ADO.NET to talk to the database.

Then you need to install the ODBC[^] or ADO.NET[^] driver.

Then you need to follow the instructions that come with the driver to connect. Typically something like:

C#

var conn = new MySqlConnection("my connection string");

Posted 12-Jun-14 6:20am

Yvan Rodrigues

Comments

frostcox 12-Jun-14 16:36pm

Thank you sir, I think it was just too long a day, I followed your links and it works like a treat. Thanks again.