Sybase 11 NT server becoming unresponsive 
Author Message
 Sybase 11 NT server becoming unresponsive

We are new to Sybase (developing our first application in delphi 2.0
for Win95 clients), and have experienced the following problem:

When testing one of the functions in our new app, the client app would
suddenly seem to hang. Windows 95 would list the client app as "Not
responding". Eventually (within a few hours), *all* Sybase clients,
including WISQL, isql, etc. would all hang this way when trying to
connect to the Sybase server. Investigation showed that SQL Server
(and NT) was actually idle, apparently (see below) because the server
wasn't hearing the connect requests. So the server wasn't actually
hung or locked up, it was just unresponsive. Shutting down and
restarting SQL Server would resolve the problem.

This has been happening with version 11.0.2 on NT 4.0 (service pack
1). Sybase tech support says it's a bug in the netlib layer, and had
me apply SRW 7305, so that we're now at version 11.0.3. So far we've
been running for about a week without a recurrence. The problem is, my
developers and management are unsettled by the fact that Sybase have
been unable to tell us how we can be sure the problem is fixed, as in
"How can I see if the problem is occurring?" "You can't." "How can I
tell if the problem is fixed?" "The server keeps running."

So my question is, has anyone else had experience with this problem?
Can you tell me more about the problem? What was your solution? Are
you convinced it's fixed?


David Mullen              *** Any opinions expressed are mine, and not ***
Emjay Corporation         *** necessarily those of Emjay Corporation.  ***
Milwaukee, WI

Fight spam by joining CAUCE - Coalition Against Unsolicited Commercial Email

Sun, 09 Apr 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Stored Proc with Delphi and Sybase Adaptive Server 11.5.1

2. DELPHI 16 to SYBASE on an NT Server with client and server on same machine

3. Performance problems with Delphi & Sybase System 11

4. D2 and Sybase 11

5. Using Sybase 11 text-fields

6. Delphi 2 and Sybase 11 problem

7. Problem with Delphi3 CS and Sybase 11 - HELP please

8. Delphi 3 and Sybase 11 Connection Issues

9. HELP!, Sybase System 11 & Delphi 1.x

10. Locking Table (Sybase System 11)

11. Delphi 3 app locks up when trying to POST data to a SYBASE 11 table

12. Delphi1(Sybase SQL System 11) with NTWinframe


Powered by phpBB® Forum Software