Re: IIS 4.0 asp - Oracle 8 Problem

Hello,

I have Oracle Objects 2.3, Oracle
8.0.5.something, PerlScript and IIS 4.0 on NT 4.

I use Oracle OLE DB provider,
and the problem is exactly the same. IIS stops serving ASP pages, and we can not "Unload application" from IIS panel, the server must be restarted.

I wonder are there any workarounds except to leave IIS for Apache+mod_perl or something?

Sincerely,
Oleg Sverdlov

In article <8bj9m4$ni3$1_at_lnews.actcom.co.il>,   "Gerald Berkovics" <gerald_at_coral.co.il> wrote:
> Hi.
>
> Background:
>
> I work on an application written in asp using
perlscript.
> The database I use is Oracle 8. I use the
oracle odbc driver, because the
> microsoft odbc
> driver for oracle has all kind of problems.
>
> The application runs on NT4 + IIS 4 + sp6a, and
the oracle is on another
> unix computer.
>
> Problem:
>
> It seems that my applications hungs sometime.
> It happens 1 - 3 times per day (with days that
it works okay).
> The IIS continue to serve html pages.
> The IIS continue to serve asp pages that do not
contain database
> connections.
> I've check network and looks okay.
> At the oracle database everything looks okay.
>
> After my checks, I came to the following
conclusions :
> The problem happens because any call the
Connection.open hungs the specific
> asp page that
> tries to make the connection.
> The timeout is very short but does not affect,
and We dont return from the
> connection.open.
>
> Probably the problem is at the asp to odbc
provider or the oracle driver.
>
> If i make connections from other places,
through the same odbc, it works at
> the same moment when it
> doesnt work from the asp environment.
>
> Also, If i write a cgi in perl , it success to
connect also.
>
> From this i conclude that the problem is like
asp application loosing
> connection to the provider or something.
>
> Ususaly the cpu is at 50% when this happens.
Since the application server
> has 2 cpu's, this probably means
> that an asp is blocked at the connection and
cpu is wasted o this block.
>
> IIS cannot be stoped from the services panel,
so we must kill it or restart
> the server.
>
> I wonder if others have already encounters this
problem, and if yes how did
> they solved it.
>
> Also, I would like to know if theree are
debugging tools or other utilities
> out there that can help me
> find the exact location of problem.
>
> Thanks, Gerald.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Apr 09 2000 - 07:19:07 CEST