For some of us whom frequently using MS Access in daily use, encountered an error might be very troublesome.
The problem is like this : I am using MS Access for data analysis and checking and have a connection over the network to Oracle database. My connection was using Microsoft ODBC Driver for Oracle. For some security reason, I need to change the password now. The password changed with no problem but encountered error ORA-12154 when trying to relink the tables.
Error as below:
Microsoft ODBC driver for ORacle ORA-12154: TNS could not resolve service name
Generally, ORA-12154 indicated that the specifying TNS alias is not resolving. Few questions needed to clarify;
- Are you using a DSN for your connection to Oracle database?
- If so, what is the TNS alias that you specifying?
- Does that alias exist in your tnsnames.ora file?
- Are there multiple tnsnames.ora files on your machine?
Your should have your tnsnames.ora file when you installing the Oracle client software/driver. If you wondering what is the version of the Oracle client you have installed, the simplest way is to get DOS command prompt and type ‘tnsping [service_name]’ where [service_name] is TNS alias specified in your DNS.
The ouput of it may look like this:
TNS Ping Utility for 64-bit Windows: Version 18.104.22.168.0 – Production on 07-OCT-2
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
The “Used parameter files” line shows you the directory where the TNS related files are stored. A tnsnames.ora and a sqlnet.ora file should be in that directory and it alwasys be there by default. Perhaps you should check the TNS alias name and confirm with your DNS setting.