How to have Oracle ODBC Drivers show up in the ODBC Administrator?

Hello,

I have installed the Oracle Client 11g R2, but I don't see the Oracle drivers in the ODBC Administrator.  I am using Windows 8.1 and link to use the drivers with Excel to connect to an Oracle database.
PBITAsked:
Who is Participating?
 
PBITConnect With a Mentor Author Commented:
MS Office 2010 installed is 64 bit.
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Did you select the ODBC drivers when you ran the install?  They typically aren't installed by default.  Rerun the installer and make sure you select the ODBC drivers.

Once the install has been verified:
Are you running 64Bit Windows?

There are two Bit versions of ODBC admin:
http://support.microsoft.com/kb/942976

Make sure the Oracle Bit version matches what you need and run the correct ODBC Admin.
0
 
PBITAuthor Commented:
I have 64-bit Windows 8.1. Should I install the 64-bit drivers?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
You need to match the bitness of the drivers with the bitness of the apps using them.

Is your Excel 32Bit or 64Bit?  That will decide what bitness of drivers you need.
0
 
PBITAuthor Commented:
OK, I will install the 64-bit version.  Should I uninstall the 32 bit version?
0
 
slightwv (䄆 Netminder) Commented:
>>Should I uninstall the 32 bit version?

That choice is up to you.

You don't have to.  Something may need it someday and it will already be there.
0
 
slightwv (䄆 Netminder) Commented:
Also:
Since you only mention Excel and ODBC, check out the Instant Client.

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

You'll need two downloads:
Instant Client Package - Basic
Instant Client Package - ODBC

Unzip both to the same folder and there should be a BAT installer for the ODBC drivers.
You will also need to manually create the network\admin folder and place a sqlnet.ora and tnsnames.oa file in there if you are using TNS naming.
0
 
Gerwin Jansen, EE MVEConnect With a Mentor Topic Advisor Commented:
You probably have a 64 bit OS, there are 2 ODBC administrators on your system. One in c:\windows\system32 and the other in c:\windows\syswow64 - if you start the latter one you will probably see the driver you think is missing (but it isn't). The one in c:\windows\system32 is showing you the 64bit drivers.

<edit>

The MS article above is already pointing to 2 ODBC administrators - missed that ;)
0
 
PBITAuthor Commented:
I don't have my responses checked.  I don't know why its saying that I have this checked.
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.