SAP Knowledge Base Article - Preview

1503268 - Data Direct ODBC driver syntax error when connecting to SQL Server databases

Symptom

When using Data Direct ODBC driver on the UNIX platforms to connect to SQL Server, if the submitted SQL statement contains quotes around the object names, a syntax error is thrown by the driver:

[ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'FACT_CURUNIT'.>. The SQL submitted is <select count(*) from (select distinct a."FACT_CURUNIT" from "DBO"."MYCURR_FACT_TABLE" a left outer join "DBO"."MYCURR_TABLE" b on a."FACT_CURUNIT"=b."MYCURR" where b."MYCURR" is null ) c;


Read more...

Environment

Data Services

Product

SAP Data Services 4.0 ; SAP Data Services XI 3.2

Keywords

DS, DSXI, SQL, ODBC , KBA , EIM-DS , Data Services , How To

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.