Symptom
- Unable to create a report off a Universe.
- Error when attempting to create a report off a Universe that connect to MySQL database.
- When attempting to create a report off a Universe based off a MySQL database using a JDBC connection, Crystal Reports for Enterprise fails with the error:
"Error: "Failed to execute query: '[] <com.businessobjects.dsl.commons.exception. NestedException: No suitable driver found for JDBC:mysql://<Server IP Address>", Redesign your query or contact the data source maintainer to solve the problem."
- Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
- SAP Crystal Reports for Enterprise 4.0
- SAP BusinessObjects Business Intelligence Platform 4.0
- MySQL 5
Product
SAP BusinessObjects Business Intelligence platform 4.0
Keywords
.unx Universe, JDBC, Connection Server, CRFE, CR4E, CR for Enterprise , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-BIP-SL , Semantic Layer , 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.