[Mono-list] MySQL

[Daniel Morgan]

I have replied to you inline.

-----Original Message-----
From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
Behalf Of Ben Clewett
Sent: Friday, November 01, 2002 8:19 AM
To: Daniel Morgan
Cc: mono-list@ximian.com; Rodrigo Moya
Subject: Re: [Mono-list] MySQL

"I've downloaded and compiled Mono.Data.MySql into a .dll of that name,
and begun looking into the source code.  --  So far this has given me
more confidence than others I have found, espeically when the developers
them selves are happy to write directly to me, something which has been
a universal joy of mono for me so far."

Yes, it is a joy to work on mono.  The developers are friendly and
knowledgeable.

"I would be glad to help out with any development work, although at the
moment in a capacity as a tester more than developer."

Great!  We need some good testers to find the bugs and write tests.

"I wonder if there
is a page/mailing list where specific topics about Mono.Data.MySql are
discussed.  "

The list right here is fine.  Venu, the developer from MySQL who provided
that link, has expressed interest in helping with the MySQL provider too.

"Specifically, somewhere where I can get any corrent
documentation on how this .dll should be used?"

I'm not sure what .dll you are talking about.  Are you talking about the
Mono.Data.MySql.dll assembly or the MySQL native client library?

The MySQL provider in Mono right now uses a native client shared library: on
Windows, this shared library is libmySQL.dll and on Linux, it is
libmysqlclient.so

A MySQL provider written in 100% C# would be better for performance reasons,
but that would mean we would have to keep up with the client/server protocol
used for MySQL database access.  At least with MySQL's native client
library, the API is stable.

There is a GPL'ed MySQL provider in sourceforge.net and works on .NET, but
it does not work on Mono due to problems in I/O or networking (I assume)
right now.  I have a modified version on my hard drive if interested.  I had
to strip out the Windows.Forms and System.Drawing stuff in there since we
don't need that for Mono.  This provider is written in 100% C# and does not
use any MySQL client library because it communicates directly with the MySQL
server.  This is the
MySQLNet mentioned in Venu's article.  Here is the link to that GPL'ed
driver
http://sourceforge.net/projects/mysqlnet/

Daniel Morgan wrote:

> This is what you are looking for:
>
> http://www.mysql.com/articles/dotnet/
>
> This article was written by MySQL developer detailing what options a
> person
> has to access a MySQL database using the .NET Framework.  It is very
> thorough.  It doesn't mention the MySQL provider in Mono.
>
> Mono has a MySQL provider located in mcs/class/Mono.Data.MySql and
> uses the
> MySQL native client library.  It works on Windows and Linux.  It is
> missing
> many features; however, I am actively working on this and open to any
> comments or criticism about it.
>
> The MySQL ODBC works great on Windows with .NET; it also works good with
> Mono's ODBC provider at mcs/class/System.Data/System.Data.Odbc.
>
> ADO.NET support and the MySQL provider in Mono both work, but there is
> a lot
> of missing functionality and bugs.  It is under heavy development.
>
>
> -----Original Message-----
> From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
> Behalf Of Ben Clewett
> Sent: Friday, November 01, 2002 7:13 AM
> To: mono-list@ximian.com
> Subject: [Mono-list] MySQL
>
>
>
> Dear Mono,
>
> I have need of a MySQL driver (preferably nothing to do with ODBC) which
> works under Linux and on Windows.  Ie, preferably written in c#.
>
> I have seen various ones which are: -Platform Dependent, -Have no
> visible documentation, -Licence Restricted, -Undefined/Dubius Quality.
> (etc...)
>
> If anybody can give me a link, or share any experience, this would be
> extreamly useful for me.
>
> ---------------------------------------------------------------------
> Ben Clewett, B.Clewett@roadrunner.uk.com
>
>
> _______________________________________________
> Mono-list maillist  -  Mono-list@ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list



--
---------------------------------------------------------------------
Ben Clewett, B.Clewett@roadrunner.uk.com


_______________________________________________
Mono-list maillist  -  Mono-list@ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list