Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. ORA-12170 when installing ODBC for Voyager

    ORA-12170 when installing ODBC for Voyager

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    When attempting to install ODBC for Voyager receive the following error:

    ORA-12170: TNS: Connect timeout occurred
    (#12170) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (#0)
    

    Answer

    • Make sure the tnsnames.ora file is correctly configured, has no syntax errors, is in the proper directory and accessible.  Make sure it is named correctly (for example the filename is tnsnames.ora and not tnsnames.ora.txt).
    • Check with your I.T. Department that there is not a PC firewall, anti-virus software, and/or an institutional firewall preventing connections between the PC and the Voyager server.

    Additional Information

    ORA-12170 usually indicates a connection problem.

    If you are able to run telnet on your PC, you can trying using it to test connectivity for the ODBC port (port 1521).  See: Using telnet as a tool for troubleshooting connection problems on hosted Voyager servers

     

     

     


    • Article last edited: 13-Dec-2019
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ORA-12154 when installing ODBC for Voyager
      • ORA-12514 when try to connect to Prepackaged Reports
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved