Database connection to SQL server using ABAP program

Former Member — Thu, 22 Nov 2007 10:55:08 GMT

Hi all,

What do we need to enter in the con_env feild of dbcon table for connecting to the SQL databse

I have entered the following string dbname=SAP_DB user=sap password=sap host=145.17.60.87 port=1433

Is it correct ?

DATA: tbr(50) type c.

EXEC SQL.

CONNECT TO 'SQLDB'

ENDEXEC.

IF SY-SUBRC NE 0.

message s000(zf) with 'Imposible conectar a SQLDB'.

ENDIF.

EXEC SQL.

SET CONNECTION 'SQLDB'

ENDEXEC.

EXEC SQL PERFORMING LOOP_OUTPUT.

SELECT T_DES

INTO :tbr

FROM data_table

ENDEXEC.

FORM LOOP_OUTPUT.

write: / tbr.

ENDFORM.

where data_table is the database table name

also i think i will have to create a table in ABAP dictionary with the same structure as data_table but that table will start from 'Z'.

kindly help

Re: Database connection to SQL server using ABAP program

Former Member — Fri, 23 Nov 2007 08:08:59 GMT

SOLVED ON MY OWN

Former Member — Mon, 17 Dec 2007 20:12:24 GMT

Hi Sunil,

I am working on this same problem. What was the solution you used?

Thanks

Shane