MySQL Provider

Introduction

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

Why Do You Need 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.

Features

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

MySQL Provider Connection String

Provider=MySQL Provider; Data Source=MySQLServerIP; User ID =MyID; Password=MyPassword; Initial Catalog=DatabaseName; Activation=TheActivationCode;

Where

Working with MySQL OLE DB Provider

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 in Visual Studio 2005 IDE

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.

Using MySQL OLE DB Provider with SQL Server DTS

Refer to Using MySQL Provider to transfer MySQL data into SQL Server.

Activation

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.

Download

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
MySQL OLE DB Provider (Win32 Beta)
MySQL OLE DB Provider (Win32)
MySQL OLE DB Provider (Win64 Beta)
MySQL OLE DB Provider (Win64)
Provider VB Test Source
C# Sample Source Code