TIBCO Adapter for ActiveDatabase returns the error ‘[Data Direct][ODBC Oracle Wire Protocol driver]Optional feature not implemented’

TIBCO Adapter for ActiveDatabase returns the error ‘[Data Direct][ODBC Oracle Wire Protocol driver]Optional feature not implemented’

book

Article ID: KB0088408

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Resolution:
Description
---------------
TIBCO Adapter for ActiveDatabase on start up returns the error ‘[Data Direct][ODBC Oracle Wire Protocol driver]Optional feature not implemented’

Environment
----------------
All

Symptoms
-------------
Adapter logs show the error ‘[Data Direct][ODBC Oracle Wire Protocol driver]Optional feature not implemented’

Cause:

From ADB 5.4.0 version onwards,there includes a new feature for Enhanced Timestamp Information for Oracle Database

Resolution:
-------------
For Windows:

1)Goto Control Panel-&gtAdministrative Tools-> Data Source (ODBC).
2)Click on the Systems tab and select the DSN name configured for your database and click Configure.
3)Goto Advanced tab in the ODBC Oracle Wire Protocol Driver Setup window.
4)Check the Enable Timestamp with Timezone options. Click Apply and OK.

For Unix:

1)Goto odbc.ini file.
2)Set EnableTimestampWithTimeZone to 1.

Issue/Introduction

TIBCO Adapter for ActiveDatabase returns the error ‘[Data Direct][ODBC Oracle Wire Protocol driver]Optional feature not implemented’