IBM Support

IBM SPSS Modeler produces, Incorrect Syntax near column...

Troubleshooting


Problem

Running a stream produces the below error. No results are returned. - 37000[102]DataDirectODBC SQL Server Driver incorrect Syntax near column - SQL Validation Error: 42000[102] [DataDirect][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'xxxx'

Cause

How Modeler reads/executes SQL statements changed from Version 12. Modeler automatically includes double-quote marks (" ") to identify tables and variables/fields.

Resolving The Problem

Within Windows MS ODBC Administrator defined Data Source Name(DSN) ensure that 'Enable Quote Identifiers' is checked. This setting may exist under an 'Advanced' tab.

For non-Windows installation, edit the odbc.ini file (for the DSN you are using) to read:
EnabledQuoteIdentifiers=1
If there is a line as follows:
QuotedID=0
then remove it from the DSN section of the odbc.ini file.

Restart the Modeler Server.

[{"Product":{"code":"SS3RA7","label":"IBM SPSS Modeler"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Modeler","Platform":[{"code":"PF033","label":"Windows"}],"Version":"16.0;15.0;14.2;14.1;14.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

74130

Document Information

Modified date:
16 June 2018

UID

swg21479147

Page Feedback