User`s guide

Configure Data Sources and Connect to Databases
4-17
For details about potential errors, see “Database Connection Error Messages”.
Work with Multiple Databases
1
If you have not defined the OBDC or JDBC connection for your new data source,
click Open and select ODBC or JDBC. Complete the fields in the associated dialog
box. For details, see “Configure ODBC Data Sources” on page 4-8 or “Configure
JDBC Data Sources” on page 4-12.
2
Select Connect > Connect to select your new data source.
3
The new data source appears in a new tab in the Database Browser pane. You can
change databases by clicking the associated tab.
You can use only Database Explorer to create SQL queries for a single database at a
time.
You can work with a different catalog and schema on the same database server as the
one that connects to your current data source. To change to a different catalog and
schema:
• From the drop-down list in the address bar of the Database Browser, select the
catalog or schema. For database systems that have a hierarchy of catalogs and
schemas, ensure that you choose the correct value for catalogs and schemas to access
data in your tables.