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
