AnsweredAssumed Answered

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

Question asked by NeerajSaini on Jul 26, 2012
Latest reply on Dec 17, 2015 by abishop

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

Outcomes