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. Is there an easy way to test my Voyager ODBC configuration to make sure my connection works?

    Is there an easy way to test my Voyager ODBC configuration to make sure my connection works?

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

     

    Question

    How to test the Voyager ODBC configuration to make sure the connection to the Voyager server works.

    Answer

    Use the Windows "ODBC Data Source Administrator" application as shown below.

    Note that successful testing requires that the ODBC drivers are installed and that you have a correct tnsnames.ora file in the proper location on your PC.

    1. Determine your ODBC version (32-bit or 64-bit) - but note that Voyager only supports 32-bit.
    2. Go to Windows Search and type in: ODBC.
    3. Select the appropriate "ODBC Data Sources" Application for your version of the drivers (32-bit or 64-bit) to open the "ODBC Data Source Administrator" application.

      odbc0.jpg
       
    4. On the "System DSN" tab of the "ODBC Data Source Administrator" application, select "VGER" and click the "Configure" button.

      odbc2.jpg
       
    5. In the "Oracle ODBC Driver Configuration" window enter "VGER" for both the Data Source Name and the TNS Service Name.
    6. Enter your Read-Only user name (e.g., ro_xxxdb) for the User ID.
    7. Click the "Test Connection" button.

      odbc3.jpg
       
    8. In the "Oracle ODBC Driver Connect" screen make sure your "Service Name" is VGER.
    9. Enter your Read-Only User Name and its Password.
    10. Click the "OK" button.

      odbc4.jpg
       
    11. You will see "Connection successful" returned if your connection configuration is correct.


      odbc5.jpg

     

     


    • Article last edited: 21-Feb-2020
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Is there an easy way of finding when an operator last logged into Voyager?
      • Is there an inventory program for Voyager?
    • 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