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:
- Verify the correct read only username and password for oracle and change the username/password for the VGER Data Source to match.
- 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