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.

dbsrv7 on Windows Server 2003

4 posts in General Discussion Last posting was on 2005-08-03 13:48:46.0Z
Stephen Isaac Posted on 2005-08-02 16:18:12.0Z
Sender: 3040.42ef8ff7.1804289383@sybase.com
From: Stephen Isaac
Newsgroups: ianywhere.public.general
Subject: dbsrv7 on Windows Server 2003
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42ef9cc1.335f.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 2 Aug 2005 09:18:10 -0700, 10.22.241.42
Lines: 17
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Aug 2005 09:18:10 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Aug 2005 09:18:12 -0700
X-Trace: forums-1-dub 1122999492 10.22.108.75 (2 Aug 2005 09:18:12 -0700)
X-Original-Trace: 2 Aug 2005 09:18:12 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4663
Article PK: 8469

I have just installed ASA 7.0.4.3541 on Windows 2003 Server.
On trying to start a service through Sybase Cenral I get an
error saying that it cannot read/open the database. But by
running dbsrv7 from a batch file we can start the database
successfully and use dbstop to stop the server. Why can we
not start and stop the service through Sybase Central
4.0.1.751? The server is also running Small Business Server
as well as anti-virus software. Any idea why this would be
happening?
Many thanks

Steve Isaac



We’ve been unable to create and then start a service via
Sybase Central or via the dbsvc command line utility.


Joshua Savill Posted on 2005-08-02 16:55:47.0Z
From: "Joshua Savill" <jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <42ef9cc1.335f.1681692777@sybase.com>
Subject: Re: dbsrv7 on Windows Server 2003
Lines: 31
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Original-NNTP-Posting-Host: jsavill-pc.sybase.com
Message-ID: <42efa590@forums-2-dub>
X-Original-Trace: 2 Aug 2005 09:55:44 -0700, jsavill-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Aug 2005 09:55:44 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Aug 2005 09:55:47 -0700
X-Trace: forums-1-dub 1123001747 10.22.108.75 (2 Aug 2005 09:55:47 -0700)
X-Original-Trace: 2 Aug 2005 09:55:47 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4664
Article PK: 8467

1) Is the database file and transaction log on a drive local to the server,
or are you attempting to run the files across a network share? If you are
attempting to access the database from a network share, this will not work
with a Windows Service, as the system cannot see the share. Using a network
share, is highly NOT recommended.
2) When creating the Windows Service, is the path to the database correct?

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

<Stephen Isaac> wrote in message news:42ef9cc1.335f.1681692777@sybase.com...
I have just installed ASA 7.0.4.3541 on Windows 2003 Server.
On trying to start a service through Sybase Cenral I get an
error saying that it cannot read/open the database. But by
running dbsrv7 from a batch file we can start the database
successfully and use dbstop to stop the server. Why can we
not start and stop the service through Sybase Central
4.0.1.751? The server is also running Small Business Server
as well as anti-virus software. Any idea why this would be
happening?
Many thanks

Steve Isaac



We've been unable to create and then start a service via
Sybase Central or via the dbsvc command line utility.


Stephen Isaac Posted on 2005-08-03 08:44:55.0Z
Sender: 3365.42ef9ce7.1804289383@sybase.com
From: Stephen Isaac
Newsgroups: ianywhere.public.general
Subject: Re: dbsrv7 on Windows Server 2003
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42f08403.43b0.1681692777@sybase.com>
References: <42efa590@forums-2-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 3 Aug 2005 01:44:51 -0700, 10.22.241.42
Lines: 44
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Aug 2005 01:44:53 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Aug 2005 01:44:55 -0700
X-Trace: forums-1-dub 1123058695 10.22.108.75 (3 Aug 2005 01:44:55 -0700)
X-Original-Trace: 3 Aug 2005 01:44:55 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4665
Article PK: 8470

Just realised that I should have posted this on the
sqlanywhere.public.general newsgroup so sorry about that.
The database and log file are on the server local drive and
the database path is correct and is the same as used in the
batch file which successfully starts the batch file. I was
concerned that there may be conflict with some other
application running on the server?



1) Is the database file and transaction log on a drive

> local to the server, or are you attempting to run the
> files across a network share? If you are attempting to
> access the database from a network share, this will not
> work with a Windows Service, as the system cannot see the
> share. Using a network share, is highly NOT recommended.
> 2) When creating the Windows Service, is the path to the
> database correct?
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
> <Stephen Isaac> wrote in message
> news:42ef9cc1.335f.1681692777@sybase.com... I have just
> installed ASA 7.0.4.3541 on Windows 2003 Server. On trying
> to start a service through Sybase Cenral I get an error
> saying that it cannot read/open the database. But by
> running dbsrv7 from a batch file we can start the database
> successfully and use dbstop to stop the server. Why can we
> not start and stop the service through Sybase Central
> 4.0.1.751? The server is also running Small Business
> Server as well as anti-virus software. Any idea why this
> would be happening?
> Many thanks
>
> Steve Isaac
>
>
>
> We've been unable to create and then start a service via
> Sybase Central or via the dbsvc command line utility.
>
>


Nick Elson Posted on 2005-08-03 13:48:46.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <42efa590@forums-2-dub> <42f08403.43b0.1681692777@sybase.com>
Subject: Re: dbsrv7 on Windows Server 2003
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <42f0cb3e$1@forums-1-dub>
Date: 3 Aug 2005 06:48:46 -0700
X-Trace: forums-1-dub 1123076926 10.25.98.216 (3 Aug 2005 06:48:46 -0700)
X-Original-Trace: 3 Aug 2005 06:48:46 -0700, nicelson-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4666
Article PK: 8472

Services usually run as the local account SYSTEM
[aka LocalSystem in the service management dialogues]

The SYSTEM account actually has no security credentials
or permissions unless explicitly granted to it. The only
(typical) exception is, as a user account, it has always
been part of the Everybody group.

So the bottom line would be the database files and
the director{y|ies}they are located have no permissions
granted to SYSTEM or Everybody. Grant those
permissions and you know how to resolve 99% of our
service starting issues. I'm will to bet that you are in
that 99% category also.

<Stephen Isaac> wrote in message news:42f08403.43b0.1681692777@sybase.com...
> Just realised that I should have posted this on the
> sqlanywhere.public.general newsgroup so sorry about that.
> The database and log file are on the server local drive and
> the database path is correct and is the same as used in the
> batch file which successfully starts the batch file. I was
> concerned that there may be conflict with some other
> application running on the server?
>
>
>
> 1) Is the database file and transaction log on a drive
>> local to the server, or are you attempting to run the
>> files across a network share? If you are attempting to
>> access the database from a network share, this will not
>> work with a Windows Service, as the system cannot see the
>> share. Using a network share, is highly NOT recommended.
>> 2) When creating the Windows Service, is the path to the
>> database correct?
>>
>> --
>> Joshua Savill
>> iAnywhere Solutions - Product Support Analyst
>>
>> <Stephen Isaac> wrote in message
>> news:42ef9cc1.335f.1681692777@sybase.com... I have just
>> installed ASA 7.0.4.3541 on Windows 2003 Server. On trying
>> to start a service through Sybase Cenral I get an error
>> saying that it cannot read/open the database. But by
>> running dbsrv7 from a batch file we can start the database
>> successfully and use dbstop to stop the server. Why can we
>> not start and stop the service through Sybase Central
>> 4.0.1.751? The server is also running Small Business
>> Server as well as anti-virus software. Any idea why this
>> would be happening?
>> Many thanks
>>
>> Steve Isaac
>>
>>
>>
>> We've been unable to create and then start a service via
>> Sybase Central or via the dbsvc command line utility.
>>
>>