Skip to main content
Kofax

TNS protocol adapter error ORA-12560 error accessing Database Validation Properties in Administration Module

19076

QAID # 19076 Published 

Question / Problem:

What can cause the following error to occur when trying to access the Database Validation Properties in Administration module or opening a Batch in the Validation module?

ERROR [HY000] [Oracle][ODBC]ORA-12560: TNS:protocol adapter error
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

How can this issue be resolved?

Answer / Solution:

This error can be caused by not having specified the Service name for the Oracle data source in the ODBC Data Source Administrator.

To resolve this issue, specify the Service name for the Oracle data source in the ODBC Data Source Administrator.

Applies to:

Product Version
CAPTURE 10.0
  10.1
  10.2
  11.0