https://bugs.freedesktop.org/show_bug.cgi?id=54456
--- Comment #15 from Alex Thurgood <[email protected]> --- @All : On the Mac, ODBC problems are not new, they have been around since the release of OOo 3.3.x, and consequently, since the creation of the LO project. https://bugs.freedesktop.org/show_bug.cgi?id=46237 It is not a Java problem. As LO is 32bit only on Mac, the user requires a 32bit driver. However, if you are using a recent version of OSX, which Fred doesn't mention, then you are stuck. OSX 10.7 and 10.8 come with mysql server 64bit pre-installed, which can only be talked to via a 64bit ODBC connector. The ODBC 64bit connector will not talk to LO and vice-versa. A simple test for this is to use isql from the command line. Now, on 32bit OSX systems, so Tiger (10.4), Leopard (10.5) and SnowLeopard (10.6) in 32bit kernel mode, the mysql ODBC driver and LO will talk to each other, but there is a bug somewhere in one of the pieces that means that means that either you will get a connection and no data, or else, dependent on mysql ODBC driver and iODBCAdmin version, you will get a connection that only shows the first 3 results of the resultset. Fred is lucky in so far as he can at least see the first 3 results. When I was testing this throughout LO 3.3.x development, I could only get a successful connection, but no data. Note that the ODBC driver supplied by MySQL in versions 5.x is buggy as hell, and is missing bits that are required for proper operation, such as the driver setup libraries... What Fred has failed to give us so far, at least for the Mac, is : Operating system info : OSX version MySQL ODBC Driver version : iODBCAdmin version (this is supplied by Apple) : MySQL server version and whether the server instance is local or remote : The location of his odbc.ini and odbcinst.ini files. Beware, there can often be 2 or more sets of these files on an OSX system, and Apple's "protective" configuration regime prevents the normal user from seeing these locations. I can not do testing because I'm on a 64bit kernel, with a 64bit local version of mysql, which requires the 64bit driver. This driver refuses to talk to LO, or LO refuse to talk to the driver - either way, it doesn't work for me at all. Ideally, if someone wanted to try and reproduce this, they would need an older version of the MySQL ODBC 32bit driver, running on a 32bit Mac OSX system, so Tiger or Leopard, or at a pinch and with some juggling, OSX 10.6. Alex -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
