Solved

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

Posted on 2015-02-19
9
181 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 76

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 76

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
 

Accepted Solution

by:
PBIT earned 0 total points
ID: 40619300
MS Office 2010 installed is 64 bit.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

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

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 76

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 37

Assisted Solution

by:Gerwin Jansen
Gerwin Jansen 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now