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. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted