Is there any way to connect MS Acesss and MySql database ?

Question

I want to write same c# code for inserting data and selecting data for ms-acess database and mysql database with same database structure.Is there any way?Please help me out.

Tapan Patel · Answer

What do you mean by same code? You mean to say - in a one class? If so, there should be two methods one having connection info to Access and another to MySQL and call appropriate as needed. Or else, create two classes (with constructor initializing connection object) and use object of these two classes in your program. Whatever suits you the best.

Tapan Patel · Answer

Go through below links. For Access http://www.c-sharpcorner.com/uploadfile/c56872/connecting-c-sharp-application-to-ms-access-database/ http://stackoverflow.com/questions/17023861/how-to-connect-access-database-in-c-sharp For MySQL http://www.codeproject.com/Articles/43438/Connect-C-to-MySQL http://stackoverflow.com/questions/21618015/how-to-connect-to-mysql-database Please mark it as an answer if addresses the issue.

Joseph K · Answer

Hi Tapan Is there any way to simply my code. if (dataBase == "MySql") { String conn = "server=localhost; database=sample; uid=root; password=somepassword"; using (MySqlConnection mysqlconn = new MySqlConnection(conn)) { string query = "INSERT INTO Name VALUES(" + Name + ")"; using (MySqlCommand cmd = new MySqlCommand(query, mysqlconn)) { try { mysqlconn.Open(); cmd.ExecuteNonQuery(); } catch (Exception) { } finally { mysqlconn.Close(); mysqlconn.Dispose(); } } } if (dataBase1 == "Ms Ascess") { String conn1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "sample.mdb;Jet OLEDB:Database Password=somepassword"; using (OleDbConnection oledbconn = new OleDbConnection(conn1)) { string query = "INSERT INTO Name VALUES(" + Name + ")"; using (OleDbCommand cmd = new OleDbCommand(query, oledbconn)) { try { oledbconn.Open(); cmd.ExecuteNonQuery(); } catch (Exception) { } finally { oledbconn.Close(); oledbconn.Dispose(); } } } }

Joseph K · Answer

Hi Patel thanks for your reply, I refered above links.I have separate code for connecting to ms-access and mysql.But now i want to connect two databases with same code.

Is there any way to connect MS Acesss and MySql database ?

Answers (4)