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

    Relink Prepackaged Reports after Upgrade

    • Article Type: Q&A
    • Product: Voyager
    • Product Version: All
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

    Question

    How to relink Prepackaged reports (Reports.mdb) after a Voyager upgrade? (If you migrated to new server hardware please see "Additional Information" at the bottom of this Article).

    Answer

    These steps assume you previously installed and configured ODBC as per these instructions: Installation and Configuration of ODBC for Voyager 

    1. Open Reports.mdb
    2. For Access 2007, 2010: Under External Data > ODBC Databases, select "Link to the data source by creating a linked table" and click OK.
    3. Select Data Source box opens; click Machine Data Source tab
    4. Click VGER.
    5. Click OK.
    6. Enter read-only username and password for your database instance and click OK.
    7. Link Tables box opens; click Deselect All. This step may take some time to complete.
    8. Click OK
    9. Under Forms, double-click Build database links to Voyager.
    10. Fill in the form:
    ODBC Name: VGER
    Connect string: VGER
    DB User ID: {read-only user for your database instance}
    Password: {read-only password for your database instance}
    Tablespace: {name of your database instance}
    Tablespace will likely need to be all caps
    1. Ensure Relink checkbox is checked
    2. Click Connect.
    Database tables will link; this may take anywhere from several minutes to several hours. For every successfully linked table, this message will display:
    {table name} linked successfully!
    1. To identify any tables that were not linked, run the "System Access Tables NOT Linked" query.

    Additional Information

    These steps assume that ODBC drivers were installed prior to the upgrade.  

    If you migrated to a new server and the server's IP address changed, you will need to edit the tnsnames.ora file on your workstation. 

    See the Overview of version requirements for Voyager ODBC drivers for information about Voyager version compatibility considerations and which ODBC drivers you should install.

     

     

     


    • Article last edited: 27-Sep-2019