Skip to Content
author's profile photo Former Member
Former Member

IBM Iseries DB2 Connection to Microsoft SQL Server


I'm working with my Basis team. I'm working on a project that requires data transfer between two systems. SAP and a table in the SQL database. I thought that we could just set up an ODBC connection and be able to read/write to the database from SAP via ABAP.

I've been told the Iseries does not play well with other systems. It is not possilbe to create an ODBC connection to the SQL server.

The error message during transaction DBCO is "Couldn't load Libarary 'usr/SAP/system/sys/exe/run/dmssslib.o".

Some research was done to try to fix the problem. The details as per my wonderfull awesomee Baisis guy,I like to keep on their good side, are at the end of the post. It sounds like he has looked into everything. I'm just hoping there is someone who has done this before.

Thank you!


additional research and found this information in SAP Note 178949:

u2022 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

u2022 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 (the iSeries would fall in this category)

And in SAP Note 323151:

u2022 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. In this case, contact your SAP consultant.

Additionally, this was a recent post in the iSeries forum on SDN:

> Is there something I can install on the Iseries that from ABAP you can

> write directly to a table on a remote SQL server database?

Nope, there's nothing you can install.

To connect to a MS SQL Server via DBCON you need to have an application server running on Windows.


Lars (Breddemann, from SAP, who has 2065 forum posts since September 2005)

Another document I checked was the IBM whitepaper Heterogeneous Data Access for i5/OS Applications. My interpretation of that whitepaper is that remote database access from the iSeries is only possible using a JDBC driver (from Java applications) or by installing a separate product, the WebSphere Federation Server, on a Windows server in our landscape.

Finally, I did find this document,, that says SEQUEL can connect to MS SQL Server using a JDBC driver. I donu2019t immediately know how weu2019d set up an SAP system to pull data from SEQUEL. "

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2010 at 02:56 PM

    We changed it to push the information out of SAP

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 28, 2016 at 11:45 AM

    Hi Michelle,

    We have the same issue, we had to connect to external SQL server from App Server ABAP running on OS 400. Can you tell me if you could get any solution for this?


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.