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

On 08/12/2011 03:03 AM, Roberto Scotti wrote:
> Il giorno sab, 06/08/2011 alle 10.25 -0700, NoOp ha scritto:
...
> > I finally managed to get Base to connect to the Access file (old Office
> > 97 Northwind example .mdb) and even list the tables in the file. However
> > when I attempt to view the table LO (and OOo) crashes with no apparent
> > crash info (i.e., LO & OOo simply dismiss). To do that I use a different
> > driver: /usr/lib/libmdbodbc.so.0 instead of /usr/lib/libmdb.so.1. So
> > it's closer than before...
> >
> > For Roberto: my odbcints.ini entry looks like this:
> > [mdbtools]
> > Description          = MSAccess Driver
> > Driver               = /usr/lib/libmdbodbc.so.0
> > Driver64             =
> > Setup                = /usr/lib/libmdbodbc.so.0
> > Setup64              =
> > UsageCount           = 1
> >
> > and my odbc.ini entry;
> > $ cat /etc/odbc.ini
> > [Northwind]
> > Description          = Northwind Sample Database
> > Driver               = /usr/lib/libmdbodbc.so.0
> > Database             = /home/gg/Documents/MyDocuments/Nwind.mdb
>
>
> Hello, thanks for posting back.
> I am not interested in ODBC connections.
> Since the site  http://www.libreoffice.org/features/base/   declares
> that Base
> "... provides native-support drivers for some of the most-widely
> employed multi-user database engines: MySQL, Adabas D, MS Access..."
> I expect to have a direct connection as "MDB viewer" has.
> In my /usr/lib/ folder I do not have any libmbdodbc file 
> > rs@rs-XPS-U:~$ ls /usr/lib/libmdb*
> >                /usr/lib/libmdb.so.1      /usr/lib/libmdbsql.so.1
> >                /usr/lib/libmdb.so.1.0.0  /usr/lib/libmdbsql.so.1.0.0
> I downloaded Nwind.mdb form 
> http://download.microsoft.com/download/access97/Nwind/97/WIN98/EN-US/Nwind.exe
> and, using "MDB viewer" [GMONE MDB 0.5.99.0.6pre1.0.20051109-7ubuntu1
> (mdbtools-gmdb)]  I can see the data in the tables, see the list of
> other objects (views, forms, reports, and macros) export the schema and
> the tables.
>
> I would expect to have at least as much fom Base or is ti not possible?
> Many thanks again, roberto

It's possible in the Windows 3.3.3 Final version. Doesn't work in the
Windows 3.4.2 version. I tested both in WinXP on separate virtual
machines & both have options to connect to MS Access & MS Access 2007.
The 3.3.3 install
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1
connects & shows the tables to the nwind.mdb. The 3.4.2 (Final)
gives an SQL error:

A connection for the following URL was requested
"sdbc:ado:access:PROVIDER=Microsoft.Jet.
OLEDB.4.0;DATA
SOURCE=C:\tempdir\Nwind.mdb".

Just to be sure, I'm unstalling 3.4.2 & reinstalling 3.3.3 on that
virtual machine to test in the same environment.

As for linux... I'm afraid we're stuck with trying odbc. Note:
libmbdodbc is a individual package (sudo apt-get install libmbdodbc).



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