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.

Network database problem

4 posts in General Discussion Last posting was on 2004-06-16 15:10:39.0Z
Robert Posted on 2004-06-10 16:28:20.0Z
From: "Robert" <rpruski@esc20.net>
Newsgroups: ianywhere.public.general
Subject: Network database problem
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 168.37.200.1
X-Original-NNTP-Posting-Host: 168.37.200.1
Message-ID: <40c88c24$1@forums-1-dub>
Date: 10 Jun 2004 09:28:20 -0700
X-Trace: forums-1-dub 1086884900 168.37.200.1 (10 Jun 2004 09:28:20 -0700)
X-Original-Trace: 10 Jun 2004 09:28:20 -0700, 168.37.200.1
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3161
Article PK: 6622

One of my clients just reported a problem connecting to a network database
that seems fairly strange to me. When she created a new service with Sybase
Central 4.3, started the network database service successfully, and closed
Sybase Central. But, here is the problem none of the network users are able
to connect to the database, upon further investigation the database were not
running. We were doing some trouble shooting yesterday, and apparently if
she leaves Sybase Central running, just minimized the database continues to
run and her clients can connect without any problems.

This is the first report I have had of this problem, today she called and
she has second client is reporting this problem. Both clients are running
Windows 2000 service pack 4 and SQL Anywhere 9.0.1 build 1841, but we have
hundreds of users with that same configuration and no problems at all.

Here at the office I have network databases running on Windows 2000 and
Windows Server 2003 without any problems. Could a Microsoft update not be
installed that may be causing this problem?

Thanks in advance,

Robert


Graeme Perrow Posted on 2004-06-10 16:31:07.0Z
From: Graeme Perrow <gperrowNO@SPAMianywhere.PLEASEcom>
Reply-To: gperrowNO@SPAMianywhere.PLEASEcom
Organization: iAnywhere Solutions, Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Network database problem
References: <40c88c24$1@forums-1-dub>
In-Reply-To: <40c88c24$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.25.100.190
X-Original-NNTP-Posting-Host: 10.25.100.190
Message-ID: <40c88ccb@forums-1-dub>
Date: 10 Jun 2004 09:31:07 -0700
X-Trace: forums-1-dub 1086885067 10.25.100.190 (10 Jun 2004 09:31:07 -0700)
X-Original-Trace: 10 Jun 2004 09:31:07 -0700, 10.25.100.190
Lines: 39
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3162
Article PK: 6621

What server switches are used for the service?

Graeme Perrow
Senior Software Developer
gperrow@ianywhere.com
iAnywhere Solutions Inc.
A Sybase company

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/

Robert wrote:
> One of my clients just reported a problem connecting to a network database
> that seems fairly strange to me. When she created a new service with Sybase
> Central 4.3, started the network database service successfully, and closed
> Sybase Central. But, here is the problem none of the network users are able
> to connect to the database, upon further investigation the database were not
> running. We were doing some trouble shooting yesterday, and apparently if
> she leaves Sybase Central running, just minimized the database continues to
> run and her clients can connect without any problems.
>
> This is the first report I have had of this problem, today she called and
> she has second client is reporting this problem. Both clients are running
> Windows 2000 service pack 4 and SQL Anywhere 9.0.1 build 1841, but we have
> hundreds of users with that same configuration and no problems at all.
>
> Here at the office I have network databases running on Windows 2000 and
> Windows Server 2003 without any problems. Could a Microsoft update not be
> installed that may be causing this problem?
>
> Thanks in advance,
>
> Robert
>
>


Greg Fenton Posted on 2004-06-10 16:39:47.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 MultiZilla/1.6.2.0c
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Network database problem
References: <40c88c24$1@forums-1-dub>
In-Reply-To: <40c88c24$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <40c88f26$1@forums-2-dub>
X-Original-Trace: 10 Jun 2004 09:41:10 -0700, gfenton-xp.sybase.com
Lines: 24
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 10 Jun 2004 09:37:08 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 10 Jun 2004 09:39:47 -0700
X-Trace: forums-1-dub 1086885587 10.22.108.75 (10 Jun 2004 09:39:47 -0700)
X-Original-Trace: 10 Jun 2004 09:39:47 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3164
Article PK: 6624


Robert wrote:
> We were doing some trouble shooting yesterday, and apparently if
> she leaves Sybase Central running, just minimized the database continues to
> run and her clients can connect without any problems.
>

I would try to track down what is causing the server to close when SC is
shut down. Couple of things to try:

- analyze the startup parameters for the service
- have the database log its console to a log file and check for shutdown
messages
- check the NT event viewer to see if there is anything relevant in there

If you aren't sure, post your findings of the above.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Robert Posted on 2004-06-16 15:10:39.0Z
From: "Robert" <rpruski@esc20.net>
Newsgroups: ianywhere.public.general
References: <40c88c24$1@forums-1-dub> <40c88f26$1@forums-2-dub>
Subject: Re: Network database problem
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: 168.37.200.1
Message-ID: <40d06360$1@forums-2-dub>
X-Original-Trace: 16 Jun 2004 08:12:32 -0700, 168.37.200.1
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Jun 2004 08:07:23 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Jun 2004 08:10:39 -0700
X-Trace: forums-1-dub 1087398639 10.22.108.75 (16 Jun 2004 08:10:39 -0700)
X-Original-Trace: 16 Jun 2004 08:10:39 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3189
Article PK: 6646

Greg,

I just received more information from my client, they had added the -ga
switch to their server service, removing the -ga switch fixed the problem.
Thanks, Greg and Graeme for your assistance it was greatly appreciated.

Thanks,
Robert

"Greg Fenton" <greg.fenton_NOSPAM_@ianywhere.com> wrote in message
news:40c88f26$1@forums-2-dub...
> Robert wrote:
> > We were doing some trouble shooting yesterday, and apparently if
> > she leaves Sybase Central running, just minimized the database continues
to
> > run and her clients can connect without any problems.
> >
>
> I would try to track down what is causing the server to close when SC is
> shut down. Couple of things to try:
>
> - analyze the startup parameters for the service
> - have the database log its console to a log file and check for shutdown
> messages
> - check the NT event viewer to see if there is anything relevant in there
>
> If you aren't sure, post your findings of the above.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/