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

CONNECT Engine's SRCDEF does not work with MS SQL 2016

    Details

      Description

      When trying to create a connect engine table with SRCDEF to a SQL Server 2016 source, it returns this error: "ERROR 1105 (HY000): Invalid Srcdef"

      CREATE TABLE `Party` ENGINE=CONNECT CONNECTION='DSN=sql_server2016;uid=username;pwd=password;TDS_Version=7.4' `TABLE_TYPE`='ODBC' `TABLE_TYPE`='ODBC' `SRCDEF`='SELECT * FROM dbo.Party' `BLOCK_SIZE`=1000;
      ERROR 1105 (HY000): Invalid Srcdef

      I had to use `TABNAME`='Party' instead to make this work.

      In a second environment I've successfully created a Connect table with a 2012 MS SQL server source with the exact same syntax above and SRCDEF above. Seems to be specific to the MS SQL Server version.

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              ksizemor Kathryn Sizemore
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: