I have read through many postings on the ORA-12154 error and have fixed it a few times on various computers but can't figure this one out. Generally every time I seen this error in the past it has been related to either tns file issues or the DB server configuration.
This is happening on a couple Windows XP PCs within in a large network. When attempting to configure an ODBC connection using the Oracle drivers and testing the connection the error is returned. The tns file is in a network location where hundreds of other computers use the same tns file and use the same Oracle server so i know it is not related to the service name in the tns file or the database server.
Anyone have any ideas on what to look for in the registry or settings on the local PC?
Prefer not to uninstall and reinstall the local Oracle drivers as there is lot of red tape to go through on getting admin permissions on users’ desktops within the company I work for.
Thanks in advance for any ideas.