On Sep 7, 2:30 pm, "jlin...@gmail.com" <jlin...@gmail.com> wrote:
> I'm currently working with a MySQL backend and is trying to use
> FileMaker 9's Web Form capabilities as a front end. From FileMaker
> Pro's interface, I have used the ODBC to connect my FileMaker database
> to my MySQL tables. The schema and existing data records loads into
> FileMaker without a problem.
> However, when I'm trying to insert text (VARCHAR and TEXT) data from
> FileMaker, it blanks out and ends up only inserting a blank into
> MySQL. Default values set on the MySQL side only take effect if I left
> that field blank on FileMaker when I create a new record. Default
> field values set on FileMaker also blanks out upon committing. I could
> insert fine directly into MySQL via phpMyAdmin. Inserting numerical
> values from FileMaker also commits fine. It's just text-based stuff
> from FileMaker...
> It doesn't seem like anyone else has had this type of problem
> before...could I just be overlooking something that is very simple?
> Advices on how to approach this issue is greatly appreciated.
> Thank you.
It would appear that the driver that was provided by MySQL (MySQL
Connector/ODBC 3.51 was what I used) is not supported by FileMaker.
Upon installing the Actual ODBC driver, which is supported by
FileMaker, the problem disappeared.