DBCO Connection

[Former Member]

Hi All,

Can any one help me hoe to create DBCO connection in SAP.

Thanks

kanishka

[Former Member]

hi kanishka,

Maintaining Database Connection Information

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

To call DB connection maintenance, choose Administration ® CCMS ® DB administration ® DB connections. Alternatively, use Transaction 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

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 Details.

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.

thanks

karthik