Hi. I'm new to this community and not a FileMaker developer. A client of mine is using a FileMaker 16 Server solution. I am trying to build a query in Excel using a combination of data from FileMaker and Sage.
I've made a local copy of the database. I'm working remotely at the moment, and the client has not given remote access to the live system (yet).
I have set up ODBC drivers correctly and have succesfully returned data to Excel (Power Query) on Windows 10 64 bit version.
It seems I need to have the FileMaker database open, or at least the fm xdbc listener running, for the ODBC connection to work.
I was using a FileMaker trial subscription, which has now ended.
Do I need to purchase a FileMaker licence just to open the database to turn the fm xdbc listener on? Or is there another way?
Any help greatly appreciated.