topic Re: test connection using dbco in Application Development and Automation Discussions

test connection using dbco

Former Member — Mon, 24 Aug 2009 09:45:48 GMT

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 — Mon, 24 Aug 2009 10:07:47 GMT

Hi,

Check if this helps.

check methods in class

CL_SQL_CONNECTION

Regards,

Amit

Former Member — Mon, 24 Aug 2009 10:30:34 GMT

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

regards

Nishant

Former Member — Sat, 29 Oct 2011 05:42:57 GMT

HI Nishant ,

thanks for reply ,

Regards

Kumar