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