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

[Olivier Gaumond]

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