FMS11 - insert over ODBC driver doesn't add a record, or throw an error

[TinBane]

I'm using pyodbc to send SQL queries to a filemaker 11 server.

I can read data, no problem. I can update data, no problem. But when I attempt to insert data, no errors are thrown but no records are added to the database.

[Wim Decorte]

What platform are you on, where the ODBC query originates from?

[TinBane]

So I'm running Mac OS X. The ODBC driver is on mac os x, as is the python code.

Server is Mac OS X too.

Is there any way to get an SQL log from FMS 11? for xdbc?