oracle driver

Hi All,

I am trying to setup a odbc connection for oracle server my tnsnames.ora which is in C:\app\oracle\product\11.2.0\client_1\Network\Admin
and here is the connection settings
ORA11 =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(Host = 10.1.100.113)(Port = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = ADVA)
 )
)

when i am trying to setup i am under odbc
i am tring to enter
datasource name: history
tns service name10.1.100.113
username: $username
and click on test connection
service name: AVDA
username: $username
password:$password

i am getting an error saying
ORA-12154: TNS:could not resolve the connect identifier specified.

can someone help me please.
romeiovasuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
johnsoneSenior Oracle DBACommented:
For TNS service name, you should use ORA11.  That is the name of the entry in your tnsnames.ora file.
0
 
romeiovasuAuthor Commented:
it doesnt work if i use ORA11

but if i type 10.1.100.113/ADVA then it works.
0
 
slightwv (䄆 Netminder) Commented:
>>my tnsnames.ora which is in C:\app\oracle\product\11.2.0\client_1\Network\Admin

Are you using the ODBC drivers installed under C:\app\oracle\product\11.2.0\client_1?
In other words: Do you only have the one Oracle product installed on the machine?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
DavidSenior Oracle Database AdministratorCommented:
The lines following the first must be indented at least one space.
0
 
romeiovasuAuthor Commented:
i didnt understand.
0
 
slightwv (䄆 Netminder) Commented:
Didn't understand which post?
0
 
romeiovasuAuthor Commented:
by yours only.

>>my tnsnames.ora which is in C:\app\oracle\product\11.2.0\client_1\Network\Admin

Are you using the ODBC drivers installed under C:\app\oracle\product\11.2.0\client_1?
In other words: Do you only have the one Oracle product installed on the machine?
0
 
slightwv (䄆 Netminder) Commented:
I was asking if you had more than one set of Oracle drivers installed on the computer.

Did you download and install a separate ODBC driver in a different folder?
0
 
romeiovasuAuthor Commented:
no this is the only one we have.
0
 
slightwv (䄆 Netminder) Commented:
>>and click on test connection  service name: AVDA

Service name on test should be ORA11 as well.

That is the 'alias' specified in the tnsnames.ora file.  When using the tnsnames.ora file, you need to only reference the 'alias'.

>>but if i type 10.1.100.113/ADVA then it works.

This likely uses EZConnect and bypasses the tnsnames.ora file.
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
romeiovasuAuthor Commented:
how can i force to use ORA11 only.
0
 
slightwv (䄆 Netminder) Commented:
>>how can i force to use ORA11 only.

I don't think you can force connections to only use tnsnames and ignore EZConnect.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.