Troubleshooting
Problem
I am running a Clementine Server using Clementine 12.0.2 or above using the SQL Server Wire Protocol Driver on a UNIX platform. When I run a stream that creates a table and inserts data into it, where one of my columns is called "Index" I get the following error: 37000[1018] [DataDirect][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.= Why is this?
Resolving The Problem
By default the SPSS OEM SQL Server Wire Protocol Driver will not quote table and column names. To enable this in the SPSS OEM SQL Server Wire Protocol ODBC driver, change the "QuotedId=No" parameter in the DSN definition in the odbc.ini to "QuotedId=Yes", then save the odbc.ini and reconnect from Clementine. The table and column names in the create table statement should then be quoted and you should not see this eror on table creation
Related Information
Historical Number
79530
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21482091