Is crystal report 14.0 compatible with MSOLEDBSQL driver

[vikasm361]

i have few crystal report that are in version 14. Currently they are all using SQLOLEDB driver but when i change the driver to MSOLEDBSQL , the crystal reports no longer works. Can anyone tell what should i do to make the reports work with MSOLEDBSQL driver?

Crystal report version 14.0

MSOLEDBSQL Version - 17.0

[DellSC]

Which service pack of Crystal are you running? Version "14" could be anything from Crystal 2011 through Crystal 2020. Depending on the full version, the driver you're using may not be supported, but I need more info to be able to tell you for certain.

-Dell

[DonWilliams · Accepted solution]

See this Supported platforms:

https://wiki.scn.sap.com/wiki/display/BOBJ/SAP+Crystal+Reports+-+Supported+Platforms

Click on CR version you are using and then another link to download an Excel file with support MS SQL Clients.

If you are using CR version 14.0 you need to upgrade to the latest SP from here to be able to use recent MS SQL Clients:

https://origin.softwaredownloads.sap.com/public/site/index.html

[yogananda]

vikasm361

The best way to make sure that the Crystal Reports work with the MSOLEDBSQL driver is to make sure that the database is configured correctly. You may need to update the connection string in the Crystal Report to include the correct credentials and database information. You may also need to download the latest version of the MSOLEDBSQL driver and install it on the machine where the Crystal Reports are running.