We are facing a problem which sometimes obviously freezing the IIS server. <BR>The problem is with our Query method of our DBConnection class, its an ASP class. The whole code for the class I am putting down here:<BR><BR>DBConnection class:<BR>-----------------------------------<BR><BR>&#060;!--#Include File="adovbs.inc"--&#062;<BR>&#060;!--#Include File="Connection.inc"--&#062;<BR>&#060;%<BR>CLASS ConnectionPoint<BR> DIM mobjCon<BR> DIM mstrCon<BR><BR> Private Sub Class_Initialize()<BR> <BR> &#039;PS Function 1 :<BR> &#039;-----------------------------------------------------------------------------------------------------------------------------&#039;<BR> &#039; Class Initialize function is used to <BR> &#039; a) To form a Connection String depending upon the type of user login in. There would be 2 types of user <BR> &#039; login in , first would be the admin. The rights and previlidges for the admin is different from that of the <BR> &#039; normal user. Another would be a normal user. Class Initialize Creates a ADODB Connection object and <BR> &#039; also does the connection<BR> &#039;-----------------------------------------------------------------------------------------------------------------------------&#039;<BR><BR> &#039;mstrCon = "Provider=OraOLEDB.Oracle;User ID=ISPADMIN;Data Source=PENTISP;Persist Security Info=False"<BR> <BR> mstrCon = "Provider=OraOLEDB.Oracle;"<BR> mstrCon = mstrCon & "User ID =" & L_UserID & ";"<BR> mstrCon = mstrCon & "Data Source=" & L_UserDataSource & ";"<BR> mstrCon = mstrCon & "Persist Security Info=False"<BR> <BR> &#039; Create a ADODB Connection object<BR><BR> Set mobjCon = Server.CreateObject("ADODB.Connection")<BR> &#039; Read the UserID,Password from the Connection.inc file and Open the Connection object <BR><BR> If mobjCon.State &#060;&#062; adStateOpen Then mobjCon.Open mstrCon, L_UserID, L_UserPassword <BR> <BR> End Sub<BR><BR> Public Function Query(astrQuery) <BR> Dim objCom<BR> &#039;On Error Resume Next<BR> Set Query = Server.CreateObject("ADODB.Recordset")<BR> Query.CursorLocation = adUseClient<BR> Query.Open astrQuery, mobjCon, adOpenForwardOnly, adLockReadOnly, adCmdText<BR> Set Query.ActiveConnection = Nothing &#039;Disconnect the recordset<BR> <BR> End Function<BR> <BR> Public Sub Execute(astrQueryString)<BR> Dim cmdExecute<BR> DIM varSQL<BR> DIM intCount<BR> <BR> varSQL = SPLIT(astrQueryString,"~")<BR> Set cmdExecute = Server.CreateObject("ADODB.Command")<BR> With cmdExecute<BR> Set .ActiveConnection = mobjCon<BR> .CommandType = adCmdText<BR> FOR intCount = 0 TO UBOUND(varSQL)<BR> mobjCon.BeginTrans<BR> .CommandText = varSQL(intCount)<BR> .Execute ,,adExecuteNoRecords<BR> mobjCon.CommitTrans<BR> NEXT<BR> End With<BR> <BR> Set cmdExecute = Nothing<BR> End Sub<BR> <BR> Private Sub Class_Terminate()<BR> IF mobjCon.State = adStateOpen Then<BR> mobjCon.Close<BR> END IF<BR> <BR> SET mobjCon = NOTHING<BR> End Sub<BR>END CLASS<BR>%&#062;<BR>-----------------------------------<BR><BR>And the other business classes using this class for query or executon. <BR><BR>The problem we are facing is sometimes it throws <BR><BR>Active Server Pages, ASP 0241 (0x80004005) <BR>The CreateObject of &#039;(null)&#039; caused exception C0000005. <BR><BR>error or sometimes other cannot open recordset error.<BR><BR>After we get the error it simply freezes the IIS. We are using IIS 5.0 at WIN 2000 advanced server.<BR><BR>Please suggest a remedy.<BR><BR>Thanks in advance,<BR><BR>Siddhartha Dutta