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+h...@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
