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 188.8.131.52 (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.