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.
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, http://www.sequel-software.com/news/accessing-remote-databases-using-sequel, 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. "