I have installed the connect engine and created a table that refers to a table in an Oracle DB :
CREATE OR REPLACE TABLE myvendortable
(
sid DECIMAL(19,0) NOT NULL,
sbs_sid DECIMAL(19,0),
vend_code VARCHAR(12),
active DECIMAL(1,0),
vend_name VARCHAR(50),
udf1_string VARCHAR(200),
udf2_string VARCHAR(200),
udf3_string VARCHAR(200),
udf4_string VARCHAR(200),
udf5_string VARCHAR(200),
udf6_string VARCHAR(200),
created_by VARCHAR(60),
created_datetime DATETIME
)
ENGINE=connect,
table_type=ODBC
tabname='RPS.VENDOR'
CONNECTION='DSN=prism;uid=myuid;pwd=mypwd';

When I try to SELECT * from this table, I get the following error :

SQL Error (1296): Got error 174 'SQLExecDirect:[Oracle][ODBC][Ora] Driver not capable' from CONNECT.

If I remove the datetime field from the table, it all works.