Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

Application drops connection to 2005 SQL database when updating.

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
piggly
Asked:
piggly
  • 3
  • 3
1 Solution
 
Koen Van WielinkBusiness Intelligence SpecialistCommented:
Is it possible that the connection is timing out because the update takes too long?
0
 
Koen Van WielinkBusiness Intelligence SpecialistCommented:
Is it possible that the connection is timing out because the update takes too long?
0
 
Koen Van WielinkBusiness Intelligence SpecialistCommented:
Is it possible that the connection is timing out because the update takes too long?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
pigglyAuthor Commented:
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
 
pigglyAuthor Commented:
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
 
pigglyAuthor Commented:
It was resolved by another technical site.  I just wanted to post what the resolution was in case anyone else has this issue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now