[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 #3 from Alex Thurgood <iplaw67 at tuta.io> ---
(In reply to flywire from comment #2)

> 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.
> 

Remember that the above needs to work for all platforms supported by the
LibreOffice project.

I just tried the first link and get a 404 Not Found error.
The sqliteodbc of the URL should be in lower case.

I installed the latest available driver for macOS. Note that this package is
only currently available for Intel processors. In other words, there is no ODBC
driver for Mac Silicon as of today (22/09/2021).

After having set up and configured a USER DSN pointing to an existing SQLite3
db, I try to create an ODB connection using the ODBC driver.

This fails to load because the LibreOffice app bundle as a signed application
on macOS only searches for libiodbc in /usr/lib, which is the wrong directory
(and actually forbidden for signed apps).

As a result, the setting up of and SQLite3 ODB file using ODBC with Christian
Werner's driver is currently not possible.

-- 
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/23c356ce/attachment.htm>