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

Alan Tam Tam@SiuLung.com
Fri, 9 May 2003 01:11:20 +0800


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
>