Re: [libreoffice-users] Re: looking for help on Base
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: 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
Re: [libreoffice-users] Re: looking for help on Base
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 > > 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 -- 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
Re: [libreoffice-users] looking for help on Base
Hello Don. I have already succeded in runnin Access in some MS-widows emulation. I can also wiew and (to some extent) export info from MDB files trough "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 I need now is what is claimed on the LibreOffice-Base http://www.libreoffice.org/features/base/ which states that it "... provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access..." Many thanks, rs Nuoro Forestry School Università di Sassari http://nuoro-forestry-school.blogspot.com/ Il giorno gio, 04/08/2011 alle 10.14 -0400, Don C. Myers ha scritto: > Hi Roberto, > > Access will not run natively in Linux. I run Ubuntu 11.04 presently. I > was a windows user when I switched to Base. One reason for switching was > I knew someday I wanted to migrate to Linux. It was very easy since > OpenOffice worked in both platforms. I run Quicken and Dreamweaver > through Wine on Ubuntu. You may need to move up to Crossover Office, but > it would be likely some version of Access would work. I have not > researched this though. In general, some versions of Microsoft Office do > work with Crossover Office. > > Don > > On 08/04/2011 10:04 AM, Roberto Scotti wrote: > > Yes, it may be. I am working on Ububntu based systems. > > Is it possible to install MS-Access and/or SQLite native-drivers in > > Linux? > > Many thanks, Roberto Scotti > > > > PS - I added your address in CC to be shure you would get the message, > > if thi causes doubling your messages please let me know. > > > > Il giorno gio, 04/08/2011 alle 10.26 +0200, Cor Nouws ha scritto: > >> Hi Roberto, > >> > >> Roberto Scotti wrote (04-08-11 10:19) > >> > >>> 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: > >>> ... > >> That connection is Windows only. > >> Does this explain what you see on your computer? > >> > >> Regards, > >> > >> > >> -- > >>- Cor > >>- http://nl.libreoffice.org > >> > >> > > > > -- > > *~~* > Don C. Myers > e-PRO Certified by the National Association of Realtors > Manager, Farm and Rural Property Division > *Coldwell Banker University Realty > *126 East Foster Avenue, State College, PA 16801 > Office Phone: 814-237-6543 Fax: 814-237-6502 > Home Phone: 814-422-8111 Cell Phone: 814-571-9518 > Visit the Farm and Rural Property Division Web Site at > _www.cbur-ruralproperty.com <http://www.cbur-ruralproperty.com/> > _View Don's Farm Web Site at www.myersfarm.com <http://www.myersfarm.com/> > *~~* > > -- 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
Re: [libreoffice-users] looking for help on Base
Yes, it may be. I am working on Ububntu based systems. Is it possible to install MS-Access and/or SQLite native-drivers in Linux? Many thanks, Roberto Scotti PS - I added your address in CC to be shure you would get the message, if thi causes doubling your messages please let me know. Il giorno gio, 04/08/2011 alle 10.26 +0200, Cor Nouws ha scritto: > Hi Roberto, > > Roberto Scotti wrote (04-08-11 10:19) > > > 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: > > ... > > That connection is Windows only. > Does this explain what you see on your computer? > > Regards, > > > -- > - Cor > - http://nl.libreoffice.org > > -- 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
[libreoffice-users] looking for help on Base
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 -- 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