1 2 Previous Next 16 Replies Latest reply on Dec 17, 2015 7:47 AM by abishop

    ERROR [HY000] [FileMaker][FileMaker] No cursor open for statement

    NeerajSaini

      Summary

      ERROR [HY000] [FileMaker][FileMaker] No cursor open for statement

      Product

      FileMaker Server

      Version

      12

      Operating system version

      Windows Server 2008 64 bit

      Description of the issue

      We have installed Fm12 on Windows Server 2008 64 bit. And I have Windows 7 64 bit installed on my local system and SSRS 2008 and FileMaker 12 new 64 bit drivers.

      The connection and queries are fast with the new drivers as compared to data direct drivers. But the new problem I see is that dataset do not get the fields in SQL Server Report Designer (this was coming in the data direct drivers). The error meaage is get is
      "Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct.
      ERROR [HY000] [FileMaker][FileMaker] No cursor open for statement

      Does this mean its not possible with get reports from FM12 using SSRS 2008.

      Can anyone please help. !

      Expected result

      report designer with the dataset populated fields

      Actual result

      report designer with the dataset fields not populated

      Exact text of any error message(s) that appear

      "Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct.
      ERROR [HY000] [FileMaker][FileMaker] No cursor open for statement

      SSRS.PNG

        1 2 Previous Next