ODBC Connection Not Working Getting 'Cannot read SQL driver name'
(Doc ID 1628580.1)
Last updated on MARCH 16, 2021
Applies to:
Hyperion Essbase - Version 11.1.2.2.100 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |