[Gambas-user] Mysql connection bug/problem ?

[Kamau Gatheru]

Hi all,

I am using Gambas 2.5
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