Skip to Content
avatar image
Former Member

Abap program to MSSQL connection

Hello !!

Do anybody knows how to retrive data directly from MSSQL server to abap program ,normaly it should by done by defining DBCO connection and using Native SQL statments but our SAP system is running on UNIX and what I have found for know in sap notes is that connection to MSSQL can only be defined in DBCO transaction if SAP is working on Windows platform. Are there any other solutins to set that conection in situation like mine ??

BR

Jacek

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 03, 2006 at 10:36 AM

    Hello Amit.

    I have created connectoin in DBCO.

    After running small abap that tries to connect to my MSSQL

    in SM21 i have error message.

    "No shared library found for the database with ID SQL."

    I have found that the solution of that is to install dbmssslib.dll file but it can't be installed on unix/aix sytem.

    So i'am stiil unable to connect MSSQL from our AIX paltform based SAP system.

    BR, Jacek

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jacek

      Could you explain what is a Business connector?

      I'm Facing the same problem I want to conenct from an ABAP Program to MSS but our server is on AIX.

      Tnks in Advance

  • avatar image
    Former Member
    Apr 03, 2006 at 09:20 AM

    Hi jacek,

    1. its not so.

    2. SAP may run on any platform, unix, windows , aix etc,

    3. using DBCON

    we can make connection (secondary database connection)

    to any database

    (which sap supports)

    4. Take help of your basis team,

    they will help u.

    regards,

    amit m.

    Add comment
    10|10000 characters needed characters exceeded