0 Replies Latest reply on Sep 8, 2010 9:50 AM by donjuancarlos_1

    Isuues exporting from MySQL ODBC data source.



      Isuues exporting from MySQL ODBC data source.


      I am using FM11 Windows.  Files are hosted on FMAS 11 on a Windows  Vista box.

      I  have an ODBC link out to a MySQL database (Simply Accounting) I am using the MySQL 5.1 ODBC driver.  The  link allows users to get financial information for jobs.  Most fo the  job information is stored in Filemaker.  When I run a script to collate  information and export a report to excel, most times the information  from the MySQL database does not appear.  The only consistent workaround  I have found is to manually run a report that includes data from the  MySQL database to the screen, then run the original export script. Fine  for me; tough on users.

      If anyone can chime in on this issue, it would be appreciated.