ERROR When coonecting to SQL via DBCO Connections

[Former Member]

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

[Former Member]

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

[Former Member]

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?

[Former Member]

Hi

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

[Former Member]

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.

[Former Member]

Giving

  SQLERR_REF->INTERNAL_ERROR is equal to 16.

what is this error?