SAP Knowledge Base Article - Public

2682852 - Microsoft ODBC 17 for SQL Server support for Crystal Reports, BusinessObjects Enterprise and Crystal Reports Developer for Visual Studio

Symptom

  • Is Microsoft ODBC 17 for SQL Server driver supported?
  • When using the Microsoft ODBC 17 for SQL Server driver Crystal Reports may generate an error or some data types may not be displayed

Environment

  • SAP Crystal Reports 2016
  • SAP BusinessObjects Business Intelligence Platform 4.2
  • SAP Crystal Reports developer for Visual Studio
  • Microsoft ODBC Driver 17 for SQL Server (Version: 2017.171.00.01 (17.1.0.1), MSODBCSQL17.DLL,  Date: 4/3/2018)

Cause

Microsoft ODBC driver (MSSQLODBC17.dll) got renamed which results in Crystal Reports Designer not recognizing it and thus generating incorrect Syntax to use.

Resolution

SAP BI products started support for Microsoft ODBC 17 for SQL Server driver in the following releases:

  • SAP Crystal Reports 2013 SP 12
  • SAP Crystal Reports 2016 SP 06
  • SAP Crystal Reports Developer for Visual Studio SP 24
  • SAP BusinessObjects Business Intelligence Platform 4.1 SP 12
  • SAP BusinessObjects Business Intelligence Platform 4.2 SP 06

See Also

https://www.microsoft.com/en-us/download/details.aspx?id=56567

Keywords

ODBC 17, CRD, CR for VS , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-RA-CR-DB , Database and Data Connection , Product Enhancement

Product

SAP Crystal Reports 2016