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: [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
