AnsweredAssumed Answered

Need help with ESS

Question asked by brisance on Jan 8, 2013
Latest reply on Aug 7, 2013 by brisance

Hi everyone,


I need some help with ESS. If I import the data via ODBC, everything is fine. But when I want to include the data source as an ESS, I get the following error.


On Windows 8 x64:

ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The floating point value '170E-454' is out of the range of computer representation (8 bytes). [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'F6'.


On OS X 10.8.2 using the licensed Actual driver:

ODBC Error: [Actual][SQL Server] Incorrect syntax near 'F6'.


What am I doing wrong? I'm on FileMaker Pro Advanced v12.0.3. Thanks for any insight.



I just tried to access the data source using LibreOffice on my Mac Version (Build ID: 2ef5aff) via the Actual driver and it works perfectly. I'm still not sure why it will not work in FileMaker. Very strange.