topic Re: Problem with DBCO in Application Development and Automation Discussions

Problem with DBCO

Former Member — Thu, 18 May 2006 21:19:23 GMT

Hi abapers.

I've been using a DBCON to a SQL Server DB, i configured the conection in Trx. DBCO and it works just perfect.... however, the DB is being changed to another server, now when i configured this new DB the system can't connect to it. I can access it from the network, from the SQL Server admin tool, everything seems to be just fine, but i can't access it from SAP.

I repeat, the original configuration works perfect, when i change to the other server is when it breaks down.

some ideas what might be the problem?

thanx

Jesus

Re: Problem with DBCO

former_member182371 — Fri, 19 May 2006 20:13:41 GMT

Hi Jesus,

have a look at SAP Note 738371 where you can find the following report to check your connection:

REPORT ZTESTDBCON.

data: DBN(128).

EXEC SQL.

CONNECT TO 'TST'

ENDEXEC.

EXEC SQL.

SET CONNECTION 'TST'

ENDEXEC.

EXEC SQL.

SELECT db_name() INTO :DBN FROM SVERS

ENDEXEC.

WRITE: / 'current database name', DBN.

Best regards,

Re: Problem with DBCO

Former Member — Fri, 01 May 2009 07:42:35 GMT

Hi ..

for that wirte 1 small ABAP program

*Native SQL command

EXEC SQL.

set connection 'Connection_string'

ENDEXEC.

IF sy-subrc 0.

EXEC SQL.

connect to 'Connection_string'

ENDEXEC.

ENDIF.

*here use any table and work area to transfer data

EXEC SQL.

SELECT CUST_CODE FROM CUSTOMER_MAP@IMPSCONN

INTO :ZIMPSCTCODE

WHERE SAP_CODE = :IT_IMPS_CUST-CUST_CODE

ENDEXEC.

Salil ....