Please help ! Server Error in Application ! Object variable or

Hi,
One urgent issue in ASP.Net.
We have hosted an asp.net application in a windows 2003 server machine. The
application runs well but ONCE IN A WHILE it comes up with the error, "Serve
r
Error in '/CreditApplication' Application."
The error details are given below.
Sometimes, when we call the URL, it takes a long to load and finally doesnt
load and comes up with this error.
I dont understand why it works some time and doesnt work at other times.
The line in which the error is shown is a function, the contents of which
are given below.
*---
Private Sub LocContracts()
Dim OnlineConnection As New OnlineConnection
Dim Sql, SqlComm, SqlDR
Dim Branch = "ABHN"
Dim DBConnection = OnlineConnection.OnlineDBConnection
(Database)
Dim Trans As SqlClient.SqlTransaction =
DBConnection.BeginTransaction(IsolationLevel.ReadCommitted)
Sql = "Update Applications Set ContractType = 5,Repayment =
Case "
Sql = Sql & " when (LoanAmount * 3 / 100) > 40 Then
(LoanAmount * 3 /100)"
Sql = Sql & " else 40 End "
Sql = Sql & " where BranchId in ( Select BranchId from Branch
where BranchName = '" & Branch & "')"
Sql = Sql & " And ContractType = 0"
SqlComm = New SqlCommand(Sql, DBConnection)
SqlComm.Transaction = Trans
SqlDR = SqlComm.ExecuteReader()
Trans.Commit()
SqlDR.Close()
SqlComm = Nothing
Sql = Nothing
OnlineConnection = Nothing
End Sub
*---
I was wondering if it has anything to do with "isolationlevel.readcommitted"
The error message is given below
*---
Server Error in '/CreditApplication' Application.
________________________________________
Object variable or With block variable not set.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information abou
t
the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object variable or With
block variable not set.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[NullReferenceException: Object variable or With block variable not set.]
Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type
objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack
)
+934
Extraction.ViewApplication.LocContracts() in
D:\CreditApplication-1. 0H\ViewApplication\ViewApplicationExtrac
tion.aspx.vb:
396
Extraction.ViewApplication.Page_Load(Object sender, EventArgs e) in
D:\CreditApplication-1. 0H\ViewApplication\ViewApplicationExtrac
tion.aspx.vb:
54
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
________________________________________
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300
*---
Any help would be really appreciated.
Many ThanksWhich line is 396 in your code? It's attempting to use a NULL object
somewhere. Possibly the database connection failed in
OnlineDBConnection. If this is production code, you should add some
exception handling and logging for the DB connection and execution
calls.
Also, why use a DataReader to execute an Update statement? An
ExecuteNonQuery() seems more appropriate in this case.
-Carl
> We have hosted an asp.net application in a windows 2003 server machine. The
> application runs well but ONCE IN A WHILE it comes up with the error, "Ser
ver
> Error in '/CreditApplication' Application."
> The error details are given below.
Did you ever resolve this issue? I'm currently experiencing something
similar. An ASP.NET application was running fine on a Windows XP
machine. But now that we've moved it to Windows Server 2003, it
*sometimes* gets the error that you described:
System.NullReferenceException: Object variable or With block variable
not set.
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object
o, Type objType, String name, Object[] args, String[] paramnames,
Boolean[] CopyBack)
This is while accessing a COM object. Once again, it's worked
flawlessly on XP for quite a while now, but seems to occasionally have
problems on Windows Server 2003 (maybe the operating system isn't the
main issue, but I don't know what other differences exist).
- Roger