Solved

fmecloud reading Microsoft access

  • 28 July 2016
  • 2 replies
  • 10 views

Badge +9

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

icon

Best answer by fmelizard 28 July 2016, 07:24

View original

2 replies

Userlevel 4
Badge +13

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.

Badge +9

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