As both Apache OpenOffice and LibreOffice are built with threads, make sure that you specify the thread-safe OOB client driver ('OOB_r'), if you are using the OOB. When testing Easysoft ODBC drivers with Apache OpenOffice and LibreOffice we used both the unixODBC Driver Manager included with the operating system and the Easysoft ODBC driver distribution. Example of Connecting to an ODBC Data Source from Apache OpenOffice, LibreOffice and 1.0+ on RedHat 8.0 (which includes unixODBC 2.2.2), Ubuntu (Edgy Eft, Feisty Fawn, Gutsy Gibbon and Hardy Heron) and Debian.Įasysoft ODBC drivers should work with any recent Linux distribution.2.0+ on RedHat 9.0 (which includes unixODBC 2.2.3).OpenOffice 3.0+ and LibreOffice 3.0+ on Ubuntu (Precise Pangolin, which includes unixODBC 2.2.14).Apache OpenOffice, LibreOffice, and LinuxĮasysoft ODBC drivers have been tested with: You can access databases such as Microsoft SQL Server, Microsoft Access, Oracle®,, DB2, Derby, InterBase and Sybase ASE from Base and Calc even when the database is on a different machine to the one where these applications are being run.

This article describes how to use OpenOffice / LibreOffice / applications (Base databases and Calc spreadsheets) to access ODBC databases for which an ODBC driver is available. LibreOffice was initially derived from the source code. The Apache OpenOffice productivity suite was previously known as Oracle® Open Office and. You can use the ODBC-ODBC Bridge to access any remote ODBC database. Access other ODBC Databases from OpenOffice / LibreOffice To access Sybase ASE from OpenOffice / LibreOffice running on Solaris, HP-UX or Linux, use the Sybase ODBC Driver. Access Sybase from OpenOffice / LibreOffice To access DB2 from OpenOffice / LibreOffice, use the DB2 ODBC Driver. To access from OpenOffice / LibreOffice, use the ODBC Driver. To access Oracle® from OpenOffice / LibreOffice, use the Oracle® ODBC Driver. Access Oracle® from OpenOffice / LibreOffice Use our drivers to connect OpenOffice / LibreOffice to SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019 and SQL Server Express. To access MS SQL Server from OpenOffice / LibreOffice running on Unix or Linux, use the SQL Server ODBC Driver or ODBC-ODBC Bridge (OOB). Access MS SQL Server from OpenOffice / LibreOffice

Libreoffice vs openoffice apache