On Oct 1, 4:14 pm, Vlad <[email protected]> wrote:
> I have an oracle 10g database that I can connect to fine using SQL
> plus from an oracle 10g client on another pc. When I try to create an
> ODBC connection that uses the 10g client - I get the following error:-
>
> SQLState=08004 [Oracle][ODBC][Ora]ORA-12154: TNS: could not resolve
> the connect identifier specified
>
> Since I can tns ping succesfully - I'm confused by the above message.
> It appears to be a local issue as I can connect using identical odbc
> connection specifics on another pc.
>
> Any pointers would be great - I'm getting stuck :-(
Check the value in the registry for TNS_ADMIN on the suspect PC, and
also check to see that you are using the 10g ODBC driver and not one
from an older installation. The error points to a tnsnames.ora file
which does not contain the desired entry; have you checked for
multiple tnsnames.ora files on this PC?
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
