on 01-04-2010 5:14 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
72 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.