Il giorno sab, 06/08/2011 alle 10.25 -0700, NoOp ha scritto: > On 08/06/2011 04:31 AM, Andreas Säger wrote: > >> > >> 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. > > > > > Since many years I have never read some write-up where somebody managed > > to access mdb under Linux nor Mac. > > There used to be a read-only driver from an open source project back in > > 2005/06. After many months of hard work they gave up further development > > when their write access revealed some tendency to destroy the connected > > database. Read-only would be just fine for most people, but I can not > > even find that version anymore. > > The Windows drivers are made by Microsoft. Even if they could compile > > the same thing for Linux easily, they would never do so. > > I use to recommend the excellent tools provided by MS Access to export > > data, query definitions, doc reports, macros and all sorts of meta > > information. > > The mdb tools are good enough to export usable CSV. Then you can copy > > tables from a CSV connected Base document into a database connected Base > > document. Like always, mind the locale setting in respect to the decimal > > separator and date formats used in the csv. > > Greetings, > > Andreas > > > > > > 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 -- 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
