Abap program to MSSQL connection

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi again,

1. since your system is aix,

i don't think .DLL files (windows files)

will work on it.

2. probably , for MSSQL,

there must be some other file,

(for other operating systems like AIX, UNIX etc).

3. If that file is installed,

then something may move further.

4. Moreover, your basis

team will have to make a CONNECTION STRING

(ie. connection from application server

to MSSQL server)

5. Once that is made, only then

we can use in abap.

regards,

amit m.

[Former Member]

1. All platforms are supported, but require at least one Windows application server AND the Shared Library available. Please check out SAP Note 178949

2. Please check out the forumthread at (Search SDN for "dbmssslib.dll" and go to thread "Download dbmssslib.dll") where Mike Eacrett points out to consider the SAP BW 3.5 UDC feature if one does not wants to install a Windows Application Server.

[Former Member]

Hi Pieter !!

We have no Windows application server, and so we decided to use Business connector.

Thanx for your reply.

BR, Jacek

[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