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

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

    XMLWordPrintable

    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: