topic Re: Abap program to MSSQL connection in Application Development and Automation Discussions

Abap program to MSSQL connection

Former Member — Mon, 03 Apr 2006 09:15:13 GMT

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 ??

Jacek

Re: Abap program to MSSQL connection

Former Member — Mon, 03 Apr 2006 09:20:31 GMT

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.

Re: Abap program to MSSQL connection

Former Member — Mon, 03 Apr 2006 10:36:09 GMT

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

Re: Abap program to MSSQL connection

Former Member — Mon, 03 Apr 2006 10:40:19 GMT

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.

Re: Abap program to MSSQL connection

Former Member — Wed, 26 Apr 2006 14:00:45 GMT

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.

Re: Abap program to MSSQL connection

Former Member — Thu, 27 Apr 2006 06:47:19 GMT

Hi Pieter !!

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

Thanx for your reply.

BR, Jacek

Re: Abap program to MSSQL connection

Former Member — Wed, 04 Mar 2009 16:42:54 GMT

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