string conString = "Server=" + m_ConData1.ComputerName
+ ";Database=" + m_ConData1.Database
+ ";User ID=" + m_ConData1.DbUser
+ ";Password=" + m_ConData1.Password
+ ";CharSet=" + m_ConData1.CharacterSet;
MySql.Data.MySqlClient.MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection(conString)
con.Open();
System.Data.DataTable WorkingTable = new System.Data.DataTable();
MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter(command, con);
da.Fill(WorkingTable);
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
To configure the odbc connection follow the following steps:
Going to control panel -> administrative tools -> data sources (odbc). Then go to the system dsn tab and click add. On the first step of the wizard select the mysql odbc driver then fill out the connection details. If you dont see the mysql odbc driver then you need to get it http://dev.mysql.com/get/Downloads/Connector-ODBC/5.1/mysql-connector-odbc-5.1.5-win32.msi/from/pick (but you said you did already).
Once you finish the wizard you should be able to access this odbc data source with active reports using the oledb odbc driver.