on 2024 Sep 07 1:17 PM
in the Fressh Machine
CRRuntime_64bit_13_0_22 fails to retrive data from remote Sql Server 2019.
Request clarification before answering.
Refer to the supported Platforms page:
https://www.sap.com/documents/2016/06/f871031e-757c-0010-82c7-eda71af511fa.html
SQL Server 2019 is not supported until SP 27, you are using SP 22.
Upgrade your projects runtime, and no you can't just install SP 27, developer must rebuild the application.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That error is generated by MS SQL Server, try search for fixes for that error:
Use SP 36, CR for VS only supports the latest release. It will have all of the latest Security patches.
It could be you are using MS SQL Server with TLS 1.2 enabled in which case you must update each report manually and use ODBC or OLE DB.
I use ODBC for testing, if your security is set up correctly when you test the connection it should work, if it works in ODBC then update each report to use the New DSN and then refresh and save the report, it should work now.
PS - you can't update the original report in code to support TLS 1.2, CR keeps the DB client info in the RPT file and only way to update it is to use CR Designer to update the client info.
See this KBA for more info:
As my SQl 2019 server is running in Ubuntu server . i have modify
[ system_default_sect ] MinProtocol = TLSv1.2 CipherString = DEFAULT@SECLEVEL=2
in the server . but nothing is happen. same issue and same problem
1. install cr 29 developer version in visual studion 2017 and buitl the project
2. install cr 29 runtime in client machine
3. Microsoft ODBC Driver 18 for SQL Server install in client machine.
so hoping to get right answer from the commnity
CR is simply passing the error to you, it's not being generated by Crystal so you'll have to contact Microsoft for a solution. Try this: https://bobcares.com/blog/sql-server-error-18/
Does the ODBC Test connection work?
User | Count |
---|---|
75 | |
30 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.