Hi, I encountered this intermittent server error which I had been trying to resolved :
*** 'd:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx' error message at: 2006/04/12 21:08:23 DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=-1) at d:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx line 99. Unable to execute the SQL statement. Affected Item: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'DISP_MODFY_DT'. (SQL-S0022) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-37000)(DBD: st_execute/SQLExecute err=-1) This is an SQL query. When I tried to run the query shown in the error log, it works. The DB is Microsoft SQL 2000. May I know if anyone has encountered this error and share with me what is wrong with the above? I've tried debugging using DBI trace but its provide the same error message as the server. I've also approached my DB administrator for help, but it could be application problem. Is it the application problem or DB problem?
