Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-231

ODBC Error 0000 in SSIS with longtext

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.1.0
    • Fix Version/s: 2.0.19, 3.0.9, 3.1.1
    • Component/s: General
    • Labels:
      None
    • Environment:
      Windows Server 2012 R2 x64
      Latest Visual Studio Data Tools

      Description

      When using an the MariaDB ODBC driver within an SSIS Package to push data to a table with a longtext column I receive the following error:

      [Destination - ALLERGY_COMMENT [2]] Error: There was an error while trying to get schema information. state: '00000'. Native Error Code: 0. [ma-3.1.0][10.3.11-MariaDB-log]

      The DDL for the destination table (in MariaDB) is included below.
      Also attached is the ODBC Trace from the Windows ODBC trace. I wasn't able to generate a trace from the MariaDB file. The MySQL ODBC driver seems to work if I swap it out instead.

      CREATE TABLE `allergy_comment` (
      `ALLERGY_COMMENT_ID` double NOT NULL,
      `ALLERGY_INSTANCE_ID` double NOT NULL,
      `ALLERGY_ID` double NOT NULL,
      `COMMENT_DT_TM` datetime DEFAULT NULL,
      `COMMENT_PRSNL_ID` double NOT NULL,
      `ALLERGY_COMMENT` longtext DEFAULT NULL,
      `ACTIVE_IND` double DEFAULT NULL,
      `ACTIVE_STATUS_CD` double NOT NULL,
      `ACTIVE_STATUS_DT_TM` datetime DEFAULT NULL,
      `ACTIVE_STATUS_PRSNL_ID` double NOT NULL,
      `BEG_EFFECTIVE_DT_TM` datetime NOT NULL,
      `END_EFFECTIVE_DT_TM` datetime NOT NULL,
      `CONTRIBUTOR_SYSTEM_CD` double NOT NULL,
      `DATA_STATUS_CD` double NOT NULL,
      `DATA_STATUS_DT_TM` datetime DEFAULT NULL,
      `DATA_STATUS_PRSNL_ID` double NOT NULL,
      `UPDT_APPLCTX` double NOT NULL,
      `UPDT_CNT` double NOT NULL,
      `UPDT_DT_TM` datetime NOT NULL,
      `UPDT_ID` double NOT NULL,
      `UPDT_TASK` double NOT NULL,
      `COMMENT_TZ` double DEFAULT NULL,
      `BEG_EFFECTIVE_TZ` double DEFAULT NULL,
      `CMB_COMMENT_ID` double NOT NULL,
      `CMB_PRSNL_ID` double NOT NULL,
      `CMB_PERSON_ID` double NOT NULL,
      `CMB_DT_TM` datetime DEFAULT NULL,
      `CMB_TZ` double DEFAULT NULL,
      `CMB_FLAG` double NOT NULL,
      `LAST_UTC_TS` timestamp(6) NULL DEFAULT NULL,
      `Audit_CreateJobId` bigint(20) DEFAULT NULL,
      `Audit_CreateDate` timestamp NOT NULL DEFAULT current_timestamp(),
      `Audit_UpdateJobId` bigint(20) DEFAULT NULL,
      `Audit_UpdateDate` timestamp NULL DEFAULT NULL,
      `Audit_Deleted` bit(1) NOT NULL DEFAULT b'0',
      `Audit_DeleteJobId` bigint(20) DEFAULT NULL,
      `Audit_DeletedDate` timestamp NULL DEFAULT NULL,
      `Audit_ValidFrom` timestamp NULL DEFAULT NULL,
      `Audit_ValidUntil` timestamp NULL DEFAULT NULL,
      PRIMARY KEY (`ALLERGY_COMMENT_ID`),
      KEY `ALLERGY_COMMENT_XIF2ALLERGY_COMMENT` (`ALLERGY_ID`),
      KEY `ALLERGY_COMMENT_XIF6ALLERGY_COMMENT` (`ALLERGY_INSTANCE_ID`)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1

        Attachments

        1. maodbc.dll
          1.80 MB
        2. SQL.LOG
          18 kB

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            godwinpe Peter Godwin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration