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

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

    • 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).
    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