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: users+help@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