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

On 08/05/2011 01:25 AM, Roberto Scotti wrote:
> Il giorno gio, 04/08/2011 alle 09.45 -0700, NoOp ha scritto:
> > On 08/04/2011 01:19 AM, Roberto Scotti wrote:
> > > the site  http://www.libreoffice.org/features/base/   states
> > > "... provides native-support drivers for some of the most-widely
> > > employed multi-user database engines: MySQL, Adabas D, MS Access..."
> > >
> > > When I open Base if I choose to "connect to an existing database" the
> > > list of available drivers doesn't include MS Access (or JET), it
> > > includes only:
> > > JDBC
> > > JDBC Oracle
> > > Adabas D
> > > Foglio elettronico
> > > dBASE
> > > Testo
> > > MySQL
> > > ODBC
> > >
> > > How do you activate the MS Access native-support driver?
> > > Is a SQLite native-support driver available?
> > > Many thanks, Roberto Scotti
> >
> > Maybe this will help:
> >
> > 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
> >
> > Check to see if you have those installed.
> Yes, at least I tried to install mdbtools, the stand-alone viewer is
> working:
> "gmdb2 0.6pre1
> GNOME MDB Viewer is a grapical interface to MDB Tools. It lets you view
> and export data and schema from MDB files produced by MS Access
> 97/2000/XP/2003."
> What is needed next to have it available in LbreOffice-Base?
> Many thanks, rs

It appears to still have issues. I'm getting this error:


[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed

I'll post back when I get it figured out.



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