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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from flywire <flywire0 at gmail.com> ---
(In reply to flywire from comment #2)
> Notes:
> 1. This Windows ODBC example needs revising to cover linux and macOS.

Process is very variable by system so only document the system you have access
to. Sample macOS Guide:
https://www.andrewheiss.com/blog/2016/02/10/libreoffice-base-sqlite-odbc-osx/

(In reply to Alex Thurgood from comment #3)
> The sqliteodbc of the URL should be in lower case.

Install ODBC driver

Install ODBC driver from http://ch-werner.de/sqliteodbc/

eg for Windows, install http://ch-werner.de/sqliteodbc/sqliteodbc_w64.exe
If you’re using 32 bit software on Win64 you should install the Win32 driver,
too.

A sample SQLite database can be downloaded and extracted for testing:
https://www.sqlitetutorial.net/wp-content/uploads/2018/03/chinook.zip
Tests it's ok at https://inloop.github.io/sqlite-viewer/

-- 
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/20210922/c7eba21f/attachment.htm>