ORA-00911 when using Oracle 8.0.05 odbc driver.

[UCM]

I am getting ORA-00911 when I run the following select statement using Oracle ODBC dirver. Same query works fine when using Microsoft ODBC driver for Oracle.

ODBC trace
LinkMax:1024 124-12b ENTER SQLExecDirectW
HSTMT 008F3DA8
WCHAR * 0x00A0C53C [ -3] &quot;SELECT CT_ACCT_ENTRY_DENORM.hh_num, CT_ACCT_ENTRY_DENORM.account_new, prod_code, CT_ACCT_ENTRY_DENORM.account_new , CT_ACCT_ENTRY_DENORM.hh_num FROM CT_ACCT_ENTRY_DENORM WHERE hh_num >= 1 AND hh_num <= 200001 ORDER BY CT_ACCT_ENTRY_DENORM.hh_num, CT_ACCT_ENTRY_DENORM.account_new\ 0&quot;
SDWORD -3

LinkMax:1024 124-12b ENTER SQLExecDirect
HSTMT 008F3DA8
UCHAR * 0x030F0E60 [ 280] &quot;SELECT CT_ACCT_ENTRY_DENORM.hh_num, CT_ACCT_ENTRY_DENORM.account_new, prod_code, CT_ACCT_ENTRY_DENORM.account_new , CT_ACCT_ENTRY_DENORM.hh_num FROM CT_ACCT_ENTRY_DENORM WHERE hh_num >= 1 AND hh_num <= 200001 ORDER BY CT_ACCT_ENTRY_DENORM.hh_num, CT_ACCT_ENTRY_DENORM.account_new&quot;
SDWORD 280

LinkMax:1024 124-12b EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 008F3DA8
UCHAR * 0x030F0E60 [ 280] &quot;SELECT CT_ACCT_ENTRY_DENORM.hh_num, CT_ACCT_ENTRY_DENORM.account_new, prod_code, CT_ACCT_ENTRY_DENORM.account_new , CT_ACCT_ENTRY_DENORM.hh_num FROM CT_ACCT_ENTRY_DENORM WHERE hh_num >= 1 AND hh_num <= 200001 ORDER BY CT_ACCT_ENTRY_DENORM.hh_num, CT_ACCT_ENTRY_DENORM.account_ne\ff&quot;
SDWORD 280

DIAG [S1000] [Oracle][ODBC][Ora]ORA-00911: invalid character
(911)

LinkMax:1024 124-12b EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 008F3DA8
WCHAR * 0x00A0C53C [ -3] &quot;SELECT CT_ACCT_ENTRY_DENORM.hh_num, CT_ACCT_ENTRY_DENORM.account_new, prod_code, CT_ACCT_ENTRY_DENORM.account_new , CT_ACCT_ENTRY_DENORM.hh_num FROM CT_ACCT_ENTRY_DENORM WHERE hh_num >= 1 AND hh_num <= 200001 ORDER BY CT_ACCT_ENTRY_DENORM.hh_num, CT_ACCT_ENTRY_DENORM.account_new\ 0&quot;
SDWORD -3

DIAG [S1000] [Oracle][ODBC][Ora]ORA-00911: invalid character
(911)


Thanks.
UCM