topic Re: ERROR When coonecting to SQL via DBCO Connections in Application Development and Automation Discussions

ERROR When coonecting to SQL via DBCO Connections

Former Member — Tue, 21 Feb 2012 11:49:33 GMT

Hi,

Error when connecting to SQL using DBCO connections. I am getting an dump as "Set up of a secondary connection to the database system failed. It is possible that the data required for setting up the connection via EXEC SQL (Native SQL)is faulty."

plaese help.

Thanks

Re: ERROR When coonecting to SQL via DBCO Connections

Former Member — Tue, 21 Feb 2012 12:23:31 GMT

Hi Ravi,

Create the respective DBCO entry for the external database.

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

Regards

Raj

Edited by: Rajasekhar Dinavahi on Feb 21, 2012 5:53 PM

Re: ERROR When coonecting to SQL via DBCO Connections

Former Member — Tue, 21 Feb 2012 13:34:52 GMT

Hi Raj,

Thanks for the valuable reply..if I run the ADBC_TEST_CONNECTION and get an DBI error 16 how can I rectify it?

Re: ERROR When coonecting to SQL via DBCO Connections

Former Member — Mon, 27 Feb 2012 12:39:53 GMT

Checking the dbsl_w<NN> as it is explained in point 3 of the 'Troubleshooting' section of [SAP Note 738371|https://service.sap.com/sap/support/notes/738371] would help a lot to know the reason of the failure.

It is most likely that, the information provided in DBCO are not complete/accurate

Regards

Raj

Re: ERROR When coonecting to SQL via DBCO Connections

Former Member — Mon, 27 May 2013 10:44:05 GMT

Hi ,

I am facing the same problem .

When I run it manually , no problem . In background schedule sometimes this error is comming,

Tested the standard program as well ADBC_TEST_CONNECTION, Connection is OK.

This problem coming every after 4/5 days,

Any idea? please guide me.

Re: ERROR When coonecting to SQL via DBCO Connections

Former Member — Mon, 27 May 2013 11:09:11 GMT

Giving

SQLERR_REF->INTERNAL_ERROR is equal to 16.

what is this error?