Having built and installed unixODBC and sqlite3odbc I want to open a
sqlite3 database (*.db) within Base.
From the menu item File -> New -> Database I chose to connect to an
existing database. When I select ODBC for the connector, the desired .db
file is recognized and selected. No need for user authentication so I skip
Step 4 is 'Save and Proceed' which is where my choices do not produce the
result I expect.
The top portion of the dialog box has 2 radio buttons: do I want to
register the database with Base? I assume so, but the help button moves the
open firefox to that virtual desktop and presents a page with no
information. What are the effects of registering and not registering the
database with Base?
The bottom portion of the dialog box has 2 check boxes, one to open the
database for editing, the other to create tables. Only the first one is
Than, when I clicked the 'Finish' button I get a LO save dialog with the
default name of 'New Database' (with a space that needs to be removed, no
less!). If I give it a name, does the new *.odb contain the schema and data
of the existing sqlite3 .db? I apparently cannot use File -> Open on the .db
file; it produces a Write page with hash symbols on it.
To summarize: please tell me how to connect to the existing sqlite3 .db
file and then how to access it in the future to work with it.
To unsubscribe e-mail to: email@example.com
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] Base: Connecting to SQLite3 .db and Working With it · Rich Shepard
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy