ODBC Connection error message

Technote (troubleshooting)


Problem(Abstract)

Connection Failed: Error: [DataDirect][ODBC Oracle Wire Protocol driver]ServerName cannot be used with HostName, PortNumber, SID, or ServiceName.

Symptom

User is unable to view custom - or any other type of - report


Cause

The ODBC Data Source Name reference in odbc.ini is identical to the SID value entry

Environment

Netcool Reporter running on Linux, connecting to Oracle via ODBC.

Diagnosing the problem

Check the file $INFOHOME/odbc/odbc.ini file.

Resolving the problem

Change the ODBC Data Source Name references to a different value from the SID value.

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Netcool/Reporter

Software version:

2.2

Operating system(s):

Linux

Software edition:

All Editions

Reference #:

1507492

Modified date:

2013-07-18

Translate my page

Machine Translation

Content navigation