topic Native SQL - CONNECT TO command in Application Development and Automation Discussions

Native SQL - CONNECT TO command

Former Member — Thu, 30 Apr 2009 18:54:15 GMT

Hi Gurus,

I am trying to access a third party database with Native sql. Basis has set-up a DBConnect with this database. When I tried to coonect to this databse, statement(CONNECT TO) showing sy-subrc = 4. My connection testing program is given here.

REPORT zbw_sd_test.

PARAMETERS: con TYPE dbcon-con_name.

EXEC SQL.

connect to :con

ENDEXEC.

WRITE: 'Sy-subrc = ' .

WRITE: sy-subrc.

When I chose another databse connection name, it is showing sy-subrc = 0.

Is that the problem with improper DBConnect?

How can I identify the reason for 'sy-subrc = 4' in CONNECT TO statement?

Pls guide me..

Thanks..

Saj

Re: Native SQL - CONNECT TO command

Former Member — Thu, 30 Apr 2009 19:00:29 GMT

Maybe:

PARAMETERS: con TYPE dbcon-con_name LOWER CASE.

Rob

Re: Native SQL - CONNECT TO command

former_member156446 — Thu, 30 Apr 2009 19:03:50 GMT

Hope this helps: [EXEC SQL|http://help.sap.com/abapdocu/en/ABAPEXEC_CONNECTION.htm]

Re: Native SQL - CONNECT TO command

Former Member — Fri, 01 May 2009 18:43:48 GMT

It was a problem with DBConnect..Basis team has done it..

Re: Native SQL - CONNECT TO command

Former Member — Sat, 02 May 2009 04:33:16 GMT

Hi...

first write below mentioned code for connection.

EXEC SQL.

set connection 'CHANCRM'

ENDEXEC.

Salil..