Hello!
I had exactly the same problem...
I can say that on IIS3.0 all works fine! (I upgraded server, because I need
more complex actions with files via ASP)
I tried to open and close new Connection on every page (dont use single
Connection per ASP Session) - result the same.
Finally, I rejected to use ADO and ODBC, and install the Oracle Objects for
OLE. I think Oracle corp knows better how to work with Oracle Database :)
Geoff Dawson wrote in message <6foo58$nul$1_at_hagen.usenet.co.uk>...
>I am using ASP and ADO to connect to an Oracle database. Versions are IIS
>4.0 and MDAC 1.5c with both the Microsoft ODBC driver 2.73.728303 and the
>Oracle ODBC driver 2.05.031. It works with a single client connecting even
>with a fast hit rate (using an automated client gives over 10 accesses per
>sec). But with more then one client it hangs. Poking around with a test
>script shows that any ASP script attempting to Open an ADODB Connection
then
>hangs even if it is to a different (non-Oracle) database.
>
>The Oracle database is fine and I can still connect to it manually on the
>server using ODBC.
>
>At that point I cannot cleanly close down the Web Service. Using 'net stop
>iisadmin' reports that the service could not be stopped and reports System
>error 1051.The only solution seems to be a server re-boot.
>
>Unfortunately I had not tested concurrent access before upgrading to IIS
>4.0.
>
>Any suggestions ???
>
>Geoff Dawson
>
>
>
>
Received on Sat Apr 04 1998 - 00:00:00 CST