By Pavel Tsekov
.NET provides easy access to any type of database through the OLE DB provider (System.Data.OleDb).
Of course we could connect to a data source also through ODBC, but firstly we should download the
.NET ODBC driver from the Microsoft site.
Here is an example of how to open MySQL database through OLE DB Provider in C#.
Requirements for this example to work properly:
1) Visual C#.
2) MySQL Server installed on our machine.
3) MySQL OLEDB Provider installed on our machine (this provider can be found at www.mysql.com)
The example project source is in an attachment file : MySQLTest.zip
