-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 10.2.16
-
Fix Version/s: 10.2
-
Component/s: Storage Engine - Connect
-
Labels:
-
Environment:CentOS 7
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.