ExecuteSQL don't execute any SQL command

[AnFrusch@pepp]

Hello all,

I'm facing a new problem and I hope you can help me solve it..

My web site is based on MySQL (latest version) and - after trying using a External data source (ESS?) - I decided to update record via DSN (odbc driver MySQL connector latest version 5.01.05 febraury 2008) and Execute SQL script step.

Until 3 weeks ago we used mysql 4.1.2.. (I can't remember the exact version but sure it wasn't 5) and the same driver on PCs; since we upgraded to MySQL 5 some SQL instructions stop working w/out returning any error (using Get(LastOBDCError) function).

using debug tool and data viewer I copied the SQL instructions and paste them into another application which execute the query instead of filemaker and all of them are properly working.

Do you know some incompatibility between Filemaker and MySQL 5? Is this version supported by FM pro 10?