Re: Filtering / modify incoming SQL instruction ?

[Bob Gratton]

Well, it is not hacking and it is legitimate. The third-party software (FileMaker) is natively supporting MySQL ODBC to connect to external DB.

So, I have setup a System DSN (MySQL ODBC) pointing to a MariaDB server. Why ? To be able to use de CONNECT engine from MariaDB to connect to another pretty old DB with a limited 32 bits ODBC that is not supporting all the SQL standards.

Pretty twisted solution, but it is the only way that I was able to access my data from FileMaker.

The setup is working if I issue direct SQL queries through the MySQL ODBC. Turning on the MySQL log debug, I was able to get the SQL query issued by FileMaker:

UPDATE `dbname`.res_partner SET email='[e-mail]' WHERE id=1;

The pretty old 32 bits does not support the DBNAME part of the command.

If I manually send :

UPDATE res_partner SET email='[e-mail]' WHERE id=1;

to the MySQL ODBC, the update is working fine.


So...this is where I stand. Hoping for a miracle. :-)