5 Replies Latest reply on Aug 19, 2013 9:34 PM by BowdenData

    Error 802 when running an import OBDC scheduled script in FMS but it works on client machine

    submarine

      I am running into the same problem as described in the article in FM Support.

      http://help.filemaker.com/app/answers/detail/a_id/11080/~/unable-to-import-data-from-an-odbc-data-source-via-a-filemaker-server-scheduled

       

      I followed the suggested solution by installing the 32-bit driver to the 64-bit server, but the article did not elaborate on the subsequent steps after 'opening the ODBC Data Source Administrator for 32-bit drivers on the 64-bit server' and I am lost.

       

      When my Data Source Administrator was opened, I saw an existing data source which I believe was set up using the 64-bit driver. This has served me well for live connections until I run into this scheduled import issue.

      Unfamiliar with the setup, I did not do anything to it and re-ran the scheduled script with the existing ODBC and it still returned me a 802 error.

       

      Do I need to create a new Data Source using the 32-bits driver?