Winsock application issue: NEED HELP 
Author Message
 Winsock application issue: NEED HELP

I am a MCSD working on contract with a team of analyst/programmers at
midwestern life insurance company.  We are experiencing a production
problem that we are unable to resolve.

Our environment is an N-Tier architecture, with a data-entry client
that is used all over the country.  The client application uses HTTP
and the
MS Winsock control to get the data back to the central SQL Server.
The application was built using VB 6.0

We are using a Winsock server application that interfaces to MTS for
the data layer. Essentially, the configuration is as follows:
Client ---> Winsock ---> MTS  ---> SQL Server 2000.  
All of theses components are on separate Windows 2000 Server machines,
with the exception of the client's machine.

The problem occurs on the Winsock application.  It is an error that is
returned from the MTS component (Run-Time error 3021: BOF or EOF has
occurred).  We understand the nature of this error and its causes.
The error, which is not occurring in a consistent manner causes the
Winsock application to hang until a user clicks through the error
message and then restarts the server app.

We have determined to some extent where in the code the problem is
happening, but no pattern has yet been established.  We also noted
that the client that causes the Winsock app to fail, could turn right
around and send the same data with no problems what so ever.

This error has been occurring on average of once per week over the
lifetime of the application, which is roughly 18 months.  Recently we
needed to upgrade our firewall software to Symantec's Raptor 7.0.
Previously, we used version 6.0.  This upgrade caused the error to
occur almost every half-hour.  In addition, the previous firewall
(6.0) software was on a NT 4.0 environment.  We installed Symantec's
7.0 version on a Windows 2000 Server.

Unfortunately, we are unable to duplicate the problem in a testing
and we cannot replicate the amount of load that is coming in from our
over the internet, as we have limited resources to create such a load.

If anyone has any insight to this particular scenario, your help would
be greatly appreciated.


Mon, 25 Apr 2005 01:09:57 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Winsock application issue: NEED HELP!!!

2. Winsock Issue - need help

3. Need help - ASP build issue

4. Need help on Read Only issue

5. Need help with ADO recordset sorting issue

6. Help needed on VB6 issue

7. annoying clipboard issue...need some help

8. Need help with network programming issues

9. Need help with two issues

10. Need some help. More trivial issues :)

11. Help needed on two issues

12. In dire need of some Help----Formatting issues


Powered by phpBB® Forum Software