I have a client that is still using FileMaker Pro 5. They are switching to a new software that uses SQL Server as their database platform. They have a need to be able to reference the FileMaker data in their report. Only way I can think of getting the SQL Server Database data and the FileMaker data is through an ODBC that would link the two together.
Question is, has anyone successfully create a linked server from SQL to FileMaker Pro? If so, can you please provide detail steps?
I found the above post, but it's an old thread. Need to understand if I setup the ODBC from the SQL server I am connecting from or what? Also the ODBC driver for FileMaker, Do I need to install FileMaker on the SQL Server to get that driver or what driver does it use?