Mukesh Patel

Mukesh Patel

  • NA
  • 144
  • 0

Connect Windows Mobile Application to the My Sql Database

Aug 30 2010 7:40 AM
Dear all,

I am a beginer of in the field of Mobile Application Development ,I need to connect with my Windows Mobile Application to the My Sql Database .
I have downloded the connector for that also used the programme is build fine and I also created Cab file but when I  am oping in my device it is genrating exception like this "Requested value My sql ODBC 3.51 driver was not found".

To solve this I have also download the latest driver but unable to get result.
my code is
using MySql.Data.MySqlClient;
using System.Net;

 MySqlConnection con = new MySqlConnection("DRIVER={MySQL ODBC 3.51 Driver};SERVER=xxxxxx; Port=3306;DATABASE=xxxxx;UID=xxxxx;PWD=xxxxx;");
            MySqlDataAdapter da = new MySqlDataAdapter("select * from Test", con);
            con.Open();
            DataSet ds = new DataSet();
            da.Fill(ds, "Test");
            dataGrid1.DataSource = ds;
            con.Close();

Please help me