Hi Everyone,
I am trying to test my ADB in designer. It's connecting to an Oracle XE database. I have tried both the Oracle and the TIBCO/DataDirect driver and no luck.
When I run the ADB through the adapter tester I get the following:
****************the sulotion: Verify the DSN optional feature..in advanced . check the .(enable n_char support ) optional selected..
=====================================================
adb.rvAdvisoryNoLog: off
adb.setClientInfo: on
2011 Sep 30 15:27:08:906 GMT +8 INFMASTER1.INFMASTER1 Info [Adapter] AEADB_700401
SubMainThread: Start services INFMASTER1_SUB
2011 Sep 30 15:27:12:156 GMT +8 INFMASTER1.INFMASTER1 Info [Adapter] AEADB-700094
Polling timer fired.
2011 Sep 30 15:27:12:171 GMT +8 INFMASTER1.INFMASTER1 Info [Adapter] AEADB-700001
Publisher: SQL: SELECT * FROM ADB_TIENS1.P_TS_GLOBAL_DIS_INFMASTER WHERE ADB_L_DELIVERY_STATUS = 'N' ORDER BY ADB_SEQUENCE
2011 Sep 30 15:27:12:171 GMT +8 INFMASTER1.INFMASTER1 Error [Database] AEADB-100004
DBError: Database driver code: HYC00
Database server code: 0
Database driver message: [Data Direct][ODBC Oracle Wire Protocol driver]Optional feature not implemented.
2011 Sep 30 15:27:12:171 GMT +8 INFMASTER1.INFMASTER1 Error [Database] AEADB-930002
Publication error. Publication service INFMASTER1_PUB with publication subject ADB.INFMASTER encountered database error: