OK, thanks for that. Using LO 3.6.2 on Windows 7SP1 (also linux, but let's get it working here first!). Connecting to a database on xeround.com (actually hosted on Amazon EC2 servers, using port 18993. JDBC driver class com.mysql.jdbc.Driver using mysql-connector-java-5.1.22-bin.jar
John On 19 October 2012 13:16, Alexander Thurgood <alex.thurg...@gmail.com>wrote: > 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 > > -- 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