DBCO: Database Connection Overview

Use

Use DB connection maintenance to maintain the SAP table DBCON. This table contains information about additional non-standard database connections (such as database system, password, and so on).

Procedure

Use Transaction code DBCO. A table for DB connection maintenance appears. The table includes the following columns:

• Name of connection
Logical name of database connection

• DBS
Database system

• Database user name
Database user

• Database password
Password to create the connection to the database

• Connection information
Database system-dependent information about the database connection.

Displaying Details about the Database Connection

1. Select the entry and choose Details.

Adding New Information to Database Connections

1. To switch to change mode, choose Table view > Display > Change.
2. Choose New entries.
3. In the Connection name field, enter a name you choose for the logical database connection
4. In the DBMS field enter the code for the database system (for example, ORA for Oracle)
5. In the User name field enter the name of the database user
6. In the DB Password field enter the password twice
7. In the Conn.info field enter the database-dependent information for the database connection
8. In the Reconnect type field enter the type of availability for an open database connection and choose Save

Maintaining Existing Database Connection Information

1. To switch to change mode, choose Table view > Display > Change.
2. Select the entry
3. Choose Details.
4. Change the existing information
5. In the DB Password field enter the password twice
6. Choose Save.

Deleting Existing Database Connection Information

1. To switch to change mode, choose Table view > Display > Change.
2. Select the entry and choose Delete.

You May Also Like

Leave a Reply?