ODBC Connection

From LibreOffice Help
Jump to: navigation, search

Specifies the settings for ODBC databases.

To edit or add records to a database table in LibreOffice, the table must have a unique index field.

On Solaris and Linux platforms, try to use a JDBC driver instead of an ODBC driver. See http://www.unixodbc.org for an ODBC implementation on Solaris or Linux.

To connect to a Microsoft Access database on Windows, use the ADO or Access database interface, rather than ODBC.

Note.png Drivers for ODBC are supplied and supported by the manufacturer of the database. LibreOffice only supports the ODBC 3 standard.

Name of the ODBC database

Enter the path to the database file.


Click to open an ODBC data source selection dialog:

Choose a data source

Select a data source to which you want to connect using ODBC. Then click OK.


Database Wizard