MySQL probably is one of the most popular open source database engines. To learn more about MySQL Database server, please visit MySQL Website.
You may download MySQL, its tool and their source code from MySQL Website. The MySQL OLE DB Provider is implemented with ATL OLE DB Provider templates so that the provider itself has small footprint even though the provider does not have many dependencies. You may use ADO or ADO.NET 2.0 to access data with MySQL OLE DB Provider
MySQL OLE DB Provider can be used to access MySQL database in your native code and .NET code as well. It has few dependency and is is very easy to use and very easy to deploy as well.
Most importantly, Cherry City Software MySQL OLE DB Provider is the best OLE DB Provider for MySQL database.
The following are the features that this MySQL OLE DB Provider supports:
The current release was tested with MySQL 4.1.x and 5.x
MySQL TIME is mapped to string. MySQL ENUM, SET and GEOMETRY data types are not supported.
* - If the SQL statements have parameters, each statement must be executed seperately.
** - Not applicable if MySQL version is 4.1.x or older
Provider=MySQL Provider; Data Source=MySQLServerIP; User ID =MyID; Password=MyPassword; Initial Catalog=DatabaseName; Activation=TheActivationCode;
Where
Using MySQL OLE DB Provider is simple if you have the knowledge of ADO or ADO.NET. The sample code is intended to demostrate how to use MySQL OLE DB Provider. You may find sample code below that demostrate how to use MySQL OLE DB Provider with ADO and ADO.NET. The sample will show you how to use the following features:
Using MySQL OLE DB Provider with Visual Studio 2005 IDE is very handy. You can readily add MySQL OLE DB Provider into Visual Studio 2005 IDE by adding Data connections via the OLE DB provider.
Refer to Using MySQL Provider to transfer MySQL data into SQL Server.
MySQL OLE DB Provider must be activated before you can use it. To activate it, you must download the provider and get your passcode from the Activator included in the package. Click here to get activation code.
Update History:
| Date | Changes |
|---|---|
| 2010-08-29 | Improved performance on query execution such that column schema information is retrieved if and only if needed |
| 2010-07-22 | Fixed a defect without join and show grants in linked server |
| 2010-07-03 | Fixed a defect with blob date type in the case such that the data size is bigger than 8000 bytes |
| 2010-06-23 | Corrected error message for registration failure |
