My Oracle Support Banner

ODBC Layer Error: [S1000] ==> [[DataDirect][ODBC Oracle Wire Protocol driver]Cannot open TNS Names file] (Doc ID 1597656.1)

Last updated on APRIL 06, 2018

Applies to:

Hyperion Essbase - Version 9.3.1.0.00 to 11.1.2.4.014 [Release 9.3 to 11.1]
Linux x86-64

Symptoms

While Connecting to SQL Database from EAS Console it throws below error:

[Mon Nov  4 11:35:56 2013]Local/application/database/710542@Native Directory/7457/Info(1021006)
SELECT Statement [SELECT * FROM STG_HRMS] is generated

[Mon Nov  4 11:35:56 2013]Local/application/database/710542@Native Directory/7457/Info(1021013)
ODBC Layer Error: [S1000] ==> [[DataDirect][ODBC Oracle Wire Protocol driver]Cannot open TNS Names file.]

[Mon Nov  4 11:35:56 2013]Local/application/database/710542@Native Directory/7457/Info(1021014)
ODBC Layer Error: Native Error code [0]

[Mon Nov  4 11:35:56 2013]Local/application/database/710542@Native Directory/7457/Error(1021001)
Failed to Establish Connection With SQL Database Server.  See log for more information

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.