I have looked through a myriad of threads but cant seem to find the answer.
I have installed the SQL Server Native Client 11.0 version to my laptop (Win10) I set up the driver to 64bit (System DSN) which is the same as my FMP 15 advanced. I also set it up in 32bit just incase.
Back in FMP 15 in External Data Sources, I create a new source type ODBC and try to select the DSN, No driver is visible.
In Import records ODBC data source, I see the driver and it can see the tables/columns in the SQL database.
Why is the driver not available in the External Data Source?
Thanks for any help!