Hello everyone!
I'm trying to get my MySql database connected with Libre Office Base. I tried all three MySql settings (Native....) and had no luck. I'm positive that the database name and password is correct. The hostname is set to mysql.mydomain.org.
The error I'm getting is no SDBC driver found.
I am using dreamhost.
I was wondering if there's a guide somewhere out there - like step by step?
Many thanks!
Connecting BASE to MySQL database.
-
- Posts: 1
- Joined: Thu Dec 22, 2011 7:22 pm
Connecting BASE to MySQL database.
LibreOffice 3.4.4 on Windows 7
Re: Connecting BASE to MySQL database.
Native driver works only in local connection, use JDBC connectors in connections over the internet.
http://wiki.services.openoffice.org/wik ... L_and_Base
http://wiki.services.openoffice.org/wik ... L_and_Base
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
Re: Connecting BASE to MySQL database.
Zoltan, do you have any references or pointers for this limitations of the native sdbc driver? I am sure it works over the network, because I use it in my LAN. But maybe your "local connection" doesn't mean "only localhost connections". The only thing I am aware of is that at least version 5.1 is required on the server side.
I can't see any reason why the sdbc driver should use something else apart from the typical tcp port 3306 to make the connection. So the only requirement would be to keep this port open in the outgoing firewall. But that's the same in case of JDBC.
I can't see any reason why the sdbc driver should use something else apart from the typical tcp port 3306 to make the connection. So the only requirement would be to keep this port open in the outgoing firewall. But that's the same in case of JDBC.
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.
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.
Re: Connecting BASE to MySQL database.
The internet only bug is on known issues (the driver works on local LAN):
http://wiki.services.openoffice.org/wik ... own_Issues
http://wiki.services.openoffice.org/wik ... own_Issues
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
Re: Connecting BASE to MySQL database.
I think is a problem in LibO 3.4 and above, also with access databases, seems that SDBC drivers weren't shipping in this versions of LibreOffice.
Look in this reported bug: https://bugs.freedesktop.org/show_bug.cgi?id=35673
Look in this reported bug: https://bugs.freedesktop.org/show_bug.cgi?id=35673
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
Re: Connecting BASE to MySQL database.
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.http://wiki.services.openoffice.org/wiki/Database/Drivers/ wrote:
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.
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.
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.