We're hoping to get some help.
We have an Oracle 8.1.3 DB running on VMS. We've got applications using this, but we're trying to set up a web server with a new custom application on it done in ASP with VBScript with MDAC (OLE DB) to get the data.
The code is working, but we're creating an outrageous number of connections on the DB server. Actually, the application is creating and destroying them, but apparently this is a very painful and expensive exercise for Oracle on VMS.
We suspect that OLE DB is not pooling connection for the web site (although there is a single connect string, so it should).
Is there any way to measure the pooling that's ongoing (we're not using ODBC) to tell?
We have an Oracle 8.1.3 DB running on VMS. We've got applications using this, but we're trying to set up a web server with a new custom application on it done in ASP with VBScript with MDAC (OLE DB) to get the data.
The code is working, but we're creating an outrageous number of connections on the DB server. Actually, the application is creating and destroying them, but apparently this is a very painful and expensive exercise for Oracle on VMS.
We suspect that OLE DB is not pooling connection for the web site (although there is a single connect string, so it should).
Is there any way to measure the pooling that's ongoing (we're not using ODBC) to tell?