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

            bertrandop Olivier Bertrand
            ksizemor Kathryn Sizemore
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.