MySQL Forums
Forum List  »  Connector/ODBC

Re: Filtering / modify incoming SQL instruction ?
Posted by: Bob Gratton
Date: January 21, 2019 06:13PM

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='' 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='' WHERE id=1;

to the MySQL ODBC, the update is working fine.

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

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.