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

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.
altonyoungAsked:
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.

slightwv (䄆 Netminder) 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.
0

Experts Exchange Solution brought to you by

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
altonyoungAuthor 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.
0
slightwv (䄆 Netminder) 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.
0
altonyoungAuthor Commented:
I downloaded 11g 32-bit client.  I see tnsnames show up in ODBC configuration page.   Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

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.