Hello
i want to connect to external MySQL DB using ABAP program.
I have maintained entry in DBCO transaction and configure the connection like this:
DB_Connection MYSQL
DBS MSS
USername xxxxxxx
Password xxxxx/xxxxx
connection info MSSQL_SERVER=10.58.194.134 MSSQL_DBNAME=helpdeskportal OBJECT_SOURCE=helpdeskportal
Report:
DATA: con_name TYPE dbcon-con_name VALUE 'MYSQL'.
DATA: wa_spfli TYPE spfli-carrid.
EXEC SQL.
set connection: con_name
ENDEXEC.
if sy-subrc ne 0.
message e000(z_msg) with 'Connection not opened'.
else.
EXEC SQL.
connect to: con_name.
ENDEXEC.
endif.
IF sy-subrc NE 0.
*error handling
ELSE.
EXEC SQL PERFORMING evaluate.
select carrid from spfli into :wa_spfli.
ENDEXEC.
ENDIF.
EXEC SQL.
set connection default
ENDEXEC.
&----
*& Form EVALUATE
&----
----
----
FORM evaluate .
WRITE / wa_spfli.
ENDFORM.
when i am trying to process set connection: con_name program is getting terminated. please help.
Regards,
Himangshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.