Error code 193 connecting to Oracle Merant ODBC driver version 5 (Doc ID 876467.1)

Last updated on JANUARY 31, 2017

Applies to:

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 13-Feb-2014***

Symptoms

I have installed DAC 10.1.3.4.1 on a Win 2003 X64 6-4bit server. The install would not run and I found the bug details: 849658.1, for which I followed the workaround of installing the 32-bit version. However, since I did that the Oracle Merant ODBC version 5 driver did not appear in my ODBC settings.

In the Oracle BI Data Warehouse Administration Console Installation, Configuration, and Upgrade Guide (Page 3-1 to 3-2 pdf),  I found the registry settings for the ODBC were missing and so I added these manually using regedit, these were:

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle Merant
ODBC Driver]
"APILevel"="1"
"ColumnsAsChar"="1"
"ColumnSizeAsCharacter"="1"
"CPTimeout"="60"
"Driver"="$ORACLE_
HOME/bifoundation/dac/utilities/DataDirectODBC/seor820.dll"
"DriverODBCVer"="05.00"
"FileUsage"="0"
"Name"="Siebel Database"
"Setup"="$ORACLE_
HOME/bifoundation/dac/utilities/DataDirectODBC/seor820s.dll"
"SQLLevel"="1"
"UsageCount"=dword:00000001


and

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"Oracle Merant ODBC Driver"="Installed"

 Now I have added these the driver has become available and it shows the correct version details etc, however, when I attempt to set up the ODBC connection I get the errors:

First error:

The setup routines for the Oracle Merant ODBC Driver could not be loaded due to system error 193.

Click OK and get: 

Second error:

Could not load the setup or translator library.

Cause

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