Skip to Content
0
Former Member
Feb 15, 2009 at 12:49 AM

Database table "xxxxxx" cannot be found - SQLExpress 2005

80 Views

Hi, I created few reports with CR2008, using a connection to a table of an MDF database, attached to an instance of SQL Server 2005 Express Edition (.\SQLEXPRESS).

During the creation of the report everything seems to run smootly but when I want to preview it I get the message "Database table "tablename" cannot be found. Proceed to remove this table from the report?".

If I choose YES all the report disappears, if I choose NO the report shows correctly. I thought it was a minor problem, but when I try to use it in an .aspx page with a reportviewer control it says "The table 'tablename' cannot be found. Error in file reportname.rpt: the table could not be found." and I cant see the reports.

I tried to re-create the connections to the database using OLE DB (ADO) with a SQL Native Client Provider but the problem is still there.

In the past I used CR2008 with an MDB (Access 2003) database file for the data and an MDF database file for users and roles (ASPNETDB.MDF). All the reports I created against the Access database file are working fine and show in .aspx files without problem. This time, for a new application, I wanted to upgrade to a SQL Server database, but I encountered several new problems, like this one with CR2008.

Thanks for any help.