You can connect DB Navigator to multiple databases. Here is an overview of how to connect DB Navigator to a database (follow the links for more information about the tasks). Obtain or create a user account for the database. You must provide a login to access a SQL database. When you try to connect to a database in DB Navigator, you are prompted for a user ID and password. For other details about the specific database you are working with, see the relevant database documentation.
Note: (For OpenEdge databases only) If no user accounts have been established, you can use the Windows login name of the person who created the database as the user ID.
1. Configure a JDBC driver for the database.DB Navigator requires a JDBC driver in order to connect to a database and supplies JDBC drivers for various database types. In most cases, the driver is installed and configured automatically during installation of DB Navigator. If, however, the JDBC driver for your database requires driver configuration, see Configuring a JDBC driver for more troubleshooting information.
2. Start the database server. You cannot connect to a standalone database. You must start a database server before connecting to the database. To start OpenEdge databases, you can use either OpenEdge Management or OpenEdge Explorer, or the OpenEdge proserve command.
Note: Since JDBC drivers execute SQL statements, you must start databases that can service SQL clients. For OpenEdge databases, ABL access is required for trigger maintenance. Therefore, create a server with a client type of Both 4GL and SQL (which is the default).
3. Open the connection. You can select and open an existing SQL connection, or you can add a new SQL connection profile and open it. Connection profiles contain connection information, which includes, among other details, the name of the driver, a URL expression, a user name, and a password.
4. When you open a connection profile for a database, the schema for the database appears in the DB Structure view.
