topic Re: Connection with SQL SERVER (extenal sap) - DBCO in Application Development and Automation Discussions

Connection with SQL SERVER (extenal sap) - DBCO

Former Member — Tue, 29 Apr 2008 07:35:14 GMT

Hello,

I try connect external database to sap.

For it, i found the transaction DBCO. I configured this and don't connect.

In transaction "ST04" response with:

"-- ERROR ADBC database error (16) occurred"

With code response that db isn't online:

exec sql.

set connection: 'dbsql'

endexec.

I realized a ping (in sap machine) and i have response.

We have ASP aplications with equal configuration and execute ok.

What can it be happening?

Thanks.

Re: Connection with SQL SERVER (extenal sap) - DBCO

pole_li — Tue, 29 Apr 2008 09:02:45 GMT

Hi,

What database do you have of your sap system?

Regards,

Pole

Re: Connection with SQL SERVER (extenal sap) - DBCO

Former Member — Tue, 29 Apr 2008 09:56:37 GMT

Sorry,

I like connect a "SQL SERVER" database (extenal to sap, ej: http://....) with a application/bsp/bapi... of sap.

Thanks.

Re: Connection with SQL SERVER (extenal sap) - DBCO

JanStallkamp — Fri, 30 May 2008 14:02:15 GMT

Hi Benito.

I'm not very familiar with MSS but maybe the following will help a little bit.

Depending on the version of your SAP system you can use the transaction DBACOCKPIT to add connections to non-SAP databases. There is an test connection button in that transaction, too. You will find some information about that transaction in some whitepapers here in the SDN. For example have a look at this one: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/1062428c-f1df-2910-b08f-c322feddcd10

ADBC error 16 is just "something went wrong". Is your SAP system using MSS, too? If not you will need the matching DBSL for it on your SAP system.

If you have set up an connection you can use program ADBC_TEST_CONNECTION to check if everything is ok. If I remember it correctly in case of errors it allows you to jump into the trace file. There you should find some usefull information.

Perhaps asking in the Database&OS forum area (there is a MSS forum) might help, too.

Best regards,

Jan