Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

ODBC Connection

Specifies the settings for ODBC databases.

To edit or add records to a database table in Office, 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.

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

Name of the ODBC database

Enter the path to the database file.

Browse

Click to open an ODBC data source selection dialogue box:

Choose a data source

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

Authentication

Database Wizard