Hello, The MySQL server has to listen on TCP sockets for ByteFX library to connect to it - I had the same problem, everything was properly configured (/etc/odbc.ini was correct) but the example couldn't connect with the same error.
Find the following line in my.cnf (on my system, the file is located in /etc/mysql) and comment it out, so it looks like this: --- #skip-networking --- Then restart MySQL and try to connect and hopefully it will work :) If not, yell :) -- Pozdrav / Regards Aleksandar On Sun, 17 Oct 2004 23:19:51 +0200, clemente tort <[EMAIL PROTECTED]> wrote: > My Mysql version is 4.0 and the string that I use is: > > "Server=localhost; Database=test; User ID=root; Password=;" > > The one that I found in go-mono. > > Thanks :D > > > > On Sun, 17 Oct 2004 11:03:00 -0500, Reggie Burnett <[EMAIL PROTECTED]> wrote: > > What version of MySQL are you trying to connect to and what connection > > string are you using? > > > > -reggie > > > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:mono-list- > > > [EMAIL PROTECTED] On Behalf Of clemente tort > > > Sent: Saturday, October 16, 2004 6:48 PM > > > To: [EMAIL PROTECTED] > > > Subject: [Mono-list] ByteFX.Data.Mysql.... > > > > > > Hi, > > > Im new in mono, and I would like contributing on source community > > > developing software :D. Well I have a little problem (I hope) using > > > the bitefx libraries for mysql. In the web www.go-mono.com I could get > > > some info about mysql on mono, I tryed to do a little program > > > connecting to mysql, but I get some errors, I thought that I was the > > > problem :) so i tryed with the <a > > > href="http://www.go-mono.com/mysql.html";>example</a> from go-mono web, > > > but I get the same error: > > > > > > Unhandled Exception: ByteFX.Data.MySqlClient.MySqlException: Unable to > > > connect to any of the specified MySQL hosts > > > in [0x00056] (at > > > > > /home/brandon/work/mcs-1.0.1/class/ByteFX.Data/mysqlclient/Driver.cs:102 > > ) > > > ByteFX.Data.MySqlClient.Driver:Open > > > (ByteFX.Data.MySqlClient.MySqlConnectionString) > > > in [0x00017] (at > > > /home/brandon/work/mcs- > > > 1.0.1/class/ByteFX.Data/mysqlclient/ConnectionInternal.cs:106) > > > ByteFX.Data.MySqlClient.MySqlInternalConnection:Open () > > > in [0x0005a] (at > > > /home/brandon/work/mcs- > > > 1.0.1/class/ByteFX.Data/mysqlclient/MySqlPool.cs:95) > > > ByteFX.Data.MySqlClient.MySqlPool:CreateNewPooledConnection () > > > in [0x000fa] (at > > > /home/brandon/work/mcs- > > > 1.0.1/class/ByteFX.Data/mysqlclient/MySqlPool.cs:72) > > > ByteFX.Data.MySqlClient.MySqlPool:GetPooledConnection () > > > in [0x00020] (at > > > /home/brandon/work/mcs- > > > 1.0.1/class/ByteFX.Data/mysqlclient/MySqlPool.cs:126) > > > ByteFX.Data.MySqlClient.MySqlPool:GetConnection () > > > in [0x00061] (at > > > /home/brandon/work/mcs- > > > 1.0.1/class/ByteFX.Data/mysqlclient/MySqlPoolManager.cs:48) > > > ByteFX.Data.MySqlClient.MySqlPoolManager:GetConnection > > > (ByteFX.Data.MySqlClient.MySqlConnectionString) > > > in [0x00035] (at > > > /home/brandon/work/mcs- > > > 1.0.1/class/ByteFX.Data/mysqlclient/Connection.cs:304) > > > ByteFX.Data.MySqlClient.MySqlConnection:Open () > > > > > > I dont know what I did wrong, I have the mysql server running ok (I > > > can access it from other applications), what I could do bad was > > > installing the drivers (I installed them in /usr/lib). > > > > > > I hope you can help me. Thanks :D > > > > > > PS: > > > Sry for my english but i'm spanish ;) > > > -- > > > Si una piedra cae sobre un huevo, mala suerte para el huevo > > > Si un huevo cae sobre una piedra, mala suerte para el huevo > > > _______________________________________________ > > > Mono-list maillist - [EMAIL PROTECTED] > > > http://lists.ximian.com/mailman/listinfo/mono-list > > > > > > > -- > > > Si una piedra cae sobre un huevo, mala suerte para el huevo > Si un huevo cae sobre una piedra, mala suerte para el huevo > _______________________________________________ > Mono-list maillist - [EMAIL PROTECTED] > http://lists.ximian.com/mailman/listinfo/mono-list > _______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
