Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Connection with SQL SERVER (extenal sap) - DBCO

Former Member

‎2008 Apr 29 8:35 AM

0 Likes
2,852

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.

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.

Reply
3 REPLIES 3
Read only

pole_li
Active Participant

‎2008 Apr 29 10:02 AM

0 Likes
1,086

Hi,

What database do you have of your sap system?

Regards,

Pole

Read only

Former Member
In response to pole_li

‎2008 Apr 29 10:56 AM

0 Likes
1,086

Sorry,

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

Thanks.

Read only

JanStallkamp
Advisor
Advisor

‎2008 May 30 3:02 PM

0 Likes
1,086

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-c322fedd...

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