Solved

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

Posted on 2015-02-19
9
188 Views
Last Modified: 2015-03-03
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.
0
Comment
Question by:PBIT
  • 4
  • 4
9 Comments
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 400 total points
ID: 40619233
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
 

Author Comment

by:PBIT
ID: 40619278
I have 64-bit Windows 8.1. Should I install the 64-bit drivers?
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 400 total points
ID: 40619290
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Accepted Solution

by:
PBIT earned 0 total points
ID: 40619300
MS Office 2010 installed is 64 bit.
0
 

Author Comment

by:PBIT
ID: 40619313
OK, I will install the 64-bit version.  Should I uninstall the 32 bit version?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40619314
>>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
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40619318
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
 
LVL 38

Assisted Solution

by:Gerwin Jansen, EE MVE
Gerwin Jansen, EE MVE earned 100 total points
ID: 40619481
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
 

Author Closing Comment

by:PBIT
ID: 40641612
I don't have my responses checked.  I don't know why its saying that I have this checked.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question