Oracle 8i Lite - ASP hangs after ODBC app closes

From: <sgornick_at_my-deja.com>
Date: Thu, 25 Nov 1999 05:50:29 GMT
Message-ID: <81iin5$1mf$1@nnrp1.deja.com>

I just installed Personal Oracle 8i Lite v4.0 on an NT v4.0 w/SP5 installed, and am experiencing a problem.

IIS serves the .ASP shown below, and by itself, it works just fine. Then I can log in using SQL*Plus, leave it connected, and run the .ASP again, and it still works fine.

But then once I exit SQL*Plus and then try run the .ASP again, it hangs indefinitely.

What I need to do then is go into MMC and Unload the Script application, and successive runs of the .ASP will work once again.

(The error won't occur if just connecting to SQL*Plus, exiting, and then running the .ASP again. It only occurs if the SQL*Plus session stays connected WHILE the .ASP runs.
Also, this occurs with ANY ODBC connection, not just SQL*Plus. For example I can connect with MS Access 97 instead of SQL*Plus, and the same problem will occur when the .ASP is called next.)

ODBC Admin shows: "Oracle Lite 40 ODBC Driver 3.00.00.00". In MMC, my Application Settings show:
  X Run in separate memory space (isolated process) [checked]   X Cache ISAPI applicactions [checked]   X Enable session state [checked]
  X Enable buffering [checked]
  ASP Script timeout 60 seconds
  Cache all requested ASP files [selected]

Unless I find a workaround, I cannot use Oracle Lite as my database on the web server because as soon my ODBC app, which is also on that server, exits then the next time the .ASP is called, IIS basically will hang. The next user after that trying to run the .ASP gets: "The remote procedure call failed and did not execute."

What to do?

Thanks in advance!

File testprob.asp follows:

<%
Set objConn = Server.CreateObject("adodb.connection") Set objCmd = Server.CreateObject("adodb.command")

objConn.Open "DSN=TESTPOL", TESTUSR, TESTPWD

Set objCmd.ActiveConnection = objConn

objCmd.CommandText = "INSERT INTO TESTUSR.TESTTBL VALUES (0)" objCmd.CommandType = adCmdText

objCmd.Execute

objCmd.CommandText = "COMMIT"

objCmd.Execute

  Set objCmd = Nothing
  objConn.Close
  Set objConn = Nothing
%>

<HTML>
<BODY>
  No problems found ...
</BODY>
</HTML>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 23:50:29 CST