I have been looking at several issues many of which are driving me nuts with ODBC.
I used the Driver for ODBC from MySQL that is ok in FM 12 client creates records in MySQL but is only allowing the first character for text fields to be recorded . Actual Technologies ODBC is not connecting so that is a work in progress to work.
Tomorrow we will try this again with a windows server which I did not want to have to do if ODBC is not working there then I am scraping FM 12 Server adavanced and writing it off as a waste of time dealing with. I am really disapointed in FM 12 at this point there are way to many issues with fields not displaying correctly etc.