topic Re: Accessing MsSQL Database from ABAP in Application Development and Automation Discussions

Accessing MsSQL Database from ABAP

Former Member — Sat, 27 Feb 2010 18:35:30 GMT

Hi Guys,

I want to connect to an external MsSQL Database running in a window environment from an ABAP Report program where the SAP instance running in a Linux OS with DB2 as a Database. I tried all options suggested in all public forums like maintaining DBCON table entry & placing compatible dll files. I need answers from individuals who have done it in the recent past with this environment not beating bushes.

Thanks in advance.

Regards

Vijaya

Re: Accessing MsSQL Database from ABAP

StMou — Sat, 27 Feb 2010 22:18:40 GMT

hi,

see on oss note Question 4

Note 555223 - FAQ: Microsoft SQL Server


Q4: My SAP System runs under Oracle (DB2, SAPDB, ...) and I want to
exchange data with a non-SAP Microsoft SQL Server directly from ABAP.


Q4: My SAP System runs under Oracle (DB2, SAPDB, ...) and I want to exchange data with a non-SAP Microsoft SQL Server directly from ABAP. A4: The establishing and use of connections from an R/3 system to another non-SAP database (from the same vendor or not) is called multi-connect and is described in note 178949.

But you must have a specific application server running on Windows if you want to connect SAP to your Microsoft SQL server with DBCON.

Rgds

Edited by: stéphane mouraux on Feb 27, 2010 11:21 PM

Re: Accessing MsSQL Database from ABAP

Former Member — Tue, 02 Mar 2010 17:38:51 GMT

Thansk for your quick reply. If my all application server is running in Linux enviormenet then is it not possibel to connect to MsSQL by native SQL commands from ABAP ? I dnot want to use PI or any middle wear to connect the SQL DB. What is the other way out on this ?