The database table "xxxx" cannot be found.

I have a Crystal Report that gives me the error  'The database table "xxx" cannot be found. Proceed to remove this table from the report?' when I try to run it for the first time. I click no (there are 2 tables so this happens twice) and then the report runs fine. If I refresh the report again it does not happen but occurs every time if I click on Verify Database from the Database Menu. I am connecting to a MYSQL Database using an OLE DB (ADO) connection.
jb25Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mlmccConnect With a Mentor Commented:
Does the table exist?

DO you have VERIFY DATABASE ON OPEN set in the report options or in options?
Check the FILE menu

mlmcc
0
 
Daniel WilsonCommented:
Verify correct capitalization of your table name.  

If you're accustomed to MS DB's (SQL Server or Access), you likely assume that table names are not case-sensitive.  But ... when dealing with MySQL as usually installed on a Linux system ... that assumption is wrong.
0
 
jb25Author Commented:
Verify on First Refresh was checked in the Report Options. I unchecked it and the report runs fine now. Thanks for your prompt reply.
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
vastoCommented:
Re you sure that the report runs ? Check if you are using saved data
0
 
jb25Author Commented:
The report runs correctly. The data is up to date. I'm not sure why but it seems the only problem is that the database won't verify.
0
 
mlmccCommented:
Can you refresh the data?

mlmcc
0
 
jb25Author Commented:
Yes, refresh works, verify doesn't.
0
 
mlmccCommented:
Is the problem table used in the report?

mlmcc
0
 
jb25Author Commented:
Yes. The report uses 2 tables,  both won't verify but will refresh correctly.
0
All Courses

From novice to tech pro — start learning today.