Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Application drops connection to 2005 SQL database when updating.

Posted on 2013-05-22
6
Medium Priority
?
356 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
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.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

636 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