SAP Knowledge Base Article - Preview

1754876 - DataDirect ODBC SQL Server Driver: Incorrect syntax near '<column_name>' - Data Services

Symptom

  • DataDirect ODBC
  • When executing a SQL statement and double quotes are used for identifiers (such as column name), the error occurs. For example, select "table"."column" from "table".
  • SQL submitted to ODBC data source <datasource_name> resulted in error <[SAP BusinessObjects][ODBC SQL Server Driver][SQL Server] Incorrect syntax near 'column'.>.


Read more...

Environment

  • Linux or Unix
  • Data Services
  • Microsoft SQL Server

Product

SAP Data Services 4.0 ; SAP Data Services XI 3.2

Keywords

ds,datadirect,odbc,double quotation marks,sql server , KBA , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.