I'm having a strange issue with an solution of mine that baiscally is a mix of FM tables and ESS tables. After opening the solution via a 3g network , everything works fine. If the user hibernates the solution (either from an incoming call or hitting the home button) , and the user re-opens the solution within an hour or two , it's still ok. If the user tries to re-open the solution after a few hours , the reauthentication privelage set works fine for the FM part of the solution, but any field referenced in ESS simply states <<Connection Lost>>. ie , hibernation / re-authentication is working fine for the FileMaker tables but not the MSSQL ESS tables. The users are using a privelage set called 'fmreauthenticate5000' (around 80hrs) so they don't have to re-login after hibernation even if there is no activity for a few days. The only way to re-establish connection to ESS is to close the file and open it again. Has anyone else had this problem ???
Here's the configuration stats :
FileMaker Server 126.96.36.1995 on Windows 2008 R2 64Bit , FM Go 12.07 , MSSQL Native Client drivers 10.0 installed on the FM server (64bit and 32bit versions) , MSSQL 2005 9.00.5000.00