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

Symptom

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 '-'.

Environment

SAP HANA Smart Data Access

Product

SAP HANA 1.0, platform edition

Keywords

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 for Me (Login required).

Search for additional results

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