Internal Connection Fatal Error - SQL 2000 and ASP VS 2003

We have an ASP.NET 2003 app that accesses a MS SQL 2000 Std. database. Rand
omly it returns this error:
Internal connection fatal error.
Description: An unhandled exception occurred during the execution of the cur
rent web request. Please review the stack trace for more information about t
he error and where it originated in the code.
Exception Details: System.InvalidOperationException: Internal connection fat
al error.
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:
[InvalidOperationException: Internal connection fatal error.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195
tradeTicket.MonetaGroup.Approval.approve(Int32 Trans_ID, String Security_Typ
e) in C:\Inetpub\wwwroot\tradeTicket\Data\empl
oyee.vb:1191
tradeTicket.ApproveBond.buttonApproveNew_Click(Object sender, EventArgs e) i
n C:\Inetpub\wwwroot\tradeTicket\ApproveBo
nd.aspx.vb:469
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler
sourceControl, S
tring eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
----
--
Version Information: Microsoft NET Framework Version:1.1.4322.573; ASP.NET V
ersion:1.1.4322.573
We have SQL Server 2000 and Win2000 Server.
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Cop
yright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5
.0 (Build 2195: Service Pack 3)
Is there a setting I can bump up to fix this problem? We do close our conne
ctions. Here is a snippet of code:
----
--
Private Sub buttonApproveNew_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles buttonApproveNew.Click
Dim Approve As New MonetaGroup.Approval()
Dim curId = Request.QueryString("id")
Dim curSecurity = "B"
Dim nextID As String
Dim nextSecurity As String
Dim nextTransStatus As Integer
Approve.FindNextUnapprovedTransaction(curId, curSecurity, nextID, nextSecuri
ty, nextTransStatus)
Approve.approve(Request.QueryString("id"), "B") 'Line 469 error message
If nextID <> 0 Then
Dim returnValue = checkSecurity(nextID, nextTransStatus, nextSecurity)
Dim strBuilder As StringBuilder = New StringBuilder()
strBuilder.Append("<script language='javascript'>")
'strBuilder.Append("alert('The transaction was approved.');")
strBuilder.Append("window.open('" & returnValue & "','_self');")
strBuilder.Append("</script>")
RegisterStartupScript("focus", strBuilder.ToString)
Else
Dim strBuilder As StringBuilder = New StringBuilder()
strBuilder.Append("<script language='javascript'>")
'strBuilder.Append("alert('The transaction was approved.');")
strBuilder.Append("window.open('Approval.aspx','_self');")
strBuilder.Append("</script>")
RegisterStartupScript("focus", strBuilder.ToString)
End If
End Sub
Public Function checkSecurity(ByVal id As Integer, ByVal status As Integer,
ByVal security As String)
Dim returnValue As String
If status = 2 Then
If security = "MF" Then
returnValue = "../tradeTicket/ApproveMF.aspx?id=" & id & "&approve=0"
ElseIf security = "S" Then
returnValue = "../tradeTicket/ApproveStock.aspx?id=" & id & "&approve=0"
ElseIf security = "B" Then
returnValue = "../tradeTicket/ApproveBond.aspx?id=" & id & "&approve=0"
End If
Else
If security = "MF" Then
returnValue = "../tradeTicket/ApproveMF.aspx?id=" & id & "&approve=1"
ElseIf security = "S" Then
returnValue = "../tradeTicket/ApproveStock.aspx?id=" & id & "&approve=1"
ElseIf security = "B" Then
returnValue = "../tradeTicket/ApproveBond.aspx?id=" & id & "&approve=1"
End If
End If
Return returnValue
End Function
----
--
Thank you in advance.
RichWe're having the same issue. Our setup is Win 2003 Server IIS and Win 2000
SQL. I've found that the version of MDAC is different on the two machines.
Is your setup also 2 machines? If it is, let me know if your versions of M
DAC differ.
Thanks,
Bobsql

Internal Connection Fatal Error - SQL 2000 and ASP VS 2003

We have an ASP.NET 2003 app that accesses a MS SQL 2000 Std. database. Randomly it returns this error:
Internal connection fatal error.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Internal connection fatal error.
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:
[InvalidOperationException: Internal connection fatal error.]
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195
tradeTicket.MonetaGroup.Approval.approve(Int32 Trans_ID, String Security_Type) in C:\Inetpub\wwwroot\tradeTicket\Data\employee.vb:11 91
tradeTicket.ApproveBond.buttonApproveNew_Click(Obj ect sender, EventArgs e) in C:\Inetpub\wwwroot\tradeTicket\ApproveBond.aspx.vb :469
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
Version Information: Microsoft NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
We have SQL Server 2000 and Win2000 Server.
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Is there a setting I can bump up to fix this problem? We do close our connections. Here is a snippet of code:
Private Sub buttonApproveNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles buttonApproveNew.Click
Dim Approve As New MonetaGroup.Approval()
Dim curId = Request.QueryString("id")
Dim curSecurity = "B"
Dim nextID As String
Dim nextSecurity As String
Dim nextTransStatus As Integer
Approve.FindNextUnapprovedTransaction(curId, curSecurity, nextID, nextSecurity, nextTransStatus)
Approve.approve(Request.QueryString("id"), "B") 'Line 469 error message
If nextID <> 0 Then
Dim returnValue = checkSecurity(nextID, nextTransStatus, nextSecurity)
Dim strBuilder As StringBuilder = New StringBuilder()
strBuilder.Append("<script language='javascript'>")
'strBuilder.Append("alert('The transaction was approved.');")
strBuilder.Append("window.open('" & returnValue & "','_self');")
strBuilder.Append("</script>")
RegisterStartupScript("focus", strBuilder.ToString)
Else
Dim strBuilder As StringBuilder = New StringBuilder()
strBuilder.Append("<script language='javascript'>")
'strBuilder.Append("alert('The transaction was approved.');")
strBuilder.Append("window.open('Approval.aspx','_s elf');")
strBuilder.Append("</script>")
RegisterStartupScript("focus", strBuilder.ToString)
End If
End Sub
Public Function checkSecurity(ByVal id As Integer, ByVal status As Integer, ByVal security As String)
Dim returnValue As String
If status = 2 Then
If security = "MF" Then
returnValue = "../tradeTicket/ApproveMF.aspx?id=" & id & "&approve=0"
ElseIf security = "S" Then
returnValue = "../tradeTicket/ApproveStock.aspx?id=" & id & "&approve=0"
ElseIf security = "B" Then
returnValue = "../tradeTicket/ApproveBond.aspx?id=" & id & "&approve=0"
End If
Else
If security = "MF" Then
returnValue = "../tradeTicket/ApproveMF.aspx?id=" & id & "&approve=1"
ElseIf security = "S" Then
returnValue = "../tradeTicket/ApproveStock.aspx?id=" & id & "&approve=1"
ElseIf security = "B" Then
returnValue = "../tradeTicket/ApproveBond.aspx?id=" & id & "&approve=1"
End If
End If
Return returnValue
End Function
Thank you in advance.
Rich
We're having the same issue. Our setup is Win 2003 Server IIS and Win 2000 SQL. I've found that the version of MDAC is different on the two machines. Is your setup also 2 machines? If it is, let me know if your versions of MDAC differ.
Thanks,
Bob