Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.5
-
None
-
Windows 10
Oracle 12
MariaDB 10.6.5
Description
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.