Working with SQL, ODBC under Windows 8 using FM 10 pro
I am working with FM 10 pro that I installed under Windows 8. I properly defined the SQL driver under USER and under SYSTEM to look at my localdb server on (Localdb)\Projects which is in one of my C: drive subdirectory.
I am able to test the connection on the ODBC set-up and it works. I am also able to access the ODBC drivers when I tried an IMPORT from FILEMAKER and correctly detect the fields on the table that I use in SQL 2010.
Now I want to declare the External Database using the ODBC instead of the FILEMAKER so that I can select the SQL driver and use the SQL table in my relationship table of the FILEMAKER database. When I do that I want to create an external connection using the "Manage External Data Source" and it sends me to "Edit Data Source" where y select Type: ODBC.
When I hit the button on DSN "Specify" , the "Select ODBC Data Source" comes in empty (no selection shows up on the data sources available.
Is there an issue with Window 8, SQL driver on ODBC, and FILEMAKER 10 pro ???