Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Hi John,

Le 19/10/12 11:09, John Clegg a écrit :

The problem with the ODBC version is that Base can't download the
table structure from the server for some reason. The JDBC version can
but can't r/w. Which all suggests to me some dodgy MySQL connectors

There are some known issues with ODBC connectors, some of which cause
crashes, or data access problems, depending on which version of LO you
are using and which version of the MySQL ODBC Connector. Remember, LO is
32bit, even on Windows 64bit OS, so it requires a 32bit ODBC connector.

This is also a major problem on OSX, where :
- current versions of the OS are 64bit only as are the included mysql
servers ;
- LO is only 32bit ;
- OSX can't manage a 32bit and 64bit mysql connector at the same time
(or at least if it can, I've found no way to get it to behave properly),
so users are stuffed when it comes to MyODBC on Mac OSX unless they are
using a 32bit OS, i.e. Leopard or older..., or Snow Leopard in 32bit
kernel mode...

On Linux, the ODBC connector and LO are available in 32 and 64 bit
incarnations, so it is possible to get something up and running.

All versions of LO have had problems accessing remote database instances
via ODBC, especially if your db server is on the internet.

To check that I set up another MySQL server elsewhere and had exactly
the same problem with the JDBC connector.

I suppose I could set up a local MySQL server but I don't want it
local! And I suspect I might hit the same problem anyway.....

No, I suspect that your problem is precisely because your mysql server
is not local, or at least, not on the local lan (if I have understood
your implied setup correctly).

I don't have any problem accessing a LAN hosted mysql server instance
over the mysql JDBC connector. Trying that over the internet is a whole
other ballgame though. You need to have remote user access to your mysql
server instance other than through port 80, which is not always (rarely,
other than by SSH) provided for by hosting services. On top of that, DNS
resolution issues can cause timeouts.

It might be helpful if you gave us the exact setup you are trying to put
into place, with version numbers for the different components.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.