‎2006 Aug 22 7:25 AM
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
‎2006 Aug 22 2:29 PM
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
‎2006 Aug 22 2:29 PM
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
‎2006 Aug 22 3:22 PM
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