test connection using dbco

[Former Member]

Dear All,

I have configured my tnsnames.ora for connection to an external Oracle DB.

I am successfully getting ping for tnsping for that db.

I've also configured my dbco.

But my below code is giving sy-subrc = 4.

EXEC SQL.

CONNECT TO 'AWL'

ENDEXEC.

Also i would like to know if there is any method to check whether my dbco entry is working ok.

Thanks in anticipation

[Former Member]

Hi,

Check if this helps.

check methods in class

CL_SQL_CONNECTION

Regards,

Amit

[Former Member]

hi

You can check if the connection is working by running report ADBC_TEST_CONNECTION.

regards

Nishant

[Former Member]

HI Nishant ,

thanks for reply ,

Regards

Kumar