topic Re: connection to external SQL Server using ABAP in Application Development and Automation Discussions

connection to external SQL Server using ABAP

Former Member — Tue, 18 Apr 2006 15:14:01 GMT

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

Re: connection to external SQL Server using ABAP

ferry_lianto — Tue, 18 Apr 2006 15:40:31 GMT

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

Re: connection to external SQL Server using ABAP

Former Member — Tue, 18 Apr 2006 15:45:02 GMT

hi kousik,

check these links

Regards

naveen

Re: connection to external SQL Server using ABAP

Former Member — Tue, 18 Apr 2006 15:46:16 GMT

Regards,

Ravi

Re: connection to external SQL Server using ABAP

Former Member — Tue, 18 Apr 2006 20:54:41 GMT

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

Re: connection to external SQL Server using ABAP

Former Member — Wed, 19 Apr 2006 10:13:28 GMT

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

Re: connection to external SQL Server using ABAP

Former Member — Wed, 19 Apr 2006 17:15:15 GMT

Just make sure de dbmssslib.dll file is on the server. You may wanna check notes 178949 and 738371.

Hope it helps

Jesus

Re: connection to external SQL Server using ABAP

Former Member — Thu, 22 Feb 2007 08:00:36 GMT

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,

Re: connection to external SQL Server using ABAP

Former Member — Mon, 20 Aug 2007 10:29:38 GMT

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