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

[Olivier Gaumond]

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