Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2015-02-19
9
Medium Priority
?
196 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1600 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 1600 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
Technology Partners: 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 400 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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

609 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