Question

ms access reader failed to create adodb connection object

  • 22 March 2013
  • 5 replies
  • 20 views

Hello, 

 

l have win7 64bits machine, 

 

a 32bits microsoft office pack

 

a 32bits fme (before l've desinstalled the 64bits fme)

 

 

already installed on my machine (ie Article Number: 000002381) : 

 

- .NET Framework v4

 

- SQL Native Client 2008 or greater

 

-  Microsoft System CLR Types 2012

 

 

and when l try to read a ms access database, l have the message below

 

quite similar to what l can find on internet but not exactly the same, and any solutions work.

 

the last solution l see is to reinstall win7 on my machine.. what is not so funny but maybe better indead then triying to make that ms access reader read my access database

 

thanks for your advices

 

 

---------

 

Trying to find a DYNAMIC plugin for reader named `MDB_ADO'

FME API version of module 'MDB_ADO' matches current internal version (3.7 20121025)

Trying to find a DYNAMIC plugin for reader named `MDB_ADO'

FME API version of module 'MDB_ADO' matches current internal version (3.7 20121025)

MS Access Reader: Read 0 DEF line(s). Found 0 attribute(s)

MS Access Reader: Opening `D:\\ZTRansfert\\Dropbox\\2013-03-06_restructuration-datas-ovipa\\1_sources\\SAMM\\SAMM1\\1_ACCESS\\E3_SAMM1_ATL_2013_03_11_a_utiliser.accdb' for read operation

MS Access Reader: Failed to create 'ADODB::Connection' object. Error: (-2147221164) Classe non enregistrée

Failed to open reader

Merged 0 schema features read from 1 datasets into 0 resulting feature types

UniversalReader -- readSchema resulted in 0 schema features being returned

Reader Parameter(0) = >D:\\ZTRansfert\\Dropbox\\2013-03-06_restructuration-datas-ovipa\\1_sources\\SAMM\\SAMM1\\1_ACCESS\\E3_SAMM1_ATL_2013_03_11_a_utiliser.accdb<

Reader Parameter(1) = >PROVIDER_TYPE<

Reader Parameter(2) = >MDB_ADO<

Reader Parameter(3) = >_MERGE_SCHEMAS<

Reader Parameter(4) = >YES<

Reader Parameter(5) = >RETRIEVE_ALL_TABLE_NAMES<

Reader Parameter(6) = >YES<

Reader Directive(0) = >RUNTIME_MACROS<

Reader Directive(1) = >PROVIDER_TYPE,MDB_ADO,_MERGE_SCHEMAS,YES,RETRIEVE_ALL_TABLE_NAMES,YES,_MERGE_SCHEMAS,YES<

Configuration object contents:

FME Temporary Directory: C:\\Users\\hfalchet\\AppData\\Local\\Temp

mapping file Line 0: `APPLICATION' `FME_WORKBENCH'

mapping file Line 1: `AUTOREG' `YES'

mapping file Line 2: `LOG_MAX_FEATURES' `-1'

mapping file Line 3: `LOG_APPEND' `NO'

mapping file Line 4: `FME_HOME' `C:\\apps\\FME\\'

mapping file Line 5: `FME_SESSION_USED' `TRUE'

mapping file Line 6: `R_2_METAFILE' `MDB_ADO'

mapping file Line 7: `R_2_DATASET' `D:\\ZTRansfert\\Dropbox\\2013-03-06_restructuration-datas-ovipa\\1_sources\\SAMM\\SAMM1\\1_ACCESS\\E3_SAMM1_ATL_2013_03_11_a_utiliser.accdb'

mapping file Line 8: `R_2_PROVIDER_TYPE' `MDB_ADO'

mapping file Line 9: `R_2__MERGE_SCHEMAS' `YES'

mapping file Line 10: `R_2_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 11: `R_2_PROVIDER_TYPE' `MDB_ADO'

mapping file Line 12: `R_2__MERGE_SCHEMAS' `YES'

mapping file Line 13: `R_2_MERGE_SCHEMAS' `YES'

mapping file Line 14: `R_2_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 15: `R_2__MERGE_SCHEMAS' `YES'

mapping file Line 16: `R_2_MERGE_SCHEMAS' `YES'

mapping file Line 17: `SCHEMA_TIME' `YES'

mapping file Keyword: `R_1_DEF' occurs 0 time(s)

mapping file Keyword: `MDB_ADO_DEF' occurs 0 time(s)

mapping file Keyword: `R_2__MERGE_SCHEMAS' occurs 3 time(s)

mapping file Keyword: `LOG_MAX_FEATURES' occurs 1 time(s)

mapping file Keyword: `AUTOREG' occurs 1 time(s)

mapping file Keyword: `R_2_DATASET' occurs 1 time(s)

mapping file Keyword: `SCHEMA_TIME' occurs 1 time(s)

mapping file Keyword: `R_2_RETRIEVE_ALL_TABLE_NAMES' occurs 2 time(s)

mapping file Keyword: `LOG_APPEND' occurs 1 time(s)

mapping file Keyword: `R_2_DEF' occurs 0 time(s)

mapping file Keyword: `R_2_PROVIDER_TYPE' occurs 2 time(s)

mapping file Keyword: `FME_SESSION_USED' occurs 1 time(s)

mapping file Keyword: `R_2_METAFILE' occurs 1 time(s)

mapping file Keyword: `FME_HOME' occurs 1 time(s)

mapping file Keyword: `R_2_MERGE_SCHEMAS' occurs 2 time(s)

mapping file Keyword: `APPLICATION' occurs 1 time(s)

UniversalReader -- readSchema resulted in 0 schema features being returned


5 replies

Userlevel 5
Hi,

 

 

sounds like there might be something wrong with your installation of the ADODB components. Are you able to read your Access database using the regular Reader?

 

 

You could try to re-install the Microsoft MDAC components to see if that makes a difference.

 

 

David
Hi, thanks for your answer.

 

l've installed the mdac components and still have the same problem.

 

thanks, 

 

helene

 

 

 

Userlevel 5
Hi Helene,

 

 

can you read the mdb with the regular MS Access (MDB_ADO) reader?

 

 

Consider also reinstalling FME, making sure that you have the latest version of whatever release you're using (FME2012 sp4, FME2013 sp1, etc).

 

 

David
Userlevel 5
Hi again,

 

 

a few more ideas to try:
  • Open the mdb in question using MS Access, see if you are able to open (and modify data in) the relevant table(s).
  • Open the mdb in MS Access, do a "Save as..." and try to read the resulting file with FME
  • Compress the mdb in question using MS Access
  • Try to read the MS Access file using ODBC and the FME "ODBC2" reader
Good luck!

 

 

David
Hello, thanks for your help, in the end l've reinstalled my computer, and IT WORKS!!!! fme can now read my mdb and accdb databases!

Reply