[Gambas-user] mysql db connection issue

[Sebastian Wild]

hi list,

I got the following issue:

I wrote a gambas2 app which connects to a local mysql database and 
selects from its tables or inserts into them etc.  - this worked fine

Now I tried to change this to connecting to a non local mysql database 
(i.e. remote mysql server) by changing the "host" attribute of the 
connection object to the external mysql server's ip.
Now when I start the app afterwards and the app tries to connect to the 
db it just raises an "cannot connect to local mysql server through 
socket /var/run/mysqld/mysqld.sock".
Now why does it try to connect the local mysql server if set up to 
connect an external mysql server?!

some tech data:
using gambas 1.9.7 on SuSE 10.0 the local mysqld aswell as the external 
one are mysql v5.
I can connect to the local as well as to the external mysqld via mysql 
client on a shell successfully so that is not a mysql issue.

So my question is: am I doing something wrong? Or is this an error in gb.db?
Does anyhone have any suggestion to this?

thanx in advance
Sebastian

-- 
--
Mit freundlichen Gruessen,

Sebastian Wild
Administrator/Technik
------------------------------------------------------------------------------------
Telefon: + 49 (0)941 - 56 71 23 95
Telefax: + 49 (0)941 - 59 57 91 64
E-Mail:    sw at ...1675... 
Website: http://www.cronon.org
------------------------------------------------------------------------------------
Cronon AG 
Niederlassung Regensburg
Obermünsterstraße 9
93047 Regensburg
------------------------------------------------------------------------------------
Vorsitzender des Aufsichtsrates: Damian Schmidt
Vorstand: Florian Heinz, Viktor Hinterleitner,
Christian Mueller, Wolfgang von Hardenberg
Amtsgericht Berlin-Charlottenburg HRB 77957