Skip to main content

Does anyone know what I need to do to read microsoft access db on fmecloud?

I am getting the error message below, do I need to upload a DLL to the plugin folder? thanks in advance!

Creating reader for format: Microsoft Access
45 INFORM 0.0 0.2 Today at 00:02:22 Trying to find a DYNAMIC plugin for reader named `MDB_ADO'
46 LD_LIBRARY_PATH is '/opt/fme-engine-2016/plugins:/opt/fme-engine-2016/fmecore:/data/fmeserver/Server/lib/fmeutil/fmecore:/data/fmeserver/Server/fme/fmecore:/usr/lib/oracle/11.2/client64/lib'

Could not load module '/opt/fme-engine-2016/plugins/fme_ado.so' : /opt/fme-engine-2016/plugins/fme_ado.so: cannot open shared object file: No such file or directory

Could not load module '/opt/fme-engine-2016/plugins/fme.so' : /opt/fme-engine-2016/plugins/fme.so: cannot open shared object file: No such file or directory

Could not load module '/opt/fme-engine-2016/plugins/mdb_ado.so' : /opt/fme-engine-2016/plugins/mdb_ado.so: cannot open shared object file: No such file or directory

Could not load module '/opt/fme-engine-2016/plugins/mdb.so' : /opt/fme-engine-2016/plugins/mdb.so: cannot open shared object file: No such file or directory

 

Module 'MDB_ADO' is unavailable for use with this FME edition

Because FME Cloud is Linux based, there is no "ADO" based Access reader/writer available. However, if you change your reader to be the MS Access (JDBC) one (available for sure in FME 2016.1, I think also in 2016.0) then you should be golden. Bonus -- I'm told in some scenarios it is faster too.


Because FME Cloud is Linux based, there is no "ADO" based Access reader/writer available. However, if you change your reader to be the MS Access (JDBC) one (available for sure in FME 2016.1, I think also in 2016.0) then you should be golden. Bonus -- I'm told in some scenarios it is faster too.

Excellent, I didn't even consider Linux! Newbie to cloud so thanks for the help


Reply