Sql odbc connectiondoes not work when DB is hosted on server
Operating system version
client Win7 32 bit Server win 2008 R2
Description of the issue
I have an FM12 datafile which has connections to an external sql source. The connection works perfectly when the datafile is hosted on the client but when I host the datafile on a FM12 server on another computer I cannot reference the odbc sources even though I am using the original client where the sources were established. If I attempt to re-establish the external data source in FMP the DSN list appears empty even though the odbc sources are still established in windows. If I bring the database back from the server to the local machine all works correctly again.
Steps to reproduce the problem
On a win7 client:
Create an odbc source to an mssql database.
Create a FMP database using FMPA12 and configure an external data table. Check that the table is populated. then close the datafile.
Move the datafile to a FMS12 server on a windows 2008R2 platform.
Open the datafile remotely from the original win7 client.
The external date links do not work and cannot be re-established.