FM Server ODBC import script
I'm running an FMP12 database on FMS12, trying to import records from a Progress database using ODBC. My script runs fine from the FMP client, but when running from the Server it fails with an '802' error. The server is a Windows Server 2008 machine and I have set up a 32-bit system DSN using odbcad32.exe. For some reason, the FMS script Import step isn't able to connect with the external database. Now here's the catch - running Excel from the server, I am able to get data from the external database into Excel using the same System DSN. So why can't FMS do the same??
Thank you, John