ODBC Oracle Connection 10g

[Pomps]

Good morning
I'm trying to make an ODBC connection from Oracle Client 10g, but the error is or-12154: TNS: Could not resolve the invalid connection identifier!
From what I'vê read, you have to set up the tnnames.ora file! I made the file here with the host and the door .. but I do not know where to put it inside the installation part!
say it's along with TNS_ADMIN, but I did not find him too!

Sera q How can you help me?

Thank you ..!

[victorhugomuniz]

TNS_ADMIN is a variable environment that some use to set the site of tnsnames.ora .. but it is not necessary

you should put your file in a path similar to this

Select all

\ora92\network\ADMIN

mine and so oh

Select all

C:\oracle\ora92\network\ADMIN

[diegolenhardt]

It is not necessary to configure this variable, when the Oracle Client is used, it is only required with the Instant Client,

see if you can connect to the server through:

Telnet IP 1521 (usually the port), to see if you have connectivity first,

then test with SQLPlus,

You installed the client or instant client, more details ..

[Pomps]

Hello Diegolenhardt.

I installed Xeclient ..
by SQL Plus connects beauty service ..

Select all

system/******@192.168.4.50:1521/xe

But in ODBC does not recognize any service TNS ...
and error! ..

I have to find out which folder goes the tnnames.ora file to try to make the connection ..

[Pomps]

Hello Victorhugomuniz

has no way similar to this!
Sera that if you create can work?

would create the Network and Admin folder !!
because it does not have any related folder!
Playing the tnsnames.ora file inside the folder!

Here maybe it would be:

Select all

C:\XEClient\Network\admin

[diegolenhardt]

UHM never used this xeclient,

TRIES SQLPLUS SYSTEM @ XE

See if password asks,

[diegolenhardt]

Dude, now a question arose, why do you want to create an ODBC?

BDE?

[Pomps]

Is that I am creating a data source and I will need to import information from OurTa data source!

[diegolenhardt]

Well, to solve the problem I suggest:

1 - Install the Oracle 10G / 11G client, with the administrator option (which is the most complete) that will not miss any library (DLL) ,

a test that you can do with this clientxe is to try to put the clientxe directory in the PATH environment variable, and still create a variable Oracle_Home environment by pointing it to the clientxe directory , and one more, TNS_ADMIN, pointing it to the directory wherever you want, as long as you have tnnames.ora,

[Pomps]

Good morning Diegolenhardt ..
I solved the problem! .. I just created the Network and Admin folders and threw the archway inside and worked out!
But I had already tried add to Path!

Thanks for the help of you!

Thanks