yokzu

yokzu

  • NA
  • 306
  • 0

Mysql connection problem

Mar 31 2010 10:37 AM
Hi,
I want to get data's from another computer which uses Mysql db. There is Ip address, Uid and pwd but I couldnt succes to connect to server. My codes are below. Firstly, how can I connect properly to this Mysql server? 

--------------------------------
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;

 private void button1_Click(object sender, EventArgs e)
        {
            string connectionString = @"Driver= MySQL};SERVER=192.12.11.11;DATABASE=db123;Uid=user123;Pwd=pwd123;";
            OdbcConnection conn = new OdbcConnection(connectionString);
            conn.Open(); 
            conn.Close();
        }
---------------------------------

At the conn.Open line, I am geting this error; "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

Answers (2)