Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Access fails to add external data source: "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

    • Product: Voyager
    • Product Version: 9.1
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

    Symptoms

    When attempting to link to the VGER Data Source in MS Access, the following error occurs:
    ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

    Cause

    The username specified in the VGER Data Source is not correct.
     

    Resolution:

    1. Verify the correct read only username and password for oracle and change the username/password for the VGER Data Source to match.
    2. Continue following the procedure to add the external data source, and link tables outlined in the Oracle 10g ODBC Installation Guide

    Additional Information

    See What is the read only Oracle user and password for Voyager databases for the default user/pass

     


     

    Article last edited: 20-Jan-2017

    //doorbell.io feedback widged