Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

  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
that step.

  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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.