submarine

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

Discussion created by submarine on Aug 18, 2013
Latest reply on Aug 19, 2013 by BowdenData

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?

Outcomes