Re: Weird ADO failure/crash behaviour

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

All I have is that I suspect it's the ADO engine that for some odd reason
stops working correctly after running smooth and fine for months...

Maybe. Maybe not.

I have met countless problems where the point they show up is not the guilty
party. It has been sabotaged. So it does not follow that the ADO engine is
guilty. It might be. It might not.

You should review the machine:

1) Was anything new installed on this machine just before it started going
wrong?
- new hardware - like memory upgrade
- new software - service packs, virus engines etc.
- new version of MDAC
- newer version of your software or scripts. If so, compare against older
version.

2) You should consider reinstalling the version of MDAC installed on the PC

After a reboot of the IIS 5.1 machine, it all works perfectly. At one
time
it was fixed by simply restarting the World Wide Web publishing service,
but
otherwise I've been forced to reboot the entire machine.

I have never known any version of Windows to stay up indefinitely - weeks on
end.
Eventually they need reboots.

Stephen




.