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: [email protected] 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
