how to connect MYSQL server using ASP.NET?

Question

I want to use MYSQL server with my asp.net application. But i am not able to connect to it. I am getting error that is "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified " .

My code is:-

 System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=new_testdb; User=root;Password=abc123#;");
    cn.Open();

    System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand();

    System.Data.Odbc.OdbcDataAdapter adp = null;

    DataSet ds = new DataSet();

    cmd.Connection = cn;

    cmd.CommandText = "Select * from new_table";

    adp = new System.Data.Odbc.OdbcDataAdapter(cmd);

    adp.Fill(ds, "new_table");

    this.GridView1.DataSource = ds;

    this.GridView1.DataMember = "new_table";

    cn.Close();

i don't know i have installed only MYSQL server.. is it some different than that? — Ram Singh
– Ram Singh, Commented Dec 15, 2011 at 10:30

KV Prajapati · Accepted Answer · 2011-12-15 10:58:10Z

1

Try to download ADO.NET MySql Connector API (managed MySql Data provider) instead of ODBC Driver.

EDIT: Connector/NET Examples

edited Dec 15, 2011 at 10:58

answered Dec 15, 2011 at 10:31

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

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

2 Comments

KV Prajapati Over a year ago

@raman - Then don't use Odbc. Add the reference of MySql.Data.Dll in your project and use classes from MySql.Data.MySqlClient namespace.

Ram Singh Over a year ago

can you provide me any link that will helpful to me because i am new to MYSQL. I didn't try this server with asp.net so.

Devart · Accepted Answer · 2011-12-16 08:31:23Z

1

You also may connect to MySQL with dotConnect for MySQL components.

Try to build the connection string with MySqlConnectionStringBuilder class.

edited Dec 16, 2011 at 8:31

answered Dec 15, 2011 at 10:43

Devart

120k23 gold badges172 silver badges189 bronze badges

Comments

aleafonso · Accepted Answer · 2011-12-15 10:29:32Z

0

This is what you need: http://dev.mysql.com/downloads/connector/net

Enjoy!

answered Dec 15, 2011 at 10:29

aleafonso

2,2568 gold badges38 silver badges60 bronze badges

Comments

Elias Hossain · Accepted Answer · 2011-12-15 10:32:58Z

0

Could you please see here My SQL ConnectionString or ConnectionString

answered Dec 15, 2011 at 10:32

Elias Hossain

4,4991 gold badge23 silver badges33 bronze badges

Comments

Pranav Singh · Accepted Answer · 2014-02-11 05:32:03Z

0

Click Left btn on database in server explorer, select properties copy connection string;

2.string c= persistsecurityinfo=True;server=localhost;user id=root;password=admin;database=sam;

        MySqlConnection cn = new MySqlConnection(c);

        cn.Open();
        Response.Write("Connection successful !!");
        MySqlDataAdapter Mda = new MySqlDataAdapter("select * from tblName", cn);
        DataSet ds = new DataSet();
        Mda.Fill(ds, "tblName");
        GridView1.DataSource = ds.Tables["tblName"];
        GridView1.DataBind();

Make sure that :-

using System.Data;

using MySql.Data.MySqlClient;

imported... :)

edited Feb 11, 2014 at 5:32

Pranav Singh

20.3k32 gold badges83 silver badges109 bronze badges

answered Feb 11, 2014 at 5:12

Samrat

11 bronze badge

Collectives™ on Stack Overflow

how to connect MYSQL server using ASP.NET?

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related