Hi

I am using a parametised command object in ASP to connect to an Oracle =
database over our WAN.  However, when that database goes down IIS does =
not release resources and INETINFO.EXE grabs 99% of clock cycles.  Can =
anyone suggest a solution to prevent this from occurring?  we are using =
MDAC 2.5.

here is an example of the paramatised command:
<%
Set Session("Ora_Conn") =3D Server.CreateObject("ADODB.Connection")
  	Session("Ora_Conn").ConnectionString =3D =
"DSN=3DMXM_prod;UID=3D*****;PWD=3D*****"
  	Session("Ora_Conn").open

set BenCmd=3DServer.CreateObject("ADODB.Command")
	query =3D "{call =
mds_pbm_details.mds_get_beneficiary_details(?,?,{resultset 10, P_STATUS, =
P_PERSON_KEY, P_MEMBERSHIP_NO, P_DEPENDANT_CODE, P_TITLE, P_SURNAME, =
P_FIRST_NAMES, P_DATE_OF_BIRTH, P_ID_NUMBER, P_POSTAL_ADDRESS1, =
P_POSTAL_ADDRESS2, P_SUBURB, P_POSTAL_CODE, =
P_GENDER,P_TELEPHONE_NUMBER,P_SCHEME_CODE,P_SCHEME_NAME,P_OPTION_CODE,P_O=
PTION_NAME,P_STATUS_DATE,P_HOME_LANGUAGE,P_WORK_NUMBER})}"
 	BenCmd.CommandText =3D query
 	BenCmd.ActiveConnection =3D Session("ORA_conn")
	BenCmd.CommandType =3D adCmdText

set pMemDepNum =3D BenCmd.CreateParameter("pMemDepNum", adVarChar, =
adParamInput, 14 )
	BenCmd.Parameters.Append pMemDepNum
	BenCmd.Parameters(0).value =3D ""

set pPersonKey =3D BenCmd.CreateParameter("pPersonKey", adVarChar, =
adParamInput, 14 )
	BenCmd.Parameters.Append pPersonKey
	BenCmd.Parameters(1).value =3D AppRS("PersonKey") & ","  'IMPORTANT =
COMMA !!!

set BenRS =3D Server.CreateObject("ADODB.RecordSet")
	BenRS.MaxRecords =3D 20
	BenRS.open BenCmd
=20
____________________________
Andrew Browne
Web application developer
PBM/Medscheme Integrated Care IT
Belmont Park, Rondebosch
021 - 658 6484
abrowne(at)pbm.co.za
____________________________

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA