Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORA-12514 when try to connect to Prepackaged Reports

    • Product: Voyager

    Problem Symptoms

    Attempt to link tables in Prepackaged Reports, receive error:

    ODBC--call failed.
    [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    (#12514) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0)


    Service name in tnsnames.ora file is not set correctly


    1. Open tnsnames.ora file on workstation.
    2. Replace ( SERVICE_NAME = VGER.{hostname}) with ( ORACLE_SID = VGER )
    3. Save change.
    4. Relink tables

    Additional Information

    Some older versions of Oracle may have required SERVICE_NAME instead of ORACLE_SID but current versions of Voyager should use the above in tnsnames.ora, and current template for tnsnames.ora is available in Installation and Configuration of ODBC for Voyager

    • Article last edited: 06-Feb-2019
    • Was this article helpful?