[Mono-list] ByteFX.Data.Mysql....

[Aleksandar Radulovic]

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 <clementetb@gmail.com> 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 <rykr@comcast.net> wrote:
> > What version of MySQL are you trying to connect to and what connection
> > string are you using?
> >
> > -reggie
> >
> >
> >
> > > -----Original Message-----
> > > From: mono-list-admin@lists.ximian.com [mailto:mono-list-
> > > admin@lists.ximian.com] On Behalf Of clemente tort
> > > Sent: Saturday, October 16, 2004 6:48 PM
> > > To: Mono-list@lists.ximian.com
> > > 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  -  Mono-list@lists.ximian.com
> > > 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  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>