locked
Error Trying to Access DB2 Database Using ODBC Connector on Data Factory RRS feed

  • Question

  • Currently Using Data Factory to Connect to DB2 Database. Testing the connection is successful, but when trying to preview the data the below error is thrown:

    Getting the following error:

    The value of the property '' is invalid: 'Unknown SQL type - -99.'. Unknown SQL type - -99. . 



    My question is why is this error being thrown and how can it be fixed?

    • Edited by bwong9 Wednesday, September 18, 2019 6:12 PM
    Wednesday, September 18, 2019 6:12 PM

Answers

  • Yes, we found that the reason for this error was that one of the columns in the Database had a 'clob' type field, which is not supported by ODBC.
    • Marked as answer by bwong9 Thursday, November 7, 2019 9:32 PM
    Thursday, November 7, 2019 9:32 PM

All replies