Connect from SAP(UNIX) with MS SQL(Windows)

[Former Member]

Greetings,

There is SAP in UNIX. I need to connect with MS SQL SERVER 2005 from

SAP. But when I try to debug this code:

REPORT Z_DBCO_TEST.

EXEC SQL.

CONNECT TO 'TESTDBCO'

ENDEXEC.

EXEC SQL.

SET CONNECTION 'TESTDBCO'

ENDEXEC.

I get mistake:

u201CError setting up a secondary database connectionu201D.

TESTDBCO connection attributes:

DBS: MSS

Connection information: u201CMSSQL_SERVER=myserver.ds.local

MSSQL_DBNAME=testbaseu201D

Login and password are correct.

I know, that there are COM and warehouse use to connect with MS SERVER,

but I canu2019t use it in my task

Please, help me. May be, it isnu2019t correct u201CConnection informationu201C? Can

SAP(UNIX) connect with MS SERVER without COM?

I found note 323151. It contains following:

u201CHowever, if you want to set up a connection to a database that does

not correspond to the DB platform of the R/3 database, you must also

install a DB-platform-specific DLL that can be used to route accesses

to this database from R/3. These DLLs are not part of a standard R/3

installation.u201D

Is SAP(UNIX) -> MS SQL(Windpows) connection part of a standart R/3

installation? Where can I find this DLL (or may be .o or .so files for

UNIX)? How can I install it?

Best regards, Pavel.

[former_member524429]

Hi,

As per this SAP Note 178949 - MSSQL: Database MultiConnect with EXEC SQL,

It's desired to make a connection to a SQL Server database running on a server different from the R/3 server.

Prerequisite: At least one Windows application server must be available on the R/3 system and the DBSL dynamic library (DLL) dbmssslib.dll must be installed on this server. 
This dll can be downloaded from the SAP Service Marketplace where it is listed as lib_dbsl in the MS SQL SERVER section for the platform.  
The dbmssslib.dll already exists on application servers which are installed for the SQL Server database platform.  
For Windows application servers which are using other database platforms, dbmssslib.dll must be installed in the ABAP kernel executable directory (directory parameter DIR_EXECUTABLE).

NOTE: Currently this DBSL library is only available for the Microsoft Windows Operating System.  
UNIX application servers cannot be used to connect to a remote MS SQL Server.

Regards,

Bhavik G. Shroff

[Former Member]

Bhavik G. Shroff

Thank you.

[Former Member]

Hi,

As UNIX machine can not connect with the MS SQL server. For this you have to install a new application server for that R3 system in a windows machine and then download the BSL dynamic library (DLL) dbmssslib.dll and copy it in the kernel directory.

Now log in to that application server and then try to create the connection to MS SQL server. This should work

Thanks,

Chaitanya.

[Former Member]

Hi Paul,

I have a similar configuration (R/3 on Linux).

In order to access to an external MSSQL Server I installed a Windows Application Server.

As you can see from the following note, itu2019s a supported configuration:

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

After that, you have to download the last MSSQL library (lib_dbsl) and install it into your new Windows Application Server.

The next step will be the DBCON table configuration (itu2019s a very simple task) and after that you will be able to communicate with your external MSSQL Server through the Windows Application Server.

And here is the DBCON online documentation:

http://help.sap.com/saphelp_nw04/helpdata/EN/df/455ec9747111d6b25100508b6b8a93/content.htm

Let me know if you need help.

Thanks,

Federico Biavati

[Former Member]

Federico Biavati

Thank you.

As I understand u2013 I need to create new server with second SAP system in new machine, and connect to SAP(UNIX) with RFC. Do I have another way without second SAP system installation? Or is it one way to connect with SQL SERVER?