Solved

The database table "xxxx" cannot be found.

Posted on 2015-02-02
9
228 Views
Last Modified: 2015-02-03
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.
0
Comment
Question by:jb25
9 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40584381
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
 
LVL 32

Expert Comment

by:Daniel Wilson
ID: 40584421
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
 

Author Closing Comment

by:jb25
ID: 40584472
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 18

Expert Comment

by:vasto
ID: 40584641
Re you sure that the report runs ? Check if you are using saved data
0
 

Author Comment

by:jb25
ID: 40584710
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 40584796
Can you refresh the data?

mlmcc
0
 

Author Comment

by:jb25
ID: 40584842
Yes, refresh works, verify doesn't.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40585461
Is the problem table used in the report?

mlmcc
0
 

Author Comment

by:jb25
ID: 40587138
Yes. The report uses 2 tables,  both won't verify but will refresh correctly.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question