I have a workspace that reads data out of SQL Spatial, reprojects it and inserts it into a series of ArcSDE featureclasses. It runs perfectly fine in workbench, however after publishing it to FME Server and running it I received the above error.
As well, there was a warning Library 'C:\\Program Files\\FMEServer\\Server\\fme\\plugins/FME_ADO.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this library. As well, there was a warning that the FME_ADO.dll was found but could not be loaded.
I only installed FME Server yesterday, so perhaps there is something I missed??
Creating reader for format: Microsoft SQL Server Spatial 41INFORM0.03.1Today at 14:53:12Trying to find a DYNAMIC plugin for reader named `MSSQL_SPATIAL' 42WARN0.03.1Today at 14:53:12Library 'C:\\Program Files\\FMEServer\\Server\\fme\\plugins/FME_ADO.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this library 43INFORM0.03.1Today at 14:53:12Loaded module 'MSSQL_SPATIAL' from file 'C:\\Program Files\\FMEServer\\Server\\fme\\FME.dll' 44ERROR0.03.1Today at 14:53:12Module 'FME_ADO' is unavailable for use with this FME edition 45INFORM0.03.1Today at 14:53:12FME Session Duration: 6.3 seconds. (CPU: 2.7s user, 0.5s system)
