4 Replies Latest reply on Jan 1, 2015 12:19 PM by donjuancarlos_1

    FM Server ODBC import script

    jwagner

      Title

      FM Server ODBC import script

      Your post

      Hello,

      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