Solved

A transport-level error has occurred when sending the request to the server.

Posted on 2012-03-20
  • Windows OS
  • Microsoft SQL Server
  • Visual Basic.NET
  • Microsoft SQL Server 2008
  • Windows Server 2008
  • +1
12
479 Views
Last Modified: 2016-11-23
The following is the 2nd posting for this issue and it was fortunately resolved.

http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_26219810.html

However, I have run into it again.  I have an existing client who had (5) Windows XP workstations with a Windows XP 'server' in a workgroup environment.  They were running gigabit speed.  At that time I NEVER received transport-level errors from any of the workstations.

Six months ago, I replaced all machines with Dell Vostro's with Windows 7 Professional 64-bit machines including the glorified server where the SQL Express 2008 R2 database is installed.

My VB.NET application was re-installed with the same version executable.

I IMMEDIATELY began to receive these errors.  Generally 1-2 per day.  Sometimes skipping a day. My original posting/solution involved a true Win 2003 Server with a Broadcom NetXtreme adapter where I disabled TCP Chimney Offload.  I just identified that these Dell machines have a 'Broadcom NetLink (TM) Gigabit Ethernet' adapter.  We're now talking about another Broadcom adapter but not within a Windows Server OS.

Has anyone seen this adapter cause issues and does the TCP Chimney Offload exist within the Win 7 OS?

Sincerely, Phil
Transport-Protocol.txt
0
Comment
Question by:TSFLLC
12 Comments
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 37744956
What is the common network element between the two architectures ? switches ports...
0
 

Author Comment

by:TSFLLC
ID: 37745037
Are you asking what are the common components between the workstations and the PC with the SQL database they are connecting to?  10/100/1000 DLink switch.

And to reiterate.  The only changes are new PCs and different operating systems....Period.

Also, the protocols used with SQL Express as such:

Shared Memory - Disabled
TCP/IP - Enabled
Named Pipes - Disabled
Via - Disabled


I just remoted back into the SQL box.  Noticed something disturbing.  May be nothing.
Notice the attached file & the power management settings.
BroadCom-Details.PNG
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 37774268
SQL Express does not allow network connections by default. Did you change that by going into Surface Area Configuration? Are the ports open? Enable all the protocols. Also start the SQL Browser service.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:TSFLLC
ID: 37786339
CodeCruiser, this customer's been using my software for years.  The only thing that changed was the computers themselves.
0
 
LVL 22

Expert Comment

by:senad
ID: 37795266
How are you connecting to the server (server name) ? It might be that the application is getting the server name wrong.
Checked this ?
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/9609559d-f7ce-4bd8-97d0-0003ff7c9c98/
I installed 2012 version (default instance) and the instance became my computer name. So I had to change the connection string.
0
 
LVL 10

Expert Comment

by:sqlservr
ID: 37795273
check you database engine is running or not

user services.msc

if your sql service is already started. use ip address the access
0
 
LVL 22

Expert Comment

by:senad
ID: 37795280
0
 

Author Comment

by:TSFLLC
ID: 37801551
senad, sqlservr,

I appreciate your postings.  However, this company has been up and running day-in/day-out since I put these new computers in.  There are no problems with the database name, service not running.

I happen to be in their office the other day taking care of a problem not related to any of this when the manager had my application up and running, he left the office for about 20 minutes, came back and it generated another transport protocol error.

The issue is with the application having a connection open with no activity for a period of time.  THIS IS THE ROOT OF THE PROBLEM.

Unless I create an auto-logoff function or create a timer that hits the database every 30/60 seconds this problem will continue.  I welcome any other ideas or past experiences in how to resolve this.

Thanks.
0
 

Accepted Solution

by:
TSFLLC earned 0 total points
ID: 38942110
This is my workaround for dealing with this issue.  Testing connection and attemting to recreate.  Thanks to everyone who helped.

Sub()

       da.SelectCommand = New SqlCommand
       da.SelectCommand.Connection = TMSConnection

End Sub


    Public ReadOnly Property TMSConnection() As SqlConnection
        Get
            Dim da As New SqlDataAdapter
            Try
                da.SelectCommand = New SqlCommand
                da.SelectCommand.Connection = TSFConnection
                da.SelectCommand.CommandType = CommandType.Text
                da.SelectCommand.CommandText = "SELECT config_id FROM tbl_config"
                da.SelectCommand.ExecuteNonQuery()

                If IsNothing(TSFConnection) Then
                    OpenConnection()
                End If
                If TSFConnection.State = ConnectionState.Closed Or TSFConnection.State = ConnectionState.Broken Then
                    OpenConnection()
                End If
                da.Dispose()
                Return TSFConnection
            Catch sql_ex As System.Data.SqlClient.SqlException
                'Select Case sql_ex.ErrorCode
                'Case Is = -2146232060
                OpenConnection()
                'End Select
                da.Dispose()
                Return TSFConnection
            End Try
        End Get
    End Property
0
 

Author Closing Comment

by:TSFLLC
ID: 38957037
Got help with this but ended up having to develop a function that checked for open connection.  Thanks to all.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
Viewers will learn how the fundamental information of how to create a table.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question