[Mono-list] ADO MySQL Provider and Mono - Linux
Reggie Burnett
rykr@bellsouth.net
Thu, 8 May 2003 15:30:15 -0500
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. =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...
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
>=20
> 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.
>=20
> Regards,
> Alan
>=20
> ----- 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
>=20
>=20
> >
> > 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
> >
>=20
> _______________________________________________
> Mono-list maillist - Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list