SAP Knowledge Base Article - Preview

3335149 - Error: "Incorrect syntax near the keyword 'CONVERT'..." when refreshing reports based on a MS SQL Server Stored Procedure with Date Time Parameter in Crystal Reports

Symptom

  • Error when refreshing reports based on MS SQL Server Stored Procedure with Date Parameters.
  • When refreshing reports based on MS SQL Server Stored Procedure with Date Time Parameters in Crystal Reports using an OLEDB Connection, it fails with the error:

        Database Connector Error: ADO Error Code: 0x80040e14
        Source: Microsoft OLE DB Driver 19 for SQL Server
        Description: Incorrect syntax near the keyword 'CONVERT'
        SQL State: 42000
        Native Error: 156 [Database Vendor Code: 156]


Read more...

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
       
  • MS SQL Server 2017
  • MS SQL Server 2019 

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

CR, SQL Server, OLE DB , 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.