Maintaining Database Connection Information
Use
Use DB connection maintenance to maintain the R/3 table DBCON. This table contains information about additional non-standard database connections (such as database system, password, and so on).
Procedure
To call DB connection maintenance, choose Tools ® CCMS
® DB administration
® DB connection maintenance. Alternatively, use Transaction
DBCO
.A table for DB connection maintenance appears. The table includes the following columns:
Logical name of database connection
Database system
Database user
Password to create the connection to the database
Database system-dependent information about the database connection.
Displaying Details about the Database Connection
Select the entry
Choose
Details
Adding New Information to Database Connections
To switch to change mode, choose
Table view
®
Display -> Change
Choose
New entries
Alternatively, choose
Copy as...
to use an existing data connection as a template
In the
Connection name
field, enter a name you choose for the logical database connection
In the
DBMS
field enter the code for the database system (for example,
ORA for Oracle)
In the
User name
field enter the name of the database user
In the
DB Password
field enter the password twice
In the
Conn.info
field enter the database-dependent information for the database connection
In the
Reconnect type
field enter the type of availability for an open database connection
Choose
Save
Maintaining Existing Database Connection Information
To switch to change mode, choose
Table view
®
Display -> Change
Select the entry
Choose
Detail
s
Change the existing information
In the
DB Password
field enter the password twice
Choose
Save
Deleting Existing Database Connection Information
To switch to change mode, choose
Table view
®
Display -> Change
Select the entry
Choose
Delete