Hello ,
I 'm getting the below error when trying to migrate a simple MS Access 2010 db with only 1 table ('authors') to db2 v9.7 on a windows machine. It seems it does conect to the access db and get the does connect to
[2014-03-20 16.41.24.593] Database Product Version :04.00.0000
[2014-03-20 16.41.24.594] JDBC driver JDBC-ODBC Bridge (odbcjt32.dll) Version = 2.0001 (06.01.7601)
[2014-03-20 16.41.24.595] Database Major Version :-1
[2014-03-20 16.41.24.595] Database Minor Version :-1
[2014-03-20 16.41.24.596] Unknown Version for access
[2014-03-20 16.41.24.596] Starting Blades
[2014-03-20 16.41.24.597] Starting Blade_0 and building memory map.
[2014-03-20 16.41.24.599] 0 values cached in indexMap
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver does not support this function
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLForeignKeys(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getImportedKeys(Unknown Source)
at ibm.GenerateExtract$BladeRunner.BuildFKeysMap(GenerateExtract.java:7598)
at ibm.GenerateExtract$BladeRunner.BuildBladeMemoryMap(GenerateExtract.java:12754)
at ibm.GenerateExtract$BladeRunner.run(GenerateExtract.java:7281)
[2014-03-20 16.41.24.609] "Authors" Row[0] Col[1] Error:No data found
[2014-03-20 16.41.24.609] "Authors" Row[1] Col[1] Error:No data found
[2014-03-20 16.41.24.610] "Authors" Row[2] Col[1] Error:No data found
Thanks in advance for your help