SAP Knowledge Base Article - Preview

2114821 - Error when attempting to change datasource location in Crystal Reports 2013 from MS SQL OLEDB to MySQL ODBC connection

Symptom

  • Unable to change data source from MS SQL OLE DB  to MYSQL ODBC connection in Crystal Reports 2013 (CR2013)
  • Changing data source from ODBC to OLE DB connection works fine.
  • On “Set Datasource Location” window updating the following error appears: “Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables”

1093892-1.jpg

  • On “Set Datasource Location” after updating tables or aliases, the following error appears: "Invalid Argument Provided. Details: The alias requested ‘tablename’ contains a combination of characters which is not considered to be valid."

1093892-2.jpg


Read more...

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • MySQL server ODBC driver version 5.x
  • Microsoft SQL Server 2005 / 2008

 

Product

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

Keywords

Crystal Reports 2013,ODBC,Table,Alias, MySQL, MS SQL, Set Datasource Location, CR, CR2013 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , 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.