[Gambas-user] Mysql connection bug/problem ?

[Marcelo Confortino]

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 at 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