Strange characters imported from Oracle table using ODBC

  • KM00430479
  • 16-May-2013
  • 16-May-2013


Using ODBC to connect to an Oracle table may produce strange and illegible characters


A Connect-It scenario has as source an Oracle table using an ODBC connection. The logs are showing strange characters in fields where there is no data present from the source. These strange characters are causing the scenario to fail.
Source Connection: Oracle 11g using ODBC
Connect-It: Version 9.40
Connect-It Environment: Windows Server 2008 R2


Reconfigure the database connector in the scenario to use the Oracle native drivers.