which provider should i use?

[jaYPee]

I am new to mysql and wondering which one is the best for accessing
mysql. I have read this article from mysql website:

At present, one can access MySQL using the following 3 interfaces
supported by MySQL.

The ODBC.NET Solution - MyODBC Driver.
Using MySQL Native .NET Providers.
Using the OLEDB.NET Solution - MyOLDDB Provider

any ideas is greatly appreciated.

[Klaus H. Probst]

I haven't tried to hit MySQL from .NET, but at least the OLEDB->ODBC bridge
from VB6 and C++ worked fine, so talking to it through the ODBC provider in
..NET should be your best bet, at least until the managed provider is a bit
more mature. But ultimately you use the one with fewer bugs =)

--
____________________
Klaus H. Probst, MVP
http://www.vbbox.com/
"jaYPee" <hi******@yahoo.com> wrote in message
news:gp********************************@4ax.com...

I am new to mysql and wondering which one is the best for accessing
mysql. I have read this article from mysql website:

At present, one can access MySQL using the following 3 interfaces
supported by MySQL.

The ODBC.NET Solution - MyODBC Driver.
Using MySQL Native .NET Providers.
Using the OLEDB.NET Solution - MyOLDDB Provider

any ideas is greatly appreciated.

[Herfried K. Wagner [MVP]]

* jaYPee <hi******@yahoo.com> scripsit:

I am new to mysql and wondering which one is the best for accessing
mysql. I have read this article from mysql website:

At present, one can access MySQL using the following 3 interfaces
supported by MySQL.

The ODBC.NET Solution - MyODBC Driver.
Using MySQL Native .NET Providers.
Using the OLEDB.NET Solution - MyOLDDB Provider

Group for ADO.NET questions:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Ben Roberts]

You could try the MySqlClient from www.sevenobjects.com

It appears to be a free ADO.Net data provider

Regards
jaYPee <hi******@yahoo.com> wrote in message news:<gp********************************@4ax.com>. ..

I am new to mysql and wondering which one is the best for accessing
mysql. I have read this article from mysql website:

At present, one can access MySQL using the following 3 interfaces
supported by MySQL.

The ODBC.NET Solution - MyODBC Driver.
Using MySQL Native .NET Providers.
Using the OLEDB.NET Solution - MyOLDDB Provider

any ideas is greatly appreciated.

[Jay B. Harlow [MVP - Outlook]]

jaYPee,
I would choose the provider in this order, unless one of the three proved to
be significantly faster then the others:

First choice: Using MySQL Native .NET Providers.
Second choice: Using the OLEDB.NET Solution - MyOLDDB Provider
Third choice: The ODBC.NET Solution - MyODBC Driver.

Native providers should be fastest as you are (hopefully) avoiding interop.
OLE DB is newer then ODBC so I would pick that next. However I have seen
cases where ODBC is faster then OLE DB for relational data, so I would test
the speed of all three to see which performs the best.

Hope this helps
Jay

"jaYPee" <hi******@yahoo.com> wrote in message
news:gp********************************@4ax.com...

I am new to mysql and wondering which one is the best for accessing
mysql. I have read this article from mysql website:

At present, one can access MySQL using the following 3 interfaces
supported by MySQL.

The ODBC.NET Solution - MyODBC Driver.
Using MySQL Native .NET Providers.
Using the OLEDB.NET Solution - MyOLDDB Provider

any ideas is greatly appreciated.