MySQL Connection String C#

Question

I've this error:

"ObdcException was unhandled by user code"

enter image description here

I dont know why this...

This is the connection string:

<add name="MiniBoxConnection" connectionString="DRIVER={MySQL ODBC 5.1 Driver};Database=DATABASENAME;Server=SERVERNAME;UID=USER;PWD=PASS;"/>

how can i solve this problem?

i'm developing in the localhost, but database is online

The name of the data source was not found and there was no default driver specified

so stuff in a try/catch block, catche the exception, and see what it says. — Marc B
– Marc B, Commented Sep 3, 2014 at 18:36
Would you mind translating the rest of the error message into English? — Kirk Woll
– Kirk Woll, Commented Sep 3, 2014 at 18:36
show your actual code so that we can see do not paste an image please — MethodMan
– MethodMan, Commented Sep 3, 2014 at 18:39
take a look at this links as well your connection string looks a bit off connectionstrings.com/mysql or stackoverflow.com/questions/10505952/… — MethodMan
– MethodMan, Commented Sep 3, 2014 at 18:40

O. Jones · Accepted Answer · 2014-09-03 18:58:21Z

You are attempting to connect to your MySQL database from your .net code using ODBC. Your error message is telling you that you haven't created an appropriately named ODBC data source object (DSN). You can do that with the ODBC Data Source Adminstrator control panel if you need to.

If I were you I would use Connector/NET instead of ODBC. It performs better and it isn't quite such a pain in the neck to configure correctly.

You can download the install kit for it here. http://dev.mysql.com/downloads/connector/net/

You'll need to change your code for this. But, it's worth it! Seriously! Your code will end up looking like this.

using System;
//etc etc
using MySql.Data.MySqlClient;
//etc etc

namespace myapp
{
    class Myclass
    {
        static void Mymethod(string[] args)
        {
            string connStr = "server=server;user=user;database=db;password=*****;";
            MySqlConnection conn = new MySqlConnection(connStr);
            conn.Open();

            string sql = "SELECT this FROM that";
            MySqlCommand cmd = new MySqlCommand(sql, conn);
            using (MySqlDataReader rdr = cmd.ExecuteReader()) {
                while (rdr.Read()) {
                    /* iterate once per row */
                }
            }
        }
    }
}

daniele3004 · Accepted Answer · 2017-09-11 13:10:01Z

5

Try this to connect and test your connection:

MySqlConnectionStringBuilder conn_string = new MySqlConnectionStringBuilder();
conn_string.Server = "127.0.0.1";
conn_string.UserID = "sa";
conn_string.Password = "myPassword";
conn_string.Database = "myDatabase";


MySqlConnection MyCon = new MySqlConnection(conn_string.ToString());


try
{
    MyCon.Open();
    MessageBox.Show("Open");
    MyCon.Close();
    MessageBox.Show("Close");
}
catch(Exception ex)
{
    MessageBox.Show(ex.Message);
}

answered Sep 11, 2017 at 13:10

daniele3004

14.1k13 gold badges76 silver badges79 bronze badges

Collectives™ on Stack Overflow

MySQL Connection String C#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related