ODBC Connection Not Working Getting 'Cannot read SQL driver name'

(Doc ID 1628580.1)

Last updated on JANUARY 31, 2018

Applies to:

Hyperion Essbase - Version 11.1.2.2.100 and later
Information in this document applies to any platform.

Symptoms

On 11.1.2.2.100 version, SQL Interface
  

ODBC connection on Essbase server is not working. When trying to export data from Essbase using a dataexport command in a calc script the following error occurs:

[Sun Feb 2 10:40:06 2014]Local/FIN_Plan/PandL/admin@Native Directory/140092743493952/Info(1021020)
Cannot read SQL driver name for [Oracle Wire Protocol] from [/u01/Oracle/Middleware/user_projects/epmsystem4/EssbaseServer/essbaseserver1/bin/.odbc.ini]

[Sun Feb 2 10:40:06 2014]Local/FIN_Plan/PandL/admin@Native Directory/140092743493952/Info(1021004)
Connection String is generated

[Sun Feb 2 10:40:06 2014]Local/FIN_Plan/PandL/admin@Native Directory/140092743493952/Info(1021041)
Connection String is [DSN=ESSHYPODBC;UID=...;PWD=...;]

[Sun Feb 2 10:40:06 2014]Local/FIN_Plan/PandL/admin@Native Directory/140092743493952/Info(1021013)
ODBC Layer Error: [28000] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied]

[Sun Feb 2 10:40:06 2014]Local/FIN_Plan/PandL/admin@Native Directory/140092743493952/Info(1021014)
ODBC Layer Error: Native Error code [1017]

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