How to Configure ODBC Driver for OBIEE on Windows 2003 64bit Operating System (Doc ID 1179373.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.1 [1900] and later
Business Intelligence Server Enterprise Edition - Version 10.1.3.4.1 [1900] and later
Information in this document applies to any platform.
***Checked for relevance on 06-Nov-2013***

Goal

How can you configure ODBC Driver for OBIEE on Windows 2003 64bit Operating System?

64-bit Windows has two ODBC Data Source admin utilities.  The default is found in the Windows\system32 folder, the other (same named of .exe) is found in the Windows\SysWOW64 folder; these two utilities manage distinct sets of DSNs and ODBC drivers. They use different registry sections.

The OBIEE BI Administration Tool uses the ODBC DSNs that are managed by the one in Windows\SysWOW64 folder.

Installing the Oracle 10g Client (either 32-bit or 64-bit) on a Windows x64 server creates an ODBC driver that is seen by the first one in Windows\system32, but not the second one Windows\SysWOW64 folder.


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms