Re: [libreoffice-users] looking for help on Base

On 05/08/11 00:04, Roberto Scotti wrote:
> Is it possible to install MS-Access and/or SQLite native-drivers in
> Linux?

Roberto,

It is possible to get SQLite to work on Ubuntu 10.04 LTS. These are my 
notes on how I set it up on my machine...

Most of software in Ubuntu 10.04 can not directly access SQLite 
Databases and it is necessary to install unixODBC plus the SQLite Driver.

Installation of the unixODBC package (http://www.unixodbc.org/) can be 
easily done from the Ubuntu Software Centre. The website provides a link 
to the appropriate driver maintained by Carl Weirner.

Installation of the SQLite ODBC Driver
(http://www.ch-werner.de/sqliteodbc/) is a little more involved.

The website provides a link to the appropriate linux download
(http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.88.tar.gz).
Download this file and extract the directory to a folder.

Open a terminal within the sqliteodbc-0.88 directory and run the 
following commands.

   ./configure
   sudo make install

Check that the drivers have been registered in /etc/odbcinst.ini. The 
configuration settings required for this file are outlined in the 
../sqliteodbc-0.88/README file. My installation did not require any 
changes as the odbcinst.ini file was correctly configured.

In order to have Ubuntu see you odbc database change the ~/.odbc.ini 
file so it includes the following data.

   [mysqlitedb]
   Description=My SQLite test database
   Driver=SQLite3
   Database=/home/username/databasename
   # optional lock timeout in milliseconds
   Timeout=2000

You should now be able to see the database in LibreOffice Base or other 
packages that can use ODBC drivers.

--
Cheers Simon

   Simon Cropper
   Website Administrator
   http://www.fossworkflowguides.com
   The fossWorkflow Guides
   (c) Simon Cropper CC-BY-SA 3.0 Australia
   http://creativecommons.org/licenses/by-sa/3.0/au/deed.en

--
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