Microsoft ODBC for Oracle Driver problem
- From: "Sunray" <sunray@xxxxxxxxxxxxxxxxx>
- Date: Tue, 20 Mar 2007 16:31:08 -0000
I think I have a resource issue with this driver.
Our customers can either buy our software and host it themselves on their
own web server or we can host it for them.
On our hosted servers, we are having an issue where suddenly the ODBC
connection to the database cannot be established and the application pool
has to be recycled, resolving the issue till next time. This is a real
issue for us as once this happens for one customer it happens for every
customer on that hosted machine.
This is running IIS6 on Windows 2003 Enterprise Edition on a machine with
2Gb ram and a Dual CPU.
Our presentation layer is an ISAPI DLL that connects to Oracle via the
Microsoft ODBC Driver for Oracle.
Each customer gets their own section on the web server. There are 133
customers, 133 seperate websites and 133 ODBC connection. Due to
compatibility issues with Oracle and their drivers, the Microsoft ODBC for
Oracle driver is what we specifiy for use with our software and this works
without issue, except on our hosting server.
Examination of the Oracle logs shows nothing and other machines are still
able to connect to the database, so the issue is clearly isolated to the
machine rather than Oracle or the machine its on.
Each one of these ISAPI DLL creates 250 worker threads. Each one could
potentially have a connection to the database. That means that there are
33250 thread created on the machine each potentially with a connection to
the database. Due to the nature of our software, there is a real
possibility that a lot of people submit at a specific time.
The ISAPC software is written in Visual C++6 connects to the database using
a COM component. It opens and closes the ODBC data handles every time
someone requests a page. The DB COM component is also discarded at the end
of the request, this discards the ODBC data handle. The DB COM component
uses the MFC ODBC classes. Opening and closing both COM and ODBC like that
is not ideal, its quite slow, but this is old software now, it works
generally, and I have been given responsibility to maintain it.
I've tested the database COM component for any hint of a memory or resource
leak and cannot see one. 10's millions of requests to various sections and
neither does it leak resources or does the connection to Oracle stop
working.
ODBC tracing is not available to me (KB836072)
Any suggestions on what might be causing this?
I cannot see anything related to this in the knowledge base for that ODBC
driver. Is there a way of monitoring the ODBC drivers resources using the
Performance monitor?
Alex
.
- Follow-Ups:
- Re: Microsoft ODBC for Oracle Driver problem
- From: Arnie
- RE: Microsoft ODBC for Oracle Driver problem
- From: Walter Wang [MSFT]
- Re: Microsoft ODBC for Oracle Driver problem
- Prev by Date: Re: Am I a fool or idiot?!! ODBC Access Error
- Next by Date: RE: Microsoft ODBC for Oracle Driver problem
- Previous by thread: Am I a fool or idiot?!! ODBC Access Error
- Next by thread: RE: Microsoft ODBC for Oracle Driver problem
- Index(es):
Relevant Pages
|
