04-18-2006 4:14 PM
Hi
Is there any way to connect to external SQL Server database and pass the sql query from ABAP to that database and get the result in SAP. My SAP system is running on UNIX platform.
Please suggest me the best possible way.
Regards
Kousik
04-18-2006 4:40 PM
Hi Kousik,
Please check this links.
http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm
Hope this will help.
Regards,
Ferry Lianto
04-18-2006 4:45 PM
04-18-2006 4:46 PM
04-18-2006 9:54 PM
Hi Kousik. To do this, you must create a data base conection in transaction DBCO. In this conection you must specify the conection string, user, password, and every other parameter depending on the DB you are going to connect to.
Then, in your ABAP program you must use the sentence:
EXEC SQL.
CONNECT dbco_name
ENDEXEC.
EXEC SQL.
NATIVE SQL QUERY, YOU MAY ALSO USE STORE PRWOCEDURES, CHECK THE HELP
ENDEXEC.
EXEC SQL.
DISCONNECT dbco_name
ENDEXEC.
I made a proram to connect to and AS/400 database and a SQL Server database and they both work just fine.
Hope it helps
Jesus
08-20-2007 11:29 AM
Hi jesus,
I need to connecgt to AS400 server. I have done dbco config but i am not able to access the data base.
Can u please suggest me native SQL statements will work there.
Thanks in advance
praveen
04-19-2006 11:13 AM
Hi
I need help on following issues :
1. What is the format of entering database connectivity details in Conn.Info in DBCON entry page ..
2. My SAP Server is running on UNIX . Will I need any extra configuration for this?
Regards
Kousik
04-19-2006 6:15 PM
Just make sure de dbmssslib.dll file is on the server. You may wanna check notes 178949 and 738371.
Hope it helps
Jesus
02-22-2007 8:00 AM
Hi!
I'm facing some analogue problems.
I'm looking to download the file dbmssslib.dll but I cannot find it. We have a ECC 6.0 installation on AS400 and I need this file to connect to an MSQL database.
Can you give me a working link to that file or can you mail this to me?
Kind regards,
M.