[Gambas-user] Mysql connection bug/problem ?

[Kamau Gatheru]

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
<mconfortino at ...1877...> 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 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
>
>
> -------------------------------------------------------------------------
> 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
>