AnsweredAssumed Answered

ODBC import or Connection on FMS 16

Question asked by diquito on Feb 13, 2018
Latest reply on Feb 16, 2018 by diquito

Hi All,

 

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?

 

Thanks

Outcomes