User`s guide

Connecting to a Database
2-191
Connecting to a Database
To connect to your database, your ODBC or JDBC driver must be installed and your data
source must be defined. For details about driver installation and data source setup, see
“Configuring a Driver and Data Source” on page 2-13.
In this section...
“Connection Options” on page 2-191
“Microsoft Access” on page 2-191
“Microsoft SQL Server” on page 2-191
“Oracle” on page 2-192
“MySQL” on page 2-192
“PostgreSQL” on page 2-192
“SQLite” on page 2-193
“Sybase” on page 2-193
“Other ODBC- or JDBC-Compliant Databases” on page 2-193
Connection Options
You can connect to your database using Database Explorer or the command line. You can
perform different actions using Database Explorer than you can using the command line.
For details about deciding which option to use, see “Connection Options” on page 2-6.
Microsoft Access
• ODBC
• “Connect to Microsoft Access using Database Explorer.” on page 2-19
• “Connect to Microsoft Access using the native ODBC connection command line.” on
page 2-21
Microsoft SQL Server
• ODBC
• “Connect to Microsoft SQL Server using Database Explorer.” on page 2-29