Link to home
Start Free TrialLog in
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.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of altonyoung
altonyoung

ASKER

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.
>>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.
I downloaded 11g 32-bit client.  I see tnsnames show up in ODBC configuration page.   Thanks.