External connection with MYSQL db

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