Le 15/10/2014 17:42, Hal Vaughan a écrit :
Hal, > I found this link > (https://wiki.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org) > about using SQLite with OpenOffice, but I am having trouble finding updated > info about using SQLite with LibreOffice and the link talks abut doing this > on Windows and Linux, but does not mention OS X or Mac at all. (There’s also > this, from 2 years ago: > http://ask.libreoffice.org/en/question/5523/sqlite-driver-for-mac-os-x-and-other-oss/) > > I’ve tried a few possibilities, but I can’t get LibreOffice to read my SQLite > DB files. Is there anything more current that allows use of SQLite with > LibreOffice on OS X? There used to be an extension that worked on Linux and Windows, but I don't recall it ever working on OSX. Download a corresponding JDBC driver for SQLite, there are several available, including Christian Werner's own package. Create your sqlite database beforehand with an ad hoc tool. Set up a database file that connects to the sqlite file via the JDBC driver. You will have to add the JAR file to the classpath in the Java options setup of LO. When you start the db creation wizard in LO, you will need to find the driver connection string and driver name - these are often provided either in the driver documentation, or the corresponding web site http://www.ch-werner.de/javasqlite/ I haven't tried the driver above, but was successful with a different driver that I downloaded here : http://www.java2s.com/Code/Jar/s/Downloadsqlitejdbcjar.htm In the db setup wizard : URL sqlite://absolute/path/to/test.sqlite3 JDBC Driver Class : org.sqlite.JDBC This works for me on OSX 10.9.5 Alex -- To unsubscribe e-mail to: [email protected] 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
