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.

 

UPDATE:

I just tried to access the data source using LibreOffice on my Mac Version 3.6.4.3 (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.

Outcomes