The database table 'xxx' cannot be found. Proceed to remove...

[Former Member]

Hi guys,

Another headache here,

Problem,

I can expand jdbc and and connect database on sql server 2000 when choose data source.

However, whenever I verify database, it pop up 'The database table 'xxx' cannot be found. Proceed to remove this table from the report?'

I click 'No', everything is fine.

I did some search on the internet, some one said this is relate to some sort of alias problem crystal has. But even I change the table name to all upcase, still not working.

Anyone can explain this? Thanks in advance.

Environment:

Crystal Reports Professional version 11,

Sql server 2000

Microsoft SQL Server 2005 JDBC Driver

[former_member11696 · Accepted solution]

Hi Frank,

If you click on yes what does it remove? There may be some reference to a field or table that is not used but referenced in the report somewhere.

Rather than ignore it you should determine where the problem is.

Thank you

Don

[Former Member · Accepted solution]

Hi Don,

Thank you for your reply!

I found the problem is actually from the JDBC driver.

In CRConfig.xml, I redirect my classpath to microsoft JDBC 2000 rather than microsoft JDBC 2005 and changed JDBCClassName accordingly.

After that, it works perfectly.

Cheers,

Frank Lu