[libreoffice-users] Base: Connecting to SQLite3 .db and Working With it

  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
invoked.

  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.

Rich


--
To unsubscribe e-mail to: users+unsubscribe@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