Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How do I use the oracle odbc in windows server 2008

Posted on 2013-11-27
2
Medium Priority
?
518 Views
Last Modified: 2013-12-03
I installed ORacle 11g client. I selected the administrator option. When I look at Oracle installed products I see the Oracle ODBC driver. However, When I click on the ODBC data source icon the ODBC Data Source Administrator window opens. When I select Add nothing appears in the Create New Data Source dialog box. I've tried every option I can think of to get access to the Oracle odbc driver. I created the tnsnames.ora file and I am able to connect to a remote database as well as tnsping that service. However, I can't seem to add the Oracle odbc so that other applications can access that database. What am I doing wrong. All the instructions read that I should see the Oracle odbc in the System DSN. However, I don't. what can I do to try to fix this?
0
Comment
Question by:sikyala
[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
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39682227
Windows 64Bit?

There are two ODBC administrators in 64Bit windows.  Make sure you are using the right one for the bit version of the Oracle client you installed.

http://support.microsoft.com/kb/942976

    The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
    The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.
0
 

Author Closing Comment

by:sikyala
ID: 39693160
ok
0

Featured Post

Industry Leaders: 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!

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

704 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