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

Interesting issue connecting to Sql server through a firewall..

We have an app in development. The front end of the app is web-based running
tomcat.
This app sits in our DMZ.
This app communicates to a sql 2000 server on our corporate network. The
connection is via microsofts jdbc 2000 connector.
We have allowed the server hosting the app to initiate connections to the
internal sql server on port 1433 only. The sql server can communicat any/any
back to the dmz.
I am seeing some interesting behavior - The front end initiates a connection
to the DB server on 1433 which is successful, but then also tries to
initiate a connection on 137 (named pipes/nbname), of course the firewall
blocks this and it eventually times out. and the opens addtional pool
connection on 1433. This causes the app to load very slowly as the pages
are data driven. If we open up 137 then the app runs at a normal speed.
I dont understant why the front end is trying to communicate to the server
on anything other than 1433. The server is configured for tcp/ip only. The
JDBC driver and app on the front end is doing everything by IP address.
I've thought of trying a host file on the front end resolving the back end.
and vice versa, but this shouldnt matter as everything is IP and not name.
I am now trying to figure out if this is an issue with the microsoft jdbc
driver config - though it looks like you dont have the ability to specify
protocols in it, an issue witht he sql server - perhaps the response to the
initial connection is telling the client to talk named pipes, or if its
just an OS issue.
Leaving 137 open from the dmz app to the internal sql server is not an
option.
Thanks in advance.
BillConnecting with an IP address doesn't necessarily mean that
the clients will use TCP/IP for the network library. Try to
force the clients to connect through TCP/IP by specifying
the network library to use, e.g.
Network Library=DBMSSOCN
I don't know about the issue with specifying libraries with
the JDBC driver but you can also set this up on the client
by configuring an alias and the network library with the
Client Network Utility.
-Sue
On Tue, 30 Mar 2004 16:22:15 -0600, "Bill B"
<fakexxbbaulingyy@.unitedcenter.com> wrote:

>We have an app in development. The front end of the app is web-based runnin
g
>tomcat.
>This app sits in our DMZ.
>This app communicates to a sql 2000 server on our corporate network. The
>connection is via microsofts jdbc 2000 connector.
>We have allowed the server hosting the app to initiate connections to the
>internal sql server on port 1433 only. The sql server can communicat any/an
y
>back to the dmz.
>I am seeing some interesting behavior - The front end initiates a connectio
n
>to the DB server on 1433 which is successful, but then also tries to
>initiate a connection on 137 (named pipes/nbname), of course the firewall
>blocks this and it eventually times out. and the opens addtional pool
>connection on 1433. This causes the app to load very slowly as the pages
>are data driven. If we open up 137 then the app runs at a normal speed.
>I dont understant why the front end is trying to communicate to the server
>on anything other than 1433. The server is configured for tcp/ip only. The
>JDBC driver and app on the front end is doing everything by IP address.
>I've thought of trying a host file on the front end resolving the back end.
>and vice versa, but this shouldnt matter as everything is IP and not name.
>I am now trying to figure out if this is an issue with the microsoft jdbc
>driver config - though it looks like you dont have the ability to specify
>protocols in it, an issue witht he sql server - perhaps the response to the
>initial connection is telling the client to talk named pipes, or if its
>just an OS issue.
>Leaving 137 open from the dmz app to the internal sql server is not an
>option.
>Thanks in advance.
>Bill
>
>
>|||Hi Bill,
The Microsoft JDBC Driver will only work with TCP. Named pipe
connections would use 139 or 445, not 137.
Are you running Microsoft Enterprise Manager on the same network or are you
only running the JDBC app from the machine?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Interaction between SQL2k, SQL2k5, and SQLExpress

I've got both SQL2000 and SQL2005 running side-by-side and now I want to
test a ClickOnce deployment of my app with SQLExpress. Anyone been down this
road and know whether I will step on the toes of the installed servers?Hi Earl
I have not tried this but I believe you should be ok, although it is worth
trying it first in as many different scenarios as you can get!
John
"Earl" wrote:
> I've got both SQL2000 and SQL2005 running side-by-side and now I want to
> test a ClickOnce deployment of my app with SQLExpress. Anyone been down this
> road and know whether I will step on the toes of the installed servers?
>
>

Interaction between SQL2k, SQL2k5, and SQLExpress

I've got both SQL2000 and SQL2005 running side-by-side and now I want to
test a ClickOnce deployment of my app with SQLExpress. Anyone been down this
road and know whether I will step on the toes of the installed servers?Hi Earl
I have not tried this but I believe you should be ok, although it is worth
trying it first in as many different scenarios as you can get!
John
"Earl" wrote:

> I've got both SQL2000 and SQL2005 running side-by-side and now I want to
> test a ClickOnce deployment of my app with SQLExpress. Anyone been down th
is
> road and know whether I will step on the toes of the installed servers?
>
>

Intellectual Property question

I have been asked to prepare a feasibility study for an upgrade to a
VB app that uses a SQL server db.

The application is thin client, with about 100 sites connecting via
terminal services. 99% of the processing and business logic is done
using stored procedures.

The application is a highly configured version of an off-the-shelf
product.

The company would like me to quote for redesigning the front end, but
for this to interface to the existing db structure. However, the
original developer regards the database structure, particularly the
stored procedures, as her intellectual property.

Anyone have any idea how I (and the company who have asked me to do
the work) stand legally? Obviously I don't want to get lawyers
involved unless absolutely necessary (for example, if we clearly don't
have a leg to stand on, then there's no point in paying some shyster
300 an hour to tell me what I already know.)

TIA

EdwardIANAL.

What does the contract with the original developer say? Usually you would
expect a software development contract to spell out the IP rights. In my
experience, in the UK, the rights are typically left with the company
developing the software unless the client company requires otherwise.

--
David Portas
----
Please reply only to the newsgroup
--|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:39-dnXc7sJhTgFaiRVn-sA@.giganews.com...
> IANAL.
> What does the contract with the original developer say? Usually you would
> expect a software development contract to spell out the IP rights. In my
> experience, in the UK, the rights are typically left with the company
> developing the software unless the client company requires otherwise.

I concur. When I do similar work my contracts ALWAYS state the
obvious...either that all resultant work is the property of the customer or
that the software is provided with license TO the customer.

My advice to you would be to higher that 'shyster' to review the contracts,
before you or your customer end up in a lawsuit.

--
BV.
WebPorgmaster - www.IHeartMyPond.com
Work at Home, Save the Environment - www.amothersdream.com

integrating RS with asp.net app

Hi,
I would like to integrate RS with asp.net application.
Need your help, some how-to...
TIA,
KamelThree ways: URL integration (search help on URL), web services and (the best
option in my opinion) the new controls that ship with VS 2005. These
controls (winform and webform) are the easiest and best way to integrate
reports into your app. The new controls use web services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"kamel" <kwiciak@.gmail.com> wrote in message
news:1156836407.142596.249550@.h48g2000cwc.googlegroups.com...
> Hi,
> I would like to integrate RS with asp.net application.
> Need your help, some how-to...
> TIA,
> Kamel
>|||Thank you Bruce!
Are there any samples in the documentation or somwhere else?
How to manage large report lists, folders - replacment for Report
Manger functionality?
Kamel|||For that sort of thing you need to look at the documentation on web
services. You can get all that type of information through that method.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"kamel" <kwiciak@.gmail.com> wrote in message
news:1156860970.318411.254930@.i3g2000cwc.googlegroups.com...
> Thank you Bruce!
> Are there any samples in the documentation or somwhere else?
> How to manage large report lists, folders - replacment for Report
> Manger functionality?
> Kamel
>|||Very helpfull, thank you!

Integrating Reports into existing ASP.NET site/app...

We have been creating reports using SSRS but would like our users to request
reports through a custom interface NOT the standard SSRS interface. So as
far as I know there are 3 ways of presenting SSRS reports to users:
1) Report Manager
2) Reports through URL
3) SSRS Web Services
1 and 2 are simple, but require that the user experience SSRS look and feel,
including all navigation whereas the Web Services can be used to allow the
user to interact with reports that will have the same look and feel as the
site for which they are being integrated.
Is this a fair assessment? What in your opinion is the best way to integrate
SSRS reports into a site so the user will get to pick report params via web
controls custom to the site but then view the report with the zooming,
paging and exporting
that you get free with Report Manager?
**Note I have looked at and got to run the
Microsoft.Samples.ReportingServices.ReportViewer, and maybe this is the best
way. But can this be used when presenting the user with an alternative way
of providing parameters?
Thanks all in advance.I am using ReportViewer component in my current asp.net web site. You can
find this component in x:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\Samples\Applications\ReportViewer. There is
c# and vb.net code available. You need to compile it first. And this link is
also helped me much at the begining;
http://www.odetocode.com/Articles/128.aspx (dont forget to read part two)
Hope this helps,
Regards.
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:#G#BlW72EHA.3380@.TK2MSFTNGP09.phx.gbl...
> We have been creating reports using SSRS but would like our users to
request
> reports through a custom interface NOT the standard SSRS interface. So as
> far as I know there are 3 ways of presenting SSRS reports to users:
> 1) Report Manager
> 2) Reports through URL
> 3) SSRS Web Services
> 1 and 2 are simple, but require that the user experience SSRS look and
feel,
> including all navigation whereas the Web Services can be used to allow the
> user to interact with reports that will have the same look and feel as the
> site for which they are being integrated.
> Is this a fair assessment? What in your opinion is the best way to
integrate
> SSRS reports into a site so the user will get to pick report params via
web
> controls custom to the site but then view the report with the zooming,
> paging and exporting
> that you get free with Report Manager?
> **Note I have looked at and got to run the
> Microsoft.Samples.ReportingServices.ReportViewer, and maybe this is the
best
> way. But can this be used when presenting the user with an alternative
way
> of providing parameters?
> Thanks all in advance.
>
>