[Mono-list] ADO MySQL Provider and Mono - Linux

Reggie Burnett rykr@bellsouth.net
Thu, 8 May 2003 20:03:38 -0500


Alan

I have made many changes since 0.65 and have not verified (yet) that the
latest works under Mono.  I am under water on a project right now but am
pushing to release a 1.0 of the driver in 1-2 months.

Reggie

> -----Original Message-----
> From: Alan Tam [mailto:Tam@SiuLung.com]
> Sent: Thursday, May 08, 2003 8:00 PM
> To: Reggie Burnett; 'Olivier Gaumond'; mono-list@lists.ximian.com
> Subject: Re: [Mono-list] ADO MySQL Provider and Mono - Linux
>=20
> Dear Reggie,
>=20
> Nice to see you here. I concluded the problem in the current CVS =
because I
> see
> the bug not closed. I didn't really try that, partly because when you
> introduced the MySqlPool it first failed in Mono because the
> Convert.ToInt32()
> function ... and a lot of lame spec problems were found.
>=20
> Thanks for the fixes and adding of unit tests. I hope I can conclude =
it
> works
> well after I tried it later today ;p
>=20
> Regards,
> Alan
>=20
> ----- Original Message -----
> From: "Reggie Burnett" <rykr@bellsouth.net>
> To: "'Alan Tam'" <Tam@SiuLung.com>; "'Olivier Gaumond'"
> <ogaumond@yahoo.com>;
> <mono-list@lists.ximian.com>
> Sent: 2003-05-09 04:30
> Subject: RE: [Mono-list] ADO MySQL Provider and Mono - Linux
>=20
>=20
> Alan
>=20
> Have you tried the latest CVS?  I have corrected some things with
> parameter
> replacement and do not know of major problems with parameter =
replacement
> right now.
>=20
> I apologize to you and everyone else for not having a lot of time to =
work
> on
> this right now.  Another project is pressing...
>=20
> Reggie
>=20
> > -----Original Message-----
> > From: mono-list-admin@lists.ximian.com [mailto:mono-list-
> > admin@lists.ximian.com] On Behalf Of Alan Tam
> > Sent: Thursday, May 08, 2003 12:11 PM
> > To: Olivier Gaumond; mono-list@lists.ximian.com
> > Subject: Re: [Mono-list] ADO MySQL Provider and Mono - Linux
> >
> > This error is expected. In ByteFX 0.68, it hardcoded an encoding =
name
> > "latin1"
> > which is not supported in Mono. However the current CVS version has
> > parameter
> > replacement broken. Version 0.65 is the working version most =
compatible
> > with
> > Mono.
> >
> > Regards,
> > Alan
> >
> > ----- Original Message -----
> > From: "Olivier Gaumond" <ogaumond@yahoo.com>
> > To: "Olivier Gaumond" <ogaumond@yahoo.com>; "Alan Tam"
> <Tam@SiuLung.com>;
> > <mono-list@lists.ximian.com>
> > Sent: 2003-05-09 01:07
> > Subject: Re: [Mono-list] ADO MySQL Provider and Mono - Linux
> >
> >
> > >
> > > I found the answer to my second question by reading the SqlSharp
> README
> > file.
> > > But I still get an exception:
> > >
> > > $ mono sqlsharp.exe
> > >
> > > SQl# \Provider MySqlNET
> > > The default Provider is LOADEXTPROVIDER
> > >           Assembly: ByteFX.Data
> > >   Connection Class: ByteFX.Data.MySQLClient.MySQLConnection
> > >
> > > SQL# \ConnectionString Server=3Dlocalhost;Database=3Dtest;User
> > > ID=3Dtest;Password=3Dtest;
> > >
> > > SQL# \Open
> > > Attempt to open connection...
> > > Loading external provider...
> > > External provider loaded.
> > > Exception Caught Opening. NotSupp_EncodingName
> > >
> > > Olivier
> > >
> > >
> > >  --- Olivier Gaumond <ogaumond@yahoo.com> a =E9crit : >
> > > > I am not sure to understand what you are suggesting.  I am =
currently
> > able
> > to
> > > > connect to mysql with socket connection.
> > > >
> > > > How I can use SqlSharp to use the ByteMX.Data provider instead =
of
> > > > Mono.Data.MySql which is deprecated?
> > > >
> > > > Olivier
> > > >
> > > >  --- Alan Tam <Tam@SiuLung.com> a =E9crit : > The ByteFX MySQL =
only
> > supports
> > > > socket connections. You can try "mysql -h
> > > > > localhost -u test -p" and use a connection string like
> > > > > "Server=3Dlocalhost;Database=3Dtest;User =
ID=3Dtest;Password=3Dtest"
> > > > >
> > > > > Regards,
> > > > > Alan
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Olivier Gaumond" <ogaumond@yahoo.com>
> > > > > To: <mono-list@lists.ximian.com>
> > > > > Sent: 2003-05-08 23:57
> > > > > Subject: [Mono-list] ADO MySQL Provider and Mono - Linux
> > > > >
> > > > >
> > > > > > I have not found any project specific list for this, so I =
post
> > here.
> > > > > >
> > > > > > I followed all the steps on the ADO.NET page on go-mono.com =
to
> > test the
> > > > > MySQL
> > > > > > Data Provider.  When I run the sample, exceptions are =
thrown.
> > > > > >
> > > > > > I installed mono from the latest RPM (0.24) on RedHat 9.  =
And I
> > tried
> > > > with
> > > > > both
> > > > > > the ByteFX.Data.dll supplied in the mono RPM and the one =
from
> > > > > > http://sourceforge.net/projects/mysqlnet/ (version 0.68)
> > > > > >
> > > > > > With the Mono-0.24 version I get the followinf exceptions
> > > > > >
> > > > > > Unhandled Exception: ByteFX.Data.MySQLClient.MySQLException: =
A
> > system
> > > > > exception
> > > > > > has occurred.
> > > > > > in <0x001cf> 00 =
ByteFX.Data.MySQLClient.Driver:ReadStreamByte ()
> > > > > > in <0x00062> 00
> ByteFX.Data.MySQLClient.Driver:ReadServerDataBlock
> > ()
> > > > > > in <0x00049> 00 ByteFX.Data.MySQLClient.Driver:ReadPacket ()
> > > > > > in <0x00023> 00 ByteFX.Data.MySQLClient.Driver:CheckResult =
()
> > > > > > in <0x000f5> 00 ByteFX.Data.MySQLClient.Driver:Authenticate
> > > > > > (string,string,bool)in <0x00113> 00
> > ByteFX.Data.MySQLClient.Driver:Open
> > > > > > (string,int,string,string,bool)
> > > > > > in <0x00138> 00 ByteFX.Data.MySQLClient.MySQLConnection:Open =
()
> > > > > > in <0x00075> 00 .Test:Main (string[])
> > > > > >
> > > > > >
> > > > > > With the SourceForge Version (0.68) I get the following
> exceptions
> > > > > > Unhandled Exception: System.NotSupportedException:
> > NotSupp_EncodingName
> > > > > > in <0x002db> 00 System.Text.Encoding:GetEncoding (string)
> > > > > > in <0x0001d> 00 =
ByteFX.Data.MySQLClient.Driver:WriteStringNoNull
> > (string)
> > > > > > in <0x00010> 00 ByteFX.Data.MySQLClient.Driver:WriteString
> > (string)
> > > > > > in <0x000a0> 00 ByteFX.Data.MySQLClient.Driver:Authenticate
> > > > > > (string,string,bool)in <0x0010a> 00
> > ByteFX.Data.MySQLClient.Driver:Open
> > > > > > (string,int,string,string,bool)
> > > > > > in <0x00116> 00 ByteFX.Data.MySQLClient.MySQLConnection:Open =
()
> > > > > > in <0x00075> 00 .Test:Main (string[])
> > > > > >
> > > > > >
> > > > > > I created the employee table in database 'test', and created =
the
> > user
> > > > > 'test',
> > > > > > and modified the connection string in the sample.  I =
verified
> that
> > I
> > can
> > > > > > connect succesfully to the database with the following =
command:
> > > > > > mysql -u test -p -e 'SELECT * FROM employee' test
> > > > > >
> > > > > > Any clue?
> > > > > >
> > > > > > Olivier
> > > > > >
> > > > > > __________________________________________________________
> > > > > > L=E8che-vitrine ou l=E8che-=E9cran ?
> > > > > > magasinage.yahoo.ca
> > > > > > _______________________________________________
> > > > > > Mono-list maillist  -  Mono-list@lists.ximian.com
> > > > > > http://lists.ximian.com/mailman/listinfo/mono-list
> > > > > >
> > > > >
> > > > > _______________________________________________
> > > > > Mono-list maillist  -  Mono-list@lists.ximian.com
> > > > > http://lists.ximian.com/mailman/listinfo/mono-list
> > > >
> > > > __________________________________________________________
> > > > L=E8che-vitrine ou l=E8che-=E9cran ?
> > > > magasinage.yahoo.ca
> > > > _______________________________________________
> > > > Mono-list maillist  -  Mono-list@lists.ximian.com
> > > > http://lists.ximian.com/mailman/listinfo/mono-list
> > >
> > > __________________________________________________________
> > > L=E8che-vitrine ou l=E8che-=E9cran ?
> > > magasinage.yahoo.ca
> > > _______________________________________________
> > > Mono-list maillist  -  Mono-list@lists.ximian.com
> > > http://lists.ximian.com/mailman/listinfo/mono-list
> > >
> >
> > _______________________________________________
> > Mono-list maillist  -  Mono-list@lists.ximian.com
> > http://lists.ximian.com/mailman/listinfo/mono-list
>=20
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list