Solved

Application drops connection to 2005 SQL database when updating.

Posted on 2013-05-22
6
349 Views
Last Modified: 2013-06-03
We are running a scheduled task that will update a database each day.  The update can have anywhere between 2000 and 8000 records.  When we run this process, it is stopping part way through.  This process was initially running on an Informix DB and has been moved to a 2005SQL DB.  Since we have moved the database, we have not been able to get this process to work on a regular basis.

When the task errors we are seeing the following information:
Event Log:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Wire Shark
Transmission Control Protocol
Acknowledgment Number:       0x54a217f9 [should be 0x00000000 because ACK flag is not set]
Acknowledgment number:       Broken TCP.  The acknowledge filed is nonzero while the ACK flag is not set]
SMB Header
      NT Status:  STATUS_PIPE_DISCONNECTED (0xc00000b0)

It looks to me that the application server that executes the task is sending a request to the database server to disconnect the communication pipe between the two systems.  

This process can be run again after removing the data that was successfully updated, sometimes it may take up to 8 times before it completes.  The data in the update file is clean and accurate, void of any errors.

SYSTEM INFORMATION:
OS:            Windows 2003 Standard 64 bit Server SP2
Database:            2005 SQL
DB Connectors:      ODBC
Program:            VB-6
0
Comment
Question by:piggly
  • 3
  • 3
6 Comments
 
LVL 12

Expert Comment

by:Koen Van Wielink
ID: 39189737
Is it possible that the connection is timing out because the update takes too long?
0
 
LVL 12

Expert Comment

by:Koen Van Wielink
ID: 39189738
Is it possible that the connection is timing out because the update takes too long?
0
 
LVL 12

Expert Comment

by:Koen Van Wielink
ID: 39189739
Is it possible that the connection is timing out because the update takes too long?
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:piggly
ID: 39195652
No, I don't believe this is the case, because one of the tests only ran for about two seconds.  The application processed about 120 records in that time before the error.  How would I test for this to be sure?
0
 

Accepted Solution

by:
piggly earned 0 total points
ID: 39205008
This issue was resolved by replacing the connection string.  Instead of using the server name we also replaced it with the IP address and port number.   The link below shows the steps we went through to resolve the problem.

http://www.tek-tips.com/threadminder.cfm?pid=183&page=1
0
 

Author Closing Comment

by:piggly
ID: 39215632
It was resolved by another technical site.  I just wanted to post what the resolution was in case anyone else has this issue.
0

Featured Post

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.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now