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. VGER missing as a DSN when linking tables

    VGER missing as a DSN when linking tables

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Problem symptoms
    2. Cause
    3. Resolution
    • Product: Voyager
    • Product Version: 9.1
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

    Problem symptoms

    VGER does not appear as a DSN option in Access > External Data > ODBC Database > Link to the Data Source > Select Data Source > Machine Data Source tab

    Cause

    This may occur if the ODBC installation fails to add the VGER DSN

    Resolution

    1. Open the C:\Voyager\Access Reports\Reports.mdb file in Access
    2. Click External Data > ODBC Database
    3. Click Link to the data source by creating a linked table
    4. Click Machine Data Source tab > New...
    5. In the pop-up Create New Data Source window, click System Data Source > Next...
    6. Select Microsoft ODBC for Oracle from the list of drivers
    7. Click Finish
    8. In the Microsoft ODBC for Oracle Setup pop-up window, enter the following then click OK:

    Data Source Name: VGER

    Description: tables

    User Name: ro_xxxdb

    Server: VGER

     


    Article last updated: 27-Sep-2019

    View article in the Exlibris Knowledge Center
    1. Back to top
      • Vendor Account specified in import rule not added to order during import
      • Viewing Holdings Information Loses Checkbox Information
    • 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