MySql and OleDB

[Art]

After extensive searching I have come to an apparent dead end.

I need to access a MySql database from C#. ODBC makes this very easy
however not every customer is running MySql so I want to create a reusable
OleDb layer that can be used with Sql Server, Oracle, MySql. I found MyOleDB
3.9.6, installed it and like magic I connected to the database very easily.
I thought my problems were over - until I tried to run the simplest sql
statement, "select * from ADMIN_USER;" (with and without the semi colon) and
was met with a "'MySqlProv' failed with no error message available, result
code: DB_E_ERRORSINCOMMAND(0x80040E14)" error.

Of course the sql works as expected from the MySql command console. I have
tried to fill a dataset using a DataAdapter as well as trying to execute a
DataReader. Both throw the same error. The same code works properly when
connected to a Sql Server version of the database.

Anybody else seen this? I don't want to resort to ODBC or the MySql .Net
connector. I REALLY want a generic OleDb solution.

Thanks in advance.
--
There are only 10 types of people in the world. Those that understand
binary and those who don't.

[Kevin Yu [MSFT]]

Hi Arthur,

Since the same code works fine, I think it's a driver related issue. In my
opinion, the problem most probably resides in the oledb driver for MySQL.
Since you have downloaded MyOleDB 3.9.6, you can try to contact the driver
provider for this issue. Or we can wait to see if any community member has
some experience on this.

Kevin Yu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)