AnsweredAssumed Answered

FM Server ODBC import script

Question asked by jwagner on Sep 6, 2012
Latest reply on Jan 1, 2015 by donjuancarlos_1


FM Server ODBC import script

Your post


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