The file 'XXX.aspx' has not been pre-compiled, and cannot be requested.

Development Tool: Microsoft Visual Studio 2008

Project Platform: ASP.NET Web

 

You are trying to browse your ASP.NET web after published it on your web server, but end up Windows giving you this error message in the browser: "The file 'XXX.aspx' has not been pre-compiled, and cannot be requested."

 

The weird part is, you already pre-compile the source codes, rights?

 

Here is the SOLUTION:

 

a). Publish your ASP.NET web project as usual.

 

b). IMPORTANT: Manually copy all of the DLL files into the <Pre-Compiled_Output_Folder>\bin folder. Those DLL files can be Crystal Reports DLL file, if you are using Crystal Reports in your ASP.NET web project.

 

c). Then, publish your ASP.NET web project on your web server as usual.

 

Have fun!

The table 'TABLE_NAME' could not be found. Error in File REPORT_FILE_PATH: The table could not be found.

Report Tool: Crystal Report from Visual Studio 2008
Database: MySQL Server (any version)
Project Platform: ASP.NET Web

Symptom 1: You can open the Crystal Report in developer's machine successfully.
Symptom 2: You cannot open the Crystal Report in other machines, including other developer's machine.

Error message: The table 'TABLE_NAME' could not be found. Error in File REPORT_FILE_PATH: The table could not be found.

SOLUTION:

• First, make sure the Crystal Report runtime is installed on the web server.
• Second, make sure the correct MySQL ODBC Connector is installed on the web server. For example: if you are using MySQL database version 5, then the version of the MySQL ODBC Connector shall be version 5 as well.
• After that, close all of the internet browsers.
• Run your web application now, and the error shall be resolved.

How to find all trigger information in MySQL?

Select
*
From Information_Schema.Triggers
Where trigger_schema = 'YOUR_SCHEMA_NAME'
Order By event_object_table Asc, event_manipulation Asc;

How to find all of the table information in MySQL?

Select
*
From Information_Schema.Tables
Where table_schema = 'YOUR_SCHEMA_NAME';

How to find all of the foreign keys in MySQL?

Select
*
From Information_Schema.Table_Constraints
Where constraint_schema = 'YOUR_SCHEMA_NAME' And
constraint_type = 'FOREIGN KEY'
Order By constraint_name Asc, table_name Asc;