8

SAP CRYSTAL REPORT 2020 support ODBC DRIVER 18 FOR... - SAP Community

 1 year ago
source link: https://community.sap.com/t5/technology-q-a/sap-crystal-report-2020-support-odbc-driver-18-for-sql-server/qaq-p/13606018
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

SAP CRYSTAL REPORT 2020 support ODBC DRIVER 18 FOR SQL SERVER?
Srividya

Srividya

Newcomer

Thursday

In our product, we have many crystal reports which are designed to fetch data using MS SQL stored procedure, it is getting launched successfully, when we use the ODBC Driver SQL Server, and while upgrading the MS SQL ODBC driver to "ODBC driver 18 for SQL Server", we are facing the below problem in SAP crystal report processing. 

05/02/2024 4:32:52 PM The table 'R_ADT_ADM001' could not be found. Error in File ADM002 5356_10864_{D00DEF7A-1D90-4C60-84AE-C2061BB38337}.rpt: The table could not be found. (-2147482939)

We are currently using the SAP crystal report run time "CRRuntime_32bit_13_0_15.msi" to invoke the report. 

On further analysis, when we open the Crystal Reports using the SAP Crystal Report 2020 and Set Datasource Location selected the Report ‘R_ADT_ADM007’ linked with Stored procedure are unable to open in the Sap crystal report, it prompts a Message “Data Object Cannot be opened/accessed”.

Kindly review and let us know any configuration we missed out or is the ODBC driver 18 for SQL Server supported.

Accepted Solutions (0)

Answers (2)

DellSC

DellSC

Active Contributor

19m ago

The supported platforms doc for Crystal for Visual Studio is here:  https://www.sap.com/documents/2016/06/f871031e-757c-0010-82c7-eda71af511fa.html

It shows that version 18 of the ODBC driver for SQL Server wasn't supported until SP23 for SQL Server 2017 and SP27 for SQL Server 2019.  You are currently running SP 15.

In order to support version 18 of the ODBC driver, you will need to upgrade your application to the latest version of the SDK (currently SP35) by recompiling it with the newer version.  There were some changes made to the SDK at SP21 that mean that you'll have to make a couple of tweaks to your code to get it to work with the new version. Unfortunately, when SAP re-wrote the wiki, they removed the links from @DonWilliams  that show what the changes are.  I hope that by tagging him here, he'll respond with that information.

You may also have to update the .NET version targetted by your application - the minimum supported version is now 4.6, which was also supported by the SP15 that you're currently using.

Then you'll need to install the new runtime on the server when you deploy your application.

You can find the latest version of the SDK through links here:  https://help.sap.com/docs/SUPPORT_CONTENT/crystalreports/3354091173.html.  You'll download a .exe file to get the integration with Visual Studio.  This .exe needs to be installed by right-clicking on it and selecting "Run as Administrator".  The other files available for SP 35 are the various forms of runtime installs - you will select one and it will be installed ONLY when deploying your application.  DO NOT install a runtime on the computer where you're running Visual Studio.

-Dell

JWiseman

JWiseman

Active Contributor

Friday

Hi Srividya, regarding the support question,  here is a help file for supported platforms for the  CR designer, dev versions, and server.  URL is subject  to change. Also if you go to the CR 2020 page there is an .xls download in the Data Access section.


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK