Skip to main content
Solved

fmecloud reading Microsoft access


ciarab
Contributor
Forum|alt.badge.img+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

Best answer by fmelizard

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.

View original
Did this help you find an answer to your question?

2 replies

fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • Best Answer
  • July 28, 2016

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.


ciarab
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • July 28, 2016
fmelizard wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings