SAP Knowledge Base Article - Preview

1875926 - Error: '42S02:[Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid object name <Table Name> [Database Vendor Code: 208]', when refreshing a report in Crystal Reports

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.