ASP script hangs on ADO Open

From: Geoff Dawson <geoff.dawson_at_capgemini.co.uk>
Date: 1998/03/30
Message-ID: <6foo58$nul$1@hagen.usenet.co.uk>#1/1

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 Mon Mar 30 1998 - 00:00:00 CST