I'm trying to set up a windows 64bit FMP12 file as an ODBC datasource using Windows (7) ODBC Data Source Administrator.
I've done it already with different FMP12 file -with success. When I click the 'Test' button, it connects successfully.
My new file has the exact same ODBC setup but clicking 'Test' results in a connection failure.
The difference must be in the FMP12 file itself. I'm looking for ideas on what to look for.