External connection with MYSQL db

[andrea_galluccio2]

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

[Former Member]

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.

[andrea_galluccio2]

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.