ODBC configuration won't show tnsname using 11g client on Windows XP

altonyoung
altonyoung used Ask the Experts™
on
My first time working with Oracle.  I Installed 11g release 5 32bit client on a windows xp machine, but I can't get the tnsnames to appear on Microsoft ODBC administrator configuration page.  I did try putting the tnsname.ora file in Oracle_home or Oracle_Home\Admin folder, no luck.   Also, I can't find tnsping.exe anywhere on this XP machine.   Where can I download tnsping.exe for Windows XP?   Thank you very much in advance for your help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
The tnsnames.ora file goes in %ORACLE_HOME%/network/admin by default.

This file also follows a pretty strict format.  Did you manually edit it or use one of the configuration tools to create it or get one from your DBA?

>>Where can I download tnsping.exe for Windows XP?

It is not a separate download.  It is part of the regular client (not the instant client).  You need to select the utilities option as part of the install.

Author

Commented:
So I suppose 11g release 5 is not the standard client.  I will try to download the standard client and try it.  

I copied the tnsname.ora file from the server.  Will this work or do I must create one using the GUI come with standard client to create it?  

Thanks.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>So I suppose 11g release 5 is not the standard client.

As far as the database software goes, there is no release 5.  I'm not sure what you are referring to.  If you can provide a link to what you downloaded, I'll take a look.

Many Oracle product installers have the client built in.  It may be as simple as just selecting the utilities under the custom install.

>> I will try to download the standard client and try it.  

Before you just download and install another product, that will likely require a different oracle home, wait until I understand what 'release 5' is that you already have.

>>Will this work or

It should.

Author

Commented:
I downloaded 11g 32-bit client.  I see tnsnames show up in ODBC configuration page.   Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial