Avatar of altonyoung
altonyoung asked on

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.
Oracle Database

Avatar of undefined
Last Comment
altonyoung

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
altonyoung

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

>>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.
ASKER
altonyoung

I downloaded 11g 32-bit client.  I see tnsnames show up in ODBC configuration page.   Thanks.
Your help has saved me hundreds of hours of internet surfing.
fblack61