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 Native connection to Sybase.

  • For Crystal Reports 2013, 2016:
    • The Sybase Client is not installed and configured.
           
  • For Crystal Reports 2020:
    • The Sybase Native connection is no longer supported from Crystal Reports 2020.

Resolution

  • For Crystal Reports 2013, 2016, and SAP BusinessObjects BI 4.1, 4.2:

    • Install and configure the 32bit Sybase Client on the computer where Crystal Reports is installed. 

             
  • For Crystal Reports 2020, and SAP BusinessObjects BI 4.3:

    • Sybase Native connection is no supported, therefore use an ODBC, or JDBC connection. For reference, see the supported platforms document for Crystal Reports 2020.
         
    • Note: 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 JDBC connection, the Sybase Client installation is required.  

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