FM16 and ESS Issue

Discussion created by fmpdan on Jun 7, 2017
Latest reply on Jan 23, 2019 by user13971

I am able to reproduce this on multiple occasions now. I have a Filemaker 16 application that is primarily a front end of ESS tables. MS SQL server. Working with a simple users table throughout the day. Periodically it seems to lose track of some of the records. Doing a hard refresh has no effect. Yesterday the all record set went from 9-7. No one else is in the file. Doing a find for one of the missing records still, shows nothing. Opening up the same application in 15 on the same machine and all the records are there. Quit 16 and open it again and the full set is back.


This has not happen before with 14 or 15. The MSSQL server is 2005 we are going ot upgrade this soemtime this summer. But I am not sure that this issue is realted ot the sever. We have the latest drive for that SQl server installed.


The wai I read the support docs for version it seems like this should work as it did in 15.

Which ODBC data sources/drivers are supported with External SQL Data Sources? | FileMaker