Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Application drops connection to 2005 SQL database when updating.

Posted on 2013-05-22
6
Medium Priority
?
361 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 13

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 13

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 13

Expert Comment

by:Koen Van Wielink
ID: 39189739
Is it possible that the connection is timing out because the update takes too long?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

564 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