I have a FileMaker 5.0 application in use by a group. I want to connect to one of the files using ODBC from another server using ColdFusion. However, all attempts to do this give me the error:
ODBC Error Code = S1000 (General error)
[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed
My query looks like so:
<CFQUERY DATASOURCE="FileMakerApp" NAME="qResults">
select *
from filemakerfile
</CFQUERY>
Can anyone shed some light on this?