500 error in rss_feed_topic.asp

 

I am getting a 500 error in the file : functions/functions_date_time_format.asp at line 78.

 

 

 

 

That is the only error I get, everything else works like a dream. The bad part is that the error handling is not catching it.

 

Ok after looking through things, I have located the source of the problem, and it is really simple I should have seen it sooner. The error is only likely to occur when the application variables are reset by the server, and the first page the user/bot loads is the rss feeds. The problem is that adoCon
is set to nothing at that moment in time. The simplest way around this error would be to check if adocon is valid and if not then open the database, and then close it afterwards, so that the real opendatabase does not cause problems.

 

This is not elegant, but will stop the rss feed pages from generating this particular error.

 

In File functions_date_time_format.asp

line 77 insert  :

   dim   we_open
   we_open = false

   if adoCon is Nothing then
      Call openDatabase(strCon)
      we_open = true
   end if

 

and then in line 98 insert :

   if (we_open = true) then
      Call closeDatabase()
   end if

 

Not really nice, but it will stop the error 500, not sure if this is the same as some of the other problems that you are chasing, but could be a pointer.

 

Thanks

DM

 

Thanks a bundle mate will do. This should sort out the problem. Just remember that there is no error trapping around the code in functions_date_time_format.asp file.

 

Thanks

DM