Did you check the Mysql database in mysql ? In the users records there is also reference to the host the user is allow to use. If it's marked localhost, that's your problem.
Regards, Steven Le jeudi 21 août 2008 à 13:39 +0300, Kamau Gatheru a écrit : > As a matter of fact I have, > > Here is a sample of the /etc/hosts, listing > my database servers > > 127.0.0.1 localhost > 127.0.1.1 MvServer > 192.168.1.200 Mvserver > 192.168.1.100 Server > .... > > surprisingly even on the local machine (MvServer) > only .host = "localhost" works > > > > On Thu, Aug 21, 2008 at 10:18 AM, Marcelo Confortino > <[EMAIL PROTECTED]> wrote: > > Kamau Gatheru escribió: > >> Hi all, > >> > >> I have been trying to connect to a remote mysql server (within my network) > >> and it seems all my local installations of Gambas cannot do that. > >> Incidentally > >> I discovered that the .Port element doesn't work. I can run the following > >> code > >> locally and it works fine. > >> > >> WITH Conn > >> > >> .type = "mysql" > >> .host = "localhost" > >> .Port = "4444" <------- I put the wrong port and it still > >> works regardless > >> .login = "user" > >> .Password = "" > >> .Name = "control" > >> > >> END WITH > >> > >> > >> but when trying to connect to a remote computer using the correct > >> parameters > >> > >> WITH Conn > >> > >> .type = "mysql" > >> .host = "remotehost" > >> .Port = "3306" <------- Correct port > >> .login = "user" > >> .Password = "" > >> .Name = "control" > >> > >> END WITH > >> > >> I get an error ( Cannot open database: Unknown MySql server host 'The > >> -remote-host' (1) ) > >> or another error ( Cannot open database: Can't connect to MySql server > >> on 'My -remote-host' (111) ) > >> > >> Could you please give me a work around or the proper procedure to > >> connecting to > >> a remote MySql database server. > >> > >> Thanks and best regards, > >> > >> Kamau Gatheru > >> > >> ------------------------------------------------------------------------- > >> This SF.Net email is sponsored by the Moblin Your Move Developer's > >> challenge > >> Build the coolest Linux based applications with Moblin SDK & win great > >> prizes > >> Grand prize is a trip for two to an Open Source event anywhere in the world > >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ > >> _______________________________________________ > >> Gambas-user mailing list > >> Gambas-user@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/gambas-user > >> > >> > > This may seem obvious, but do you have 'remotehost' listed in > > /etc/hosts? Bye. M. > > __________________________________________________ > > Correo Yahoo! > > Espacio para todos tus mensajes, antivirus y antispam ¡gratis! > > ¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar > > > > > > ------------------------------------------------------------------------- > > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > > Build the coolest Linux based applications with Moblin SDK & win great > > prizes > > Grand prize is a trip for two to an Open Source event anywhere in the world > > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > > _______________________________________________ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
