cancel
Showing results for 
Search instead for 
Did you mean: 

connection with ms sql

0 Kudos

I need to connect an external MS SQL db from SAP and write data into this server.

In my case sap r/3 is on unix system.

How I can solve this problem?

Thanks in advance

Sabrina

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

First of all you should setup a new database connection in SAP via transaction DBCO to the external DB.

Afterwards you can use native SQL statements in ABAP to write data to the external DB.

Also consult the online help of transaction DBCO for more help.

[http://help.sap.com/saphelp_nw04/helpdata/EN/df/455ec9747111d6b25100508b6b8a93/content.htm|http://help.sap.com/saphelp_nw04/helpdata/EN/df/455ec9747111d6b25100508b6b8a93/content.htm]

Success.

Wim Van den Wyngaert

0 Kudos

Hello,

thanks for your promptly information.

I read on oss that I can use DBCO only if sap is on windows system....

unfortunately my sap is on unix...

Sabrina

Former Member
0 Kudos

Hello,

That's strange, all our SAP systems run on UNIX/Oracle, we use DBCO for several years now without any problems.

We connect to different Oracle and MS SQL Server databases running on WIndows and Unix.

You can check following SAP Notes and related notes:

[https://service.sap.com/sap/support/notes/323151|https://service.sap.com/sap/support/notes/323151]

[https://service.sap.com/sap/support/notes/738371|https://service.sap.com/sap/support/notes/738371]

Wim

Former Member
0 Kudos

Hi Sabrina,

I have a similar configuration (R/3 on Linux/Oracle).

In order to access to an external MSSQL Server I installed a Windows Application Server.

As you can see from the following note, itu2019s a supported configuration:

Note 680617 - INST Appl.Server in Heterogeneous SAP System Environment

After that, you have to download the last MSSQL library (lib_dbsl) and install it into your new Windows Application Server.

The next step will be the DBCON table configuration (itu2019s a very simple task) and after that you will be able to communicate with your external MSSQL Server through the Windows Application Server.

Let me know if you need help.

Thanks,

Federico Biavati

0 Kudos

I WIm,

the note 738371 indicates that 'The application server(s) where a DBCON connection is used must be running Windows'..As consegqunece I think that with my R/3 on unix i can't use this solution....

Bye

former_member204746
Active Contributor
0 Kudos

only solution:

install a Windows application server on and connect it to your Central instance running on Unix.

Answers (0)