SAP Knowledge Base Article - Preview

3018712 - Database Connector Error: "HY000:[SAP Crystal reports] Database Vendor Code: 102]" when refreshing a report based on MS SQL Server in Crystal Reports

Symptom

  • Error refreshing a report based on SQL Server.
  • When refreshing a report based on MS SQL Server in Crystal Reports, it fails with the error:
       
       "Database Connector Error: "HY000:[SAP Crystal Reports][ODBC SQL Server Wire Protocol driver][Microsoft SQL server]
        Incorrect syntax near the keyword '<Table Name>'. [Database Vendor Code: 102 ]"


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
        
  • MS SQL Server

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , 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.