BorlandTalk.com

Kevin · Guest

I have been running the posted query on a Windows 2000 Citrix server
for a few years. Recently the server was upgraded to a Windows 2003
server and the query is now throwing a "Data type is not supported"
exception. Here is what I know:

- the database is Oracle 8.1.7
- the connection is ADO (2.7 on Windows 2000, 2.8 on Windows 2003)
- the query only fails if the client app is run directly on the 2003
server. Windows 2000 server still works fine.
- the query DOES NOT fail if run in a COM server on the same 2003 server
- the query DOES NOT fail if the ReadOnly property of the TADOQuery is
set to True.
- if I set the connection to MSDASQL using the Oracle ODBC driver, the
query does not fail.
- when I trace the SQL being sent from the app to the database, I
noticed additional SQL appended to the end if the columns list. The
additional SQL is "ba.ROWID, v.ROWID, l.ROWID, epc.ROWID, codes.ROWID,
vo.ROWID, cc.ROWID ". If I add a -- directly after cc.description, the
exception is not thrown.

Does anyone have any suggestions, tips or know of any fixes?

Thanks,
Kevin

select ba.legal_name
,v.invc_num, v.invc_date
,l.cc_num, l.LI_AMT, l.major_acct, l.minor_Acct
,epc.account, epc.description
,codes.code_desc
,ba.id as "BA_ID"
,vo.voucher_num
,cc.description
from business_associates@fin ba
,invoices@fin v
,line_items@fin l
,ep_accounts epc
,codes@fin codes
,vouchers@fin vo
,ep_Base_cc cc
where v.client_id = ba.id
and l.VOUCHER_ID = v.voucher_id
and epc.major_acct = l.major_Acct
and codes.code = epc.class_code
and vo.voucher_id = v.voucher_id
and cc.cost_center_id = l.cc_num