SAP Knowledge Base Article - Preview

2239497 - "Incorrect syntax near '-'" connecting to MSSQL using HANA Smart Data Access


When using HANA Smart Data Access connected to a Microsoft SQL Server database, which contains a hyphen (-) in the database name, and attempting to display the content of a virtual table you receive the error:

Error: SAP DBTech JDBC: [403]: internal error: Error opening the cursor for the remote database 
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near '-'. for query....

An error similar to the below can also be found in the indexserver trace file:

[110868]{306695}[43/-1] 2015-08-21 14:51:57.758396 e FedTrace         
odbcaccess.cpp(03752) : ODBC error: connected: 1 state: 42000 code: 102 [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near '-'.



SAP HANA Smart Data Access


SAP HANA 1.0, platform edition


SDA, dash, property_mss.ini, CAP_CAN_QUOTE_DBNAME , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem

About this page

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

Search for additional results

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