I'm experiencing a really annoying issue with my FMS.
I have a table that I want to populate via an ODBC import from a MS SQL Server.
I have set up a 64bit ODBC SQL System DSN that works perfectrly when I run the script from a client on the server.
When I want to run the script via schedule on the server It fails with error 802 (Unable to open file). I have tried everything it seems. I have done the following:
Created bot 32 and 64-bit ODBC connections.. Named exactly the same. When I'm running the database on the FMS I only see the 64-bit ODBC in the ODBC dialog.. so I cannot choose the 32-bit ODBC.
The FMS16 is installed on a Windows Server 2016 Datacenter.
So what can be done differently?