SAP Knowledge Base Article - Public

1735635 - Crystal Reports 2011 crashes with MySQL 5.1

Symptom

  • Crystal Report crashes while adding tables
  • Crystal Report does not respond while creating report based on multiple tables
  • While adding table whose name length is greater than 14 letters Crystal Report crashes
  • Crystal Reports crashes which uses My SQL database 5.1 drivers ODBC connection

Environment

  • Crystal Report 2011
  • MySQL 5.1 drivers

Resolution

  1. Install MySQL 3.5 drivers
  2. Create a new Data Source using MySQL 3.5 drivers
  3. Create report using the new Data Source
  4. Create a new Data source and update existing connection in the Crystal Reports as follows

 Open Crystal Reports >> open the report >> database menu >>  set data source location >> select the existing connection and the new connection from the ODBC connections and click on Update >> ok

Keywords

hangs, fails , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03