Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Fatal Error: Crystal reports has stopped working Post Reply Post New Topic
Author Message
nwohio
Newbie
Newbie
Avatar

Joined: 08 Sep 2011
Location: United States
Online Status: Offline
Posts: 7
Quote nwohio Replybullet Topic: Fatal Error: Crystal reports has stopped working
    Posted: 16 May 2012 at 10:22am

“Crystal reports has stopped working.  A problem caused the program to stop working correctly.  Windows will close the program and notify you if a solution is available.”  Using CR2011.  Occurs with certain tables from MySQL database with Connector ODBC 5.1.  Some tables will select in Report Creation Wizard whereas others will generate the error and close the program.  Have received same error from 2 independent databases.  Solutions and suggestions welcome as I cannot proceed without a repair.  Thanks in advance.



Edited by nwohio - 16 May 2012 at 10:22am
IP IP Logged
nwohio
Newbie
Newbie
Avatar

Joined: 08 Sep 2011
Location: United States
Online Status: Offline
Posts: 7
Quote nwohio Replybullet Posted: 17 May 2012 at 4:29am
I have since learned the tables not selectable exceed 12 characters in tablename.  In other words, any tablename <= 12 characters will be selected for field explorer.  Apparently names not truncated create the error.  Is there a fix so I may use my existing databases to create reports and evaluate CR 2011?

Edited by nwohio - 17 May 2012 at 4:34am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 17 May 2012 at 5:17am
I have never run into this.  I assume it is an ODBC issue, because I am using an MS-SQL database with table and field names longer than 12 characters.
IP IP Logged
nwohio
Newbie
Newbie
Avatar

Joined: 08 Sep 2011
Location: United States
Online Status: Offline
Posts: 7
Quote nwohio Replybullet Posted: 17 May 2012 at 5:22am
I am using a 30 day trial version of CR2011 and perhaps restrictions have been implemented by SAP.  Any thoughts?
IP IP Logged
nwohio
Newbie
Newbie
Avatar

Joined: 08 Sep 2011
Location: United States
Online Status: Offline
Posts: 7
Quote nwohio Replybullet Posted: 17 May 2012 at 5:23am
Also, what is the correct ODBC driver for this application?  As stated I am using the 5.1.11.
IP IP Logged
exedriver
Newbie
Newbie


Joined: 04 Jun 2012
Online Status: Offline
Posts: 2
Quote exedriver Replybullet Posted: 04 Jun 2012 at 2:23am
I am facing the same problem - mySQL ODBC Version 5.1.11, CR2011 (full version, no trial). Some databases are working - some not. I installed the latest CR2011 Patch 17 but no change. Do you have a solution for that problem nwohio?
IP IP Logged
nwohio
Newbie
Newbie
Avatar

Joined: 08 Sep 2011
Location: United States
Online Status: Offline
Posts: 7
Quote nwohio Replybullet Posted: 04 Jun 2012 at 3:20am
I can only offer what I have already posted:  the 12 character limit to table names.  That 5.1 driver works for me.  Test the table name scenario by selecting only <12 char tables and then add one with >12 to see if it crashes.  Good luck.
IP IP Logged
exedriver
Newbie
Newbie


Joined: 04 Jun 2012
Online Status: Offline
Posts: 2
Quote exedriver Replybullet Posted: 04 Jun 2012 at 3:57am
In my case it even crashes when I select tables with <12 chars. Looks like I need to open a ticket at SAP 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.