Symptom
- Error when refreshing a report.
- After updating a report, it fails with an error: "Invalid Object Name"
- After setting the data source location of a report from one SQL Server database to another SQL Server database that resides on the same server, it fails.
- When refreshing a report in Crystal Reports based on an ODBC connection to MS SQL Server, it fails with the error:
"Failed to retieve data from the database.
Details: 42S02:[Microsoft][SQL Server Native Client 11.0][SQL Server]
Invalid object name <Table Name>
[Database Vendor Code: 208]"
Read more...
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
- MS SQL Server 2014
- MS SQL Server 2016
- MS SQL Server 2017
- MS SQL Server 2019
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020
Keywords
SAP Crystal Reports, CR, Data Source, Set Datasource Location, Database Connector Error: 42S02 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.