ODBC Error Ora-12154

[Soni]

Hello, I need to set up an ODBC drive for access to the bank.
is giving error

Select all

ORA-12154:TNS:não foi possível resolver o identificador de conexão especificado.

and I can access SQL Navigator or the same transname in the client

Someone has a idea of ??what can be occurring wrong
and use the same navigator data in the driver conf

[diegolenhardt]

Are you using InstantClient? Normal client10g? What installation option?
Windows XP, Seven? x86, x64?

¬¬

[Soni]

Ola Diegolenhardt
client10g with WinXP

So ... with SQL Navigator access without problem

But precise ODBC access to make reverse how is the. To get the ER model the base has 90 (ninety) tables.

In the client10g has transnames, listener and sqlnet

[diegolenhardt]

Already solved?

Searches for tnnames.ora Throughout your machine,

looks at the Regedit in

Select all

HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE

See if it has more than an Oracle_Home,
Listener.ORA does not care, only tnsnames.ora, take a test through SQLPlus,

99]] For example:

Select all

C:\oracle\client10g\network\admin\tnsnames.ora

If the path of his tnsnames were thus

Call the SQLPlus that is within that path:

Select all

C:\oracle\client10g\bin\sqlplus.exe usuario/senha@base

Post the results.