Hi,
>The Init() of the ASPX page does not exist. The only Init() is in the WebForm class and the code was provided as is.

I see from the new thread in the Database section that you're getting the same errors without the inheritance so that's ruled out anyway.

>
>I am close to one million hits of testing on that and I am running out of ideas. The latest series of test I did today was to switch between code as is in the ASPX page and when using it from the DLL. As soon as I use it from the DLL, it is running extremely bad. There must be something sensitive in regards to the DLL/VFP provider as everytime I have this combination, it starts failing within a few minutes of testing.

I also see from the other thread that you are, in fact, getting the same errors with inline VB code. I'd be surprised if you weren't since the compilation is the same whether you use that or code behind files.

>In your test, have you tried to execute the relevant code from a DLL? Or, was everything inside the ASPX page?

Using code behind file for VB. Simpler SQL than yours (just one join). Web server is a slowish W2000 server - only handles about 2500 hits/min. Still using ASP.NET v1.1.4322. VFP data is on the webserver. IIS is 5.1 (I think). Using MS WAST for stress testing (10 threads with 10 sockets/thread) on one client. No errors over a couple of 15 minute runs (and several shorter ones)....

You mentioned that the new server has a dual-core processor. There were some problems with MSSQL and dual-core (but I think it was mainly a speed issue) and, IAC, I assume you're getting the errors on other (none dual-core) servers.

Since I'm not getting any errors it would seem that a configuration setting might be responsible but can't think what it might be.

I believe your using NET2/VS2005? What OS and IIS version on the web server?
Does you VFP data reside on the IIS machine?

If you don't have the WAST (Web Application Stress Tool) it's worth getting since it can give a lot of information on the server load itself (It's a free download from MS)

Regards,
Viv