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