Re: Recommended OleDB driver for MySQL?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 10/20/04 

Date: Wed, 20 Oct 2004 09:56:23 -0500

On Tue, 19 Oct 2004 18:38:13 -0400, "Patrick Questembert" <patrickq@hotmail.com> wrote:

¤ I am accessing MySQL from VS 2003, C# and ADO.NET, using the OleDb
¤ interfaces (not ODBC) and have been using (successfully) an OLE DB driver
¤ on:
¤ http://www.mysql.com/downloads/download.php?file=Downloads/Win32/MyOLEDB3.exe&pick=mirror
¤
¤ This driver is called "My OLEDB 3.0, OLE Provider for MySQL, February 20,
¤ 2001".
¤
¤ I am actually amazed that anything written in 2001 still works with the
¤ recent MySQL 4.1 ... amazed - and worried that some of the issues I am
¤ working through may be caused by some incompatibilies ...
¤
¤ Should I be using a more recent driver?
¤
¤ I see mysql-connector-net-1.0.0-beta.zip on www.MySQL.com but this package
¤ doesn't contain any EXE (and I don't whether one can be built from the
¤ included file or how). I am not even sure this is an OLE DB provider, it may
¤ be an ODBC provider.
¤
¤ In fact, considering how new I am to MySQL, I am not even sure that *any*
¤ MySQL OLE DB provider is required: the Windows System Requirements page
¤ (http://dev.mysql.com/doc/mysql/en/Windows_system_requirements.html) does
¤ not even mention the need to install anything before proceeding with the
¤ MySQL installation (except for those planning to connect via ODBC).

There are a few options here but I can't really recommend a specific driver since I don't use MySQL
frequently. The OLEDB Provider is probably stable although you may want to look into native .NET
alternatives. The ByteFX component was apparently purchased by the MySQL folks. I don't know much
about the SevenObjects client. The CoreLab provider costs money but is fully supported.

http://www.bytefx.com/dotdata.aspx
http://www.sevenobjects.com/MySqlClient.aspx
http://crlab.com/mysqlnet/

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • Re: ODBC or OLE DB
    ... There is also a managed MySQL Data provider that works very well. ... It is not difficult to write a badly performing OLE DB ... provider that is slower than its ODBC counterpart. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MySQL via OLE DB
    ... I have looked up the help file for other options in the connection string, but it did not work in any way. ... I am using Delphi i2005 Win32 to access a MySQL 5.0.12 Database. ... Some googling pointed me to http://dev.mysql.com/downloads/ but there is no OLE DB provider for use with ADO. ...
    (borland.public.delphi.database.ado)
  • Re: Delphi 7, MySQL and ADO
    ... The problem lies in the fact that the OLE DB ... provider from www.MySQL.com is from year 2001 and does not work correctly. ... want to use MySQL with ADO you'll have to do it through the ODBC, ... To be more concrete, when you create your connection string, you should ...
    (borland.public.delphi.database.ado)
  • Re: Which MySQL Provider.
    ... Read the GPL, ... The GPL isn't different for this particular provider. ... We wanted to target Mysql in our o/r mapper. ... for their database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Normalisierung: brauche Tipp...
    ... Default engine as of MySQL 3.23 with great performance: ... CSV storage engine: CSV ... Federated MySQL storage engine: FEDERATED ... Provider dir so etwas noch anbietet, ...
    (de.comp.datenbanken.mysql)