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

On Tue, 20 Jan 2015, Andreas Säger wrote:

> Your tables, relations, indices and data are still in the SQLite.db file
> and handled by the ODBC driver. The so called Base document is just a
> configuration file with optional queries, forms and reports. It is bridge
> between SQLite and office documents. With a registered database you can
> use database data in arbitrary office documents for mail merge, label
> printing, bibliographies and as a data source of calculation models.
>
> In Calc or Writer hit F4 and you see the registered databases. With
> unregistered databases you can only use the forms and reports that are
> embedded in that "database document".

Andreas,

  Thank you for the explanation.

  The issue needing to be resolved is why Base cannot connect to the SQLite
.db through the .odb file even though it sees it. Both uxixODBC and
sqlite3odbc _seem_ to be correctly configured, something needs to be
tweaked.

  One of the unixODBC developers has been helping; perhaps tomorrow (in my
timezone) it will finally be resolved.

Regards,

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