Accessing non-intranet servers by IP address might fail
If you set up a connection to a MySQL server outside your intranet, which is known by IP address, this might fail with an error code of 10060, effectively saying "Can't connect". The problem is not fully analyzed, yet, so the problem description here is somewhat rough at the moment.
This is the statement that r4zoli referenced in his post above. I have to fully agree with the might
fail, because I had no problems to connect to my tables via the internet (including a NAT router doing port forwarding at the last hop) both via a DNS name and directly via the IP address.
And as far as I understand this, the failures should not happen if you use a hostname that is resolved via DNS or via the local /etc/hosts file. If you have admin privileges on your local computer you can always add an entry to the host file that enables you to specify the SQL connection with a hostname if you got failures with IP addresses in the connect string.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.