on 08-01-2012 8:09 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.