Skip to Content
avatar image
Former Member

connection to mssql 2008 from sap on unix (solaris 10)

good morning all,

i want to make sure i am reading this right, but i do not think i can connect to a mssql server (2008) from sap if sap is using unix.

1601608 - How to access an external Microsoft SQL Server database

Remark:
If your system comprises solely of ABAP stack-based servers running on Unix / Linux platforms you can neither use UDConnect nor DBCON. Why? Because UDConnect requires at least one Java-stack based SAP Application Server (regardless of the operating system) and DBCON requires at least one Windows-based SAP Application Server.

if this is the case, how would a company connect to a sql server and extract data and use in a abap program? ftp?

any help is appreciated.

thx,

Erik

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 02, 2012 at 03:11 AM

    You are absolutely correct . If you look at the extract below from SAP note 1601608

    ********************************************************************************************************************

    DBCON / Multiconnect

    DBCON / Multiconnect uses the Microsoft SQL Server Native Client Software (SNAC) to establish a connection to the remote SQL Server instance. The Microsoft SQL Server Client Software consists of several *.dll files. It is developed and distributed by Microsoft and is therefore not available for any operating systems other than Windows. DBCON utilizes the SAP ABAP stack to access the external databases so your system requires at least one ABAP-stack-based SAP Application Server running on Windows.

    ********************************************************************************************************************

    the last line clearly state that an ABAP stack on windows is required for connecting to an external SQL server database as the MS SQL server client and the ABAP SQL server DBSL is compatible to run on windows OS only . So you cannot have these interfacing agents running on UNIX.

    In such a scenario I suggest , you install an SAP application server on Windows OSĀ  with other application server or CI running on UNIX.

    Refer the following SAP notes

    Note 1067221 - Composite SAP Note for heterogeneous installation

    Note 680617 - INST: Appl.Server in Heterogeneous SAP System Environment

    In such a scenario , whenever the applications need to connect to the MS SQL server database , it has to run on the application server on Windows OS.

    Regards

    Ratnajit

    Add comment
    10|10000 characters needed characters exceeded