Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27755

Getting an error 'driver not capable' connect engine when reading Oracle datetime fields

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.6.5
    • Fix Version/s: 10.6
    • Labels:
      None
    • Environment:
      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

            People

            Assignee:
            monty Michael Widenius
            Reporter:
            arg187 Adrian
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.