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

Accessing MsSQL Database from ABAP

Former Member

‎2010 Feb 27 6:35 PM

0 Likes
517

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

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

Reply
2 REPLIES 2
Read only

StMou
Active Participant

‎2010 Feb 27 10:18 PM

0 Likes
474

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

Read only

Former Member
In response to StMou

‎2010 Mar 02 5:38 PM

0 Likes
474

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 ?