Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

External connection with MYSQL db

andrea_galluccio2
Contributor
0 Kudos
119

Hi to all,

i need to make an external connection to MYSQL database with "EXEC SQL" instruction of abap/4.

I've already maintained the DBCON table: i've created a new external connection (called TEST1), but i don't really know how to valorize the DBMS (db type) and CON_ENV (connection instructions) fields .

For MSSQL is simple (there are many examples on this forum), but for MYSQL db?? I wasn't able to find posts about configuring it.

Is there this kind of connection possible. What are other "way" to make this connection? I'd like to select/insert/update some table rows

Helpfull answer will surely good rewarded

Thx a lot in Advice

Andrea Galluccio

2 REPLIES 2

Former Member
0 Kudos
58

Hi

For MSSQL , we give the Connection Information as just MSSQL_SERVER=<ServerName>. But for MYSQL and oracle the parameters differ.

Just check out http://www.irietools.com/iriepascal/progref125.html

I am not quite sure abt it.

0 Kudos
58

Thx a lot for your answer, but it doesen't work.

I've put all informations describe in your document in DBCON-CON_ENV field but i have always the same error :

'CX_SY_NATIVE_SQL_ERROR'

"SQL error 156 occurred when executing EXEC SQL."

Thx a lot

A.