topic Connection to MS SQL Server from SAP system based on Linux OS in Application Development and Automation Discussions

Connection to MS SQL Server from SAP system based on Linux OS

Former Member — Thu, 25 Feb 2010 15:45:55 GMT

Dear Gurus,

I have to connect to a remote MS SQL Server from my SAP system based on Linux Operating System.

I have installed JDBC drivers on the MS SQL Server as Linux based SAP doesnot connect to MS SQL Server directly.

But I donot know how to connect using ABAP.

I understand that if my SAP OS was Windows , this would have been simple but my case is different

as it is Linux . I donot know how to leverage the drivers in this case.

Kindly help .

Regards,

Shweta.

Former Member — Thu, 25 Feb 2010 16:08:07 GMT

I did something like that some years ago.

I think taht you can execute your SELECT statements only using OPEN FETCH and CLOSE statements.

If the problem is the access to the DB, I remember a table (but not it's name) where every DB must be listed with relative driver.

Sorry about the tablke name but I really do not remember.

Hope to be helpfully anyway.