SAP Knowledge Base Article - Public

1694740 - Error: 'The database connector crdb_p2ssyb10.dll could not be loaded' when refreshing a report based on Sybase in Crystal Reports

Symptom

  • Error when refreshing a report.
  • Unable to refresh the report after upgrading to a new server.
  • In SAP BI LaunchPad, and in the Central Management Console, when refreshing a report based on Sybase, it fails.
  • When refreshing a report based on a Sybase data source in Crystal Reports, it fails with the error:
      
       "Failed to load database information.

        Details: The database connector 'crdb_p2ssyb10.dll' could not be loaded.
        The correct version of the database client for this database type might not be installed."

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
      
  • SAP Crystal Server 2013
  • SAP Crystal Server 2016
  • SAP Crystal Server 2020
      
  • SAP BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Business Intelligence Platform 4.2
  • SAP BusinessObjects Business Intelligence Platform 4.3

Reproducing the Issue

  1. In Crystal Reports, create a report based on a Sybase Native connection.
  2. Save the report to the SAP BusinessObjects BI Server.
  3. Migrate the reports to a new server, or open the report on a different computer in Crystal Reports designer.
  4. When refreshing the report in SAP BI LaunchPad, it fails to connect to the database. And when refreshing the report in Crystal Reports designer, it fails with the error: 
    "The database connector crdb_p2ssyb10.dll could not be loaded."

Cause

  • Reports are based on a Sybase database, and the error occured because the Sybase Client is not installed and configured on the computer where:
    • Crystal Reports in installed; or
    • SAP BusinessObjects Business Intelligence platform, or SAP Crystal Server, is installed.

Resolution

  • For Crystal Reports:
    • For Crystal Reports 2013, 2016:
      • Install and configure the 32bit Sybase Client on the computer where Crystal Reports is installed. 
          
    • For Crystal Reports 2020:
      • Sybase Native connection is not supported, therefore use an ODBC, or JDBC connection. For reference, see the supported platform for Crystal Reports 2020.
      • Note that it is still required to install and configure the 64bit Sybase Client on the computer where Crystal Reports is installed to connect using an ODBC connection.
          
  • For the SAP BusinessObjects Business Intelligence platform / SAP Crystal Server:
    • For SAP Crystal Server 2013, 2016, and SAP BusinessObjects Business Intelligence platform 4.1, 4.2:
      • Install and configure the 32bit Sybase Client on the computer where the SAP BusinessObjects BI platform server is installed. 
              
    • For SAP Crystal Server 2020, and SAP SAP BusinessObjects Business Intelligence platform 4.3:
      • Sybase Native connection is not supported, therefore use an ODBC, or JDBC connection. For reference, see the supported platform for SAP BusinessObjects BI 4.3
      • Note that it is still required to install and configure the 64bit Sybase Client on the computer where the server is installed to connect using an ODBC connection.

Keywords

"The database connector 'crdb_p2ssyb10.dll could not be loaded", Crystal Reports , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020