1875926 - Error: "Database Connector Error: '42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'testdbname.dbo.tablename'.[Database Vendor Code:208]'" received in Crystal Reports

SAP Knowledge Base Article - Public

1875926 - Error: "Database Connector Error: '42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'testdbname.dbo.tablename'.[Database Vendor Code:208]'" received in Crystal Reports

Symptom

In Crystal Reports, after setting the data source location from one SQL Server database to another SQL Server database that resides on the same SQL Server, it gives an error "Database Connector Error: '42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'testdbname.dbo.tablename'.[Database Vendor Code:208]'"

Environment

  • SAP Crystal Reports 2011
  • SQL Server 2008 R2

Reproducing the Issue

  1. In Microsoft ODBC Data Source Administrator, create an ODBC connection (Test-1) that points to one MS SQL Server database (Database-1).
  2. Create a second ODBC connection (Test-2) that points to another MS SQL Server database (Database-2) that resides on the same server and that have the same schema.
  3. Create a report (Report-1) off an ODBC connection Test-1
  4. In Crystal Report-1, select Database -> Set Data source Location
  5. From Current Data Source, select "Test-1" which is based on Database-1
  6. From Replace with, select "Test-2" which is based on Database-2
  7. Click on Update button.

Note: After clicking on the Update button, an error is pop up.

Resolution

    1. Open the Crystal report (Report-1).
    2. In Report-1, select Database -> Set Data Source Location.
    3. From Current Data Source, expand the "Test-1" which is based on Database-1 and select the require object (Table OR View) which needs to be updated.
    4. From Replace with, expand the "Test-2" which is based on Database-2 and select the same object (Table OR View) as selected above.
    5. Click on Update button.

Keywords

SAP Crystal Reports, CR, Data Source, Set Datasource Location, Database Connector Error: 42S02 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011