Your SQL statement in
d:\inetpub\wwwroot\S_script\Qdr\Reports\rpt_preview.plx line 99 contains
the column name "DISP_MODFY_DT" that does not exist in your database.
This is not a DBI problem, DBI is just reporting it. It is a problem
with your SQL statement, your Database and perhaps your connect string.
Alexander
On 13.04.2006 12:11, Raymond Wong wrote:
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?
--
Alexander Foken
mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/
