We are wanting to tap into a external data source that is on a Sql Server box.
This statement seems like you want to access your SQL data from FileMaker. Yet the rest of the post refers to using ODBC to grab data from FileMaker into something. Which was is it?
If you are trying to get FMS to use data FROM SQL Server, then you will need to get the SQL driver from Actual Technologies.
Sorry for not being clear. I am wanting to get fMS to use data FROM SQL Sever. It is installing the SQL driver I'm having trouble with. I was trying to install the driver that came with FM Server (SequelLink). Do we have to buy a driver from Actual Technologies?
For a mac yes.
Just for some clarification, the ODBC driver that comes with FileMaker Pro 10 is used for sharing FileMaker data with other applications using ODBC; not the other way around. To have FileMaker Pro access an external application, you will need to acquire the driver for that external application.
Thanks for clarifying, that helps a lot!