[Mono-list] ADO MySQL Provider and Mono - Linux
Alan Tam
Tam@SiuLung.com
Fri, 9 May 2003 08:59:46 +0800
Dear Reggie,
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.
Thanks for the fixes and adding of unit tests. I hope I can conclude it works
well after I tried it later today ;p
Regards,
Alan
----- 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
Alan
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.
I apologize to you and everyone else for not having a lot of time to work on
this right now. Another project is pressing...
Reggie
> -----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=localhost;Database=test;User
> > ID=test;Password=test;
> >
> > SQL# \Open
> > Attempt to open connection...
> > Loading external provider...
> > External provider loaded.
> > Exception Caught Opening. NotSupp_EncodingName
> >
> > Olivier
> >
> >
> > --- Olivier Gaumond <ogaumond@yahoo.com> a écrit : >
> > > 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 écrit : > The ByteFX MySQL only
> supports
> > > socket connections. You can try "mysql -h
> > > > localhost -u test -p" and use a connection string like
> > > > "Server=localhost;Database=test;User ID=test;Password=test"
> > > >
> > > > 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èche-vitrine ou lèche-écran ?
> > > > > 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èche-vitrine ou lèche-écran ?
> > > magasinage.yahoo.ca
> > > _______________________________________________
> > > Mono-list maillist - Mono-list@lists.ximian.com
> > > http://lists.ximian.com/mailman/listinfo/mono-list
> >
> > __________________________________________________________
> > Lèche-vitrine ou lèche-écran ?
> > 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
_______________________________________________
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list