On 08/07/2011 12:50 PM, gsward wrote: > Does anyone have a set of instructions (or point me to a clear guide) for > setting up access to an SQLite database with Base? I am running Base on > Ubuntu 11.04. What addtional components are needed and how do I set up the > ODBC connection? ... I found these helpful:
<http://kiwinc.itgo.com/ian/TechBlog.html#OpenOffice_SQLlite> <http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org#ODBC-setup_of_new_database> Of course also ensure that you've first installed: http://packages.ubuntu.com/natty/i386/database/libreoffice-base <quote> You can extend the functionality of LibreOffice Base by installing these packages: * unixodbc: ODBC database support * libmyodbc | odbc-postgresql | libsqliteodbc | tdsodbc | mdbtools: ODBC drivers for: - MySQL - PostgreSQL - SQLite - MS SQL / Sybase SQL - *.mdb (JET / MS Access) * libmysql-java | libpg-java | libjtds-java: JDBC Drivers for: - MySQL - PostgreSQL - MS SQL Server and Sybase $ sudo apt-get install unixodbc unixodbc-bin libmyodbc odbc-postgresql libsqliteodbc tdsodbc mdbtools Or at least: $ sudo apt-get install unixodbc unixodbc-bin libsqliteodbc -- For unsubscribe instructions 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
