[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

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.
0
PBIT
Asked:
PBIT
  • 4
  • 4
4 Solutions
 
slightwv (䄆 Netminder) 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
 
slightwv (䄆 Netminder) 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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
PBITAuthor Commented:
MS Office 2010 installed is 64 bit.
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 MVETopic 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now