topic Re: DBCO and SQL Server 2000... in Application Development and Automation Discussions

DBCO and SQL Server 2000...

Former Member — Tue, 22 Aug 2006 06:25:10 GMT

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

Re: DBCO and SQL Server 2000...

Former Member — Tue, 22 Aug 2006 13:29:37 GMT

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

Re: DBCO and SQL Server 2000...

Former Member — Tue, 22 Aug 2006 14:22:54 GMT

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