Hi Alexander, Thanks for your reply. We have checked the table and DISP_MODFY_DT does exist. In fact, when we re run the query using DBI or through query analyzer, the query can return data. This is an intermittent problem which makes the troubleshooting much more challenging. From your experience, could this be a problem with DBI reporting false error? Or could it be an intermittent problem over on the Database side? If that's the case, could you send us an debug module so that we can capture more clearly the state of the Database when this problem re-occurs?
Thanks a lot for your help. -----Original Message----- From: Alexander Foken [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 6:29 PM To: Raymond Wong Cc: [email protected]; Tricia Koh Subject: Re: Error on DBI 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/
