<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Base ODBC connection for Sqlite Inadequately Documented for Windows" href="https://bugs.documentfoundation.org/show_bug.cgi?id=144588#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Base ODBC connection for Sqlite Inadequately Documented for Windows" href="https://bugs.documentfoundation.org/show_bug.cgi?id=144588">bug 144588</a> from <a class="email" href="mailto:flywire0@gmail.com" title="flywire <flywire0@gmail.com>"> flywire</a> <pre>(In reply to flywire from <a href="show_bug.cgi?id=144588#c2">comment #2</a>) > 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: <a href="https://www.andrewheiss.com/blog/2016/02/10/libreoffice-base-sqlite-odbc-osx/">https://www.andrewheiss.com/blog/2016/02/10/libreoffice-base-sqlite-odbc-osx/</a> (In reply to Alex Thurgood from <a href="show_bug.cgi?id=144588#c3">comment #3</a>) > The sqliteodbc of the URL should be in lower case. Install ODBC driver Install ODBC driver from <a href="http://ch-werner.de/sqliteodbc/">http://ch-werner.de/sqliteodbc/</a> eg for Windows, install <a href="http://ch-werner.de/sqliteodbc/sqliteodbc_w64.exe">http://ch-werner.de/sqliteodbc/sqliteodbc_w64.exe</a> 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: <a href="https://www.sqlitetutorial.net/wp-content/uploads/2018/03/chinook.zip">https://www.sqlitetutorial.net/wp-content/uploads/2018/03/chinook.zip</a> Tests it's ok at <a href="https://inloop.github.io/sqlite-viewer/">https://inloop.github.io/sqlite-viewer/</a></pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>