[Mono-list] Mysql (ByteFX) VS Mysql (Mono)

[Pablo Fischer]

Hi guys!

Yesterday I was trying to connect to one of my mysql databases with the two 
forms (ByteFx and Mono.Data.MySql), the results are:

a) With ByteFX I can compile it without problems, BUT when I run it (mono 
mysql.exe) I get this:

Unhandled Exception: System.Net.Sockets.SocketException: Connection refused
in (unmanaged) mono(mono_raise_exception+0x20) [0x80c1460]
in (unmanaged) mono(ves_icall_System_Net_Sockets_Socket_Connect_internal+0x72) 
[0x80da4c6]
in <0x0005a> 00 System.Net.Sockets.Socket:Connect (System.Net.EndPoint)
in <0x000b3> 00 ByteFX.Data.MySQLClient.Driver:CreateSocketStream (string,int)
in <0x00038> 00 ByteFX.Data.MySQLClient.Driver:Open 
(string,int,string,string,bool)
in <0x000e4> 00 ByteFX.Data.MySQLClient.MySQLConnection:Open ()
in <0x00095> 00 .Test:Main (string[])

b) With Mono.Data.Mysql, I can compile it without problems, when I run it 
(mono mysql2.exe) I get the data of the database (that is ok) but I also get 
this:

** (mysql2.exe:2517): WARNING **: Failed to load function my_thread_end from 
libmySQL

** (mysql2.exe:2517): WARNING **: Failed to load function my_thread_end from 
libmySQL

** (mysql2.exe:2517): WARNING **: Failed to load function my_thread_init from 
libmySQL

** (mysql2.exe:2517): WARNING **: Failed to load function my_thread_init from 
libmySQL
/*The next lines are the DB data*/
Name: Nike 06/02/2003 00:00:00
Name: Nike 06/02/2003 00:00:00
Name: Nike 06/02/2003 00:00:00
/*End of DB Data*/
Unhandled Exception: System.MissingMethodException: A missing method exception 
has occurred.
in <0x00046> 06 Mono.Data.MySql.MySql:ThreadEnd ()
in <0x000b5> 00 Mono.Data.MySql.MySqlConnection:CloseDataSource ()
in <0x00053> 00 Mono.Data.MySql.MySqlConnection:Close ()
in <0x0023e> 00 .Test:Main (string[])

However, the code of both exes are from http://www.go-mono.com/mysql.html, and 
in both Im using the same server, username, password and server.

What could be happening?

I would like to discover why Im getting this error, thats why Im asking to the 
list cause Im using a MySql DataBase for a Point of Sale (PoS).

thanks!
Pablo Fischer (MX)
-- 
Pablo Fischer <exilion@yifan.net>