Take a look here: http://www.microsoft.com/sql/

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Have a look at this article:
http://support.microsoft.com/default...b;en-us;316148

I have run into problems on IIS 6.0 running classic ASP. I read one article which talks about domain names with (_) and all the file names in my application have an (_) character. I am not sure if this has an impact. I read the server logs and found that IIS has restarted almost at the same time when the worker process was recycled. I have a global.asa not in my application folder but a different one under the root. I am not sure if the virus scan on this .asa file has an impact on IIS restarts. Also, I have a databases folder under the root\subfolder that contains some .mdb files...and I am pretty sure there are .lck files being created temporarily on the server. So, I have 3 possibilities for session variables getting dumped and there might be more if I get to read the posts in many forums!

If anyone can help me narrow it down, it would be great!!

Thanks

pratcp -

I'd look into the anti-virus software possibility first. That is probably most likely the culprit. I just checked my AV settings, and I can add an extension filter to avoid ASA/ASAX files. That may be what you need to do.

No special characters in any values referenced - all alphanumeric only. The A/V issue will be the first thing I'll check if I ever write another ASP application.

planoie & Ron,

Thanx for your quick reply. I have sent request to my server admin team to check the A/V settings on the web servers. I tried simulating the worker process recycle event on my development box. The default is set to 1740 min and I changed it to 30 min. I test run my app and found out that on one occasion the session variables got dumped when the worker process recycle event was triggered (after 30 min). The second time I ran my app, I did not lose my session variables. Strange!!!

Does anybody know if the underscore character in filenames causes this problem? If not, I will wait for the server admins to get back on the A/V settings and redo a test run on the dev. box...

hey

my session also gone when I ran my app. on the remote server. Does anybody solve this?

I turned off IIS recycling feature and stopped the trend scans (A/V check) on the web app folders. That helped me get rid of the session variable problems. However, I am now tackling with an intermitten "Action Cancelled" message when my screensaver-type application keep running for a week or so. Hope this helps x-ken.

uh

it sounds complicated. I will talk with my server. why does the 'action cancelled' message appear?

The Action Cancelled error is nothing to do with the session variables problem. I guess this is due to some ads being knocked off by the HOSTS file setting..I still need to spend more time on this one...However...

Turning off IIS recycling and A/V scan on your web app folders got rid of my session variables issue. The server guyz should be able to help.