1 2 3 Previous Next 41 Replies Latest reply on Aug 7, 2013 8:40 AM by brisance

    Need help with ESS

    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.

        1 2 3 Previous Next