[Libreoffice-bugs] [Bug 144588] New: Base ODBC connection for Sqlite Inadequately Documented for Windows

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144588

            Bug ID: 144588
           Summary: Base ODBC connection for Sqlite Inadequately
                    Documented for Windows
           Product: LibreOffice
           Version: 7.2.1.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: flywire0 at gmail.com
                CC: olivier.hallot at libreoffice.org

Comments relate to BG64-BaseGuide.pdf

> Accessing external databases

> MySQL connection via ODBC
> To connect via ODBC, you must of course have ODBC software installed.
> Details of how to do this are not given here.

This is totally unintelligible for ODBC, especially Windows. Maybe present the
four steps briefly first before explaining details for various options for the
different drivers.

*** A separate section is needed for ODBC, including how to get drivers -
http://ch-werner.de/sqliteodbc/ Sqlite would be a good example to save
confusion with MySQL. See
https://ask.libreoffice.org/t/connecting-base-to-sqlite-in-windows/68168/12 

The type of info required and a sample database is covered in
https://www.sqlitetutorial.net/


> Query enhancement using SQL Mode

*** This doesn't explain how say sqlite works with Base. A sqlite example would
be good and relatively easy to set up.


Version: 7.2.0.3 (x64) / LibreOffice Community
Build ID: 2a7ea282da28d665a7dc086360567b4aea27bf08
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: threaded


I'd welcome the opportunity to review changes to the docs.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210918/46df0af4/attachment.htm>