I am running into the same problem as described in the article in FM Support.
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?