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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Summary | Getting an error 'driver not capable' connect engine when reading Oracle date fields | Getting an error 'driver not capable' connect engine when reading Oracle datetime fields |
| 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 date field from the table, it all works. |
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. |
| Assignee | Anel Husakovic [ anel ] |
| Fix Version/s | 10.6 [ 24028 ] |
| Assignee | Anel Husakovic [ anel ] | Michael Widenius [ monty ] |