Server ODBC Import question
I recently upgraded from FMPro 11 to FMPro 12 and server 12. I read somewhere that you only need to set up the ODBC data source on the server but this doesn't seem to be working. There are several scripts in my DB that import via a SQL statement and update matching fields in my DB. If I do not have the ODBC data source setup on the client PC those imports fail. Do I need to update my scripts? Are only ODBC external tables supported? The documentation on this is sketchy. Any help or shoves in the right direction would be appreciated.