> I run a website on a dual proc. W2003 box with a clean setup running iis
> 6.0. The site does a ton of data access using PROVIDER=SQLOLEDB against a
> SQL 2000 server with all the latest stuff.
>
> When I put load on it it starts to process requests and perfmon counters
> look as expected but efter a minute it seems to hang - still processing
the
> number of simultaneous requests I load it with and it does nothing until
the
> requests time out. Then it starts over again.
>
> I have no locking problems in the DB and nothing is happening anywhere -
no
> events nothing.
>
> Then i change PROVIDER=SQLOLEDB to DRIVER={SQLServer} and the problem is
> gone.
>
> I have a top of the line setup that is not yet in production so it is a
> clean test environment where I have full control of everything and nobody
> else is doing anything. The only reason I can come up with is that this is
a
> contention problem of some kind and to since changing the driver does the
> trick I guess threading issues with the driver.
>
> I remeber in the old days that it was possible to change the threading
model
> of ADO but now I can't find any reference to it.
>
> Any ideas?

> I remeber in the old days that it was possible to change the threading
model
> of ADO but now I can't find any reference to it.

"Bojidar Alexandrov" <bojo_do_not_spam@kodar.net> wrote in message
news:O9ZDNIaEEHA.2804@tk2msftngp13.phx.gbl...
>
> > I remeber in the old days that it was possible to change the threading
> model
> > of ADO but now I can't find any reference to it.
>
> Hmm hmm if that is your problem....
> here:
> Program Files\Common Files\System\ado\adofre15.reg
>
> Bojidar Alexandrov
>
>