problem connecting to Oracle from webserver

From: Tony van der Prijt <prijt_at_hotitem.nl>
Date: Mon, 28 Jan 2002 13:43:48 GMT
Message-ID: <3c555583.6526043@news.xs4all.nl>

Hi there,

We're running into a problem for which i can't find a solution. If someone out there has any insights i'd appreciate it.

We're running a web application. The webserver uses the following configuration

WindowsNT4 SP6a
ADO2.6
Net8 8.1.7
ODBC 8.1.7.5
We're using Microsoft Transaction Server for transaction support and object pooling.

The database server has the following configuration: WindowsNT4 SP6a
Oracle EE 8.1.7

The database is using multi threaded server.

Every now and then the webserver has to be rebooted. If that happens the eventview log shows the folling information:

============start eventviewer log====================

The description for Event ID ( 4104 ) in Source ( Transaction Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event:
(Package: HOT) (ProgId: HOT_Functions.FuncGet) (CLSID:
{ABDC23D3-0859-4D90-AC3D-D3ABD83BF130}) (Interface: FuncGet) (IID: {2CF7AE0D-5DD8-48C0-8142-3C54F0179CEF}) (Method: 105) (Microsoft Transaction Server Internals Information: File: i:\viper\src\runtime\cw\cwlib.cpp, Line: 935) (Exception: C0000005)
(Address: 0x60234d16)

oracommon8!vsnupr + 0x15C6
oracommon8!ttcdrv + 0x1ED
oran8!nioqwa + 0x2D

OraClient8!xaolog + 0x200A8
OraClient8!upirtr + 0xBD
OraClient8!kpurcs + 0x8A
OraClient8!kpuertb_reallocTempBuf + 0xA33
OraClient8!kpuertb_reallocTempBuf + 0x320D
OraClient8!OCIStmtExecute + 0x28

OCI!OCIStmtExecute + 0x37
SQORA32!_fChgPwdDlg_at_16 + 0xA8CC
.

============stop eventviewer log====================

The last few lines (starting with oracommon8) are the same every time. I am a bit puzzled by the last line: SQORA32!_fChgPwdDlg_at_16 + 0xA8CC This suggests that the oracle client tries to show some kind of dialog
(which of course it can't).

Maybe i am looking totally in the wrong direction. Any help would be very much appreciated.

TIA, Tony van der Prijt Received on Mon Jan 28 2002 - 07:43:48 CST