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
Showing results for 
Search instead for 
Did you mean: 
Read only

DBCO and SQL Server 2000...

Former Member
0 Likes
556

Hi all,

How to configure the SQL server connection in DBCO transaction. SQL Server is not residing in the same machine. The R/3 version is ECC 5.0 in <b>IBM AIX environment</b>.

Regards

Vasu

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
492

Hi Vasu. I'm currently making some test on this, connecting to a SQL Server Database with our SAP ECC 5.0 system on an AIX architecture.

The only way i've found, so far, is to make use of RFC enabled functions, on this RFC we use the EXEC SQL CONNECT statement, the thing is that this RFC should run on an app server that HAS to be on WINDOWS.

You may wanna check note 178949.

Hope it Helps.

Jesus

2 REPLIES 2
Read only

Former Member
0 Likes
493

Hi Vasu. I'm currently making some test on this, connecting to a SQL Server Database with our SAP ECC 5.0 system on an AIX architecture.

The only way i've found, so far, is to make use of RFC enabled functions, on this RFC we use the EXEC SQL CONNECT statement, the thing is that this RFC should run on an app server that HAS to be on WINDOWS.

You may wanna check note 178949.

Hope it Helps.

Jesus

Read only

0 Likes
492

Hi Jesus,

Thanks for your suggestion.We dont have any application server that is running on WINDOWS. We are exploring option of exposing SQL Server data as web service and invoking the web service from ABAP.Please let me know if you find any solution for this scenario.

Regards

Vasu