Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What ODBC settings should I use when transferring data from FileMaker to MySQL?

April 26, 2017Data FileMaker MySQL ODBC settings transferring

0

Posted

What ODBC settings should I use when transferring data from FileMaker to MySQL?

1 Answer

0

Posted

FileMaker 5.0, 5.5 and 6.0 [for Windows] includes an Advanced tab in the FileMaker ODBC Data Source panel. The Max Text Length in this panel should be set to 65000 in order to match the maximum text size for a FileMaker field. The Fetch Chunk Size should generally be set to 100 when transferring fewer than 500 FileMaker fields of data. When working with more than 500 fields, this parameter should be set to 25 or even as low as 10. Setting this parameter too high will often cause FileMaker to crash during the data transfer which will often result in a “fetch forward” error.