Skip to main content
Solved

fmecloud reading Microsoft access

  • July 27, 2016
  • 2 replies
  • 39 views
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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • 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
  • ciarabContributor
  • Author
  • Contributor
  • 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.

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

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.