Topic
  • No replies
fsonaglioni
fsonaglioni
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 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 

Attachments