Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Windows 2000 problem?

2 posts in General Discussion Last posting was on 2003-05-12 15:39:57.0Z
pam Posted on 2003-05-09 17:47:25.0Z
From: pam@bcc-software.com
Date: Fri, 9 May 2003 13:47:25 -0400
Newsgroups: ianywhere.public.general
Subject: Windows 2000 problem?
Message-ID: <661B0733F0109D100061B99A85256D21.0061B9AF85256D21@webforums>
Lines: 27
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1007
Article PK: 2982

We are a software developer and our software was developed using Power
Builder 6.0 All testing and debuging was done on a database constructed
with Sybase SQL 5.5

We are experiencing problems with running a SQL database using Studio 7 or
8, in a multi user invironment. We have serveral clients running versions
of SQL Studio 7 & 8 with Windows NT 4.0 with no difficulty.

The clients experiencing the difficulty have Windows 2000 running on their
servers. These clients have reported problems with the database not
updating consistently.

Data is not being lost but in order for all users to see the most recent
data you have to down the database server, bring it back up
and everyone can then see the data.

This problem has only occured on the systems running Windows 2000 on the
server.

We are also getting error messages on the Sql Server log file regarding
some of our autoincrement variabless as not being indexed.

This problem has only occured on the systems running Windows 2000 on the
server.


Nick Elson Posted on 2003-05-12 15:39:57.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
References: <661B0733F0109D100061B99A85256D21.0061B9AF85256D21@webforums>
Subject: Re: Windows 2000 problem?
Date: Mon, 12 May 2003 11:39:57 -0400
Lines: 61
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#oB#X2JGDHA.329@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: nicelson-xp.sybase.com 172.31.142.76
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1012
Article PK: 2987

The OS should NEVER have an impact on the way things are being
committed, the way isolation levels work, or the way result sets should
behave.

There was a problem that was detected early in 8.0 (that also affects
7.0.x before 7.0.4 ebf2668) that affected result sets returned from stored
procedures but you don't mention that was a specific query or call
as being tied to this behaviour (in your case) so suggesting you ebf
may be premature.

I guess it is possible that some index has corruption (check it out with
dbvalid -f) ... but otherwise, there must be something else in common
than just the OS. Usage maybe? Starting template for the database?

By the way, has that database ever been rebuilt? That shouldn't matter
to this equation, but it would be a good thing to consider generally. Since
we normally don't recommend running a 5.5 database with ASA 8
or 7, it may be a problem corrects itself with a rebuild.

Since both versions 7 and 8 are involved, it may not matter that many
ebfs are available for both ... but if you are running different ebfs at the
W2K sites, than the others, that may provide more background.

Unforturnately without a repro., or an on-site investigation, it would be
near impossible to suggest anything specific to try..

To be honest this all sounds like something pretty fundamental is being
overlooked. User experience levels (or something else external to the
software and data) may speak more to this behaviour.

<pam@bcc-software.com> wrote in message
news:661B0733F0109D100061B99A85256D21.0061B9AF85256D21@webforums...
> We are a software developer and our software was developed using Power
> Builder 6.0 All testing and debuging was done on a database constructed
> with Sybase SQL 5.5
>
> We are experiencing problems with running a SQL database using Studio 7 or
> 8, in a multi user invironment. We have serveral clients running versions
> of SQL Studio 7 & 8 with Windows NT 4.0 with no difficulty.
>
> The clients experiencing the difficulty have Windows 2000 running on their
> servers. These clients have reported problems with the database not
> updating consistently.
>
> Data is not being lost but in order for all users to see the most recent
> data you have to down the database server, bring it back up
> and everyone can then see the data.
>
> This problem has only occured on the systems running Windows 2000 on the
> server.
>
> We are also getting error messages on the Sql Server log file regarding
> some of our autoincrement variabless as not being indexed.
>
> This problem has only occured on the systems running Windows 2000 on the
> server.
>
>
>