Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: SQL Server Connections not released


Message #1 by pquintanilla@c... on Wed, 14 Feb 2001 00:09:25
Hi there!

I hope you help me to know what is happening, i have a DLL COM Object who 

uses ADO and OLEDB to connect to a SQL Server DB and call several stored 

procedures, actually this COM is a bussiness object who is called from a 

VB Front end and an ASP page. The COM handles connection and data process 

stuff and i get the data via a variant array so my front end's apps doesnt 

know nothing about ADO or recordsets. The problem is that the COM Object 

effectively releases ADO Connections if it is called from the VB Front 

End, but if i call it from the ASP page ADO Connections are not 

released!!! i dont know why, im thinking that perhaps is something related 

to IIS. I close all the recordsets, disconects them and close the 

connection objects, do i have to configure something in IIS to get rid of 

this problem? some connection pooling stuff ?

Thanks in advance crew.

Prisciliano Quintanilla

  Return to Index