• No replies
1 Post

Pinned topic IBM Data Movement Tool - Ms Access to DB2 migration error

‏2014-03-20T22:02:22Z |
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] Database Product Version :04.00.0000
[2014-03-20] JDBC driver JDBC-ODBC Bridge (odbcjt32.dll) Version = 2.0001 (06.01.7601)
[2014-03-20] Database Major Version :-1
[2014-03-20] Database Minor Version :-1
[2014-03-20] Unknown Version for access
[2014-03-20] Starting Blades
[2014-03-20] Starting Blade_0 and building memory map.
[2014-03-20] 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(
        at ibm.GenerateExtract$BladeRunner.BuildBladeMemoryMap(
        at ibm.GenerateExtract$
[2014-03-20] "Authors" Row[0] Col[1] Error:No data found
[2014-03-20] "Authors" Row[1] Col[1] Error:No data found
[2014-03-20] "Authors" Row[2] Col[1] Error:No data found


Thanks in advance for your help