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.

sqlanywhere 11.01 unload-reload request to start/stop database denied in task schedular

2 posts in General Discussion Last posting was on 2012-10-30 01:38:42.0Z
Frank Root Posted on 2012-10-29 12:45:46.0Z
From: Frank Root <frank.root@zenware.com>
Newsgroups: ianywhere.public.general
Subject: sqlanywhere 11.01 unload-reload request to start/stop database denied in task schedular
Message-ID: <MPG.2af8285289cf184e989680@forums.sybase.com>
Organization: Zenware
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
User-Agent: MicroPlanet-Gravity/3.0.4
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 29 Oct 2012 04:45:46 -0800
X-Trace: forums-1-dub 1351514746 172.20.134.152 (29 Oct 2012 04:45:46 -0800)
X-Original-Trace: 29 Oct 2012 04:45:46 -0800, vip152.sybase.com
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8172
Article PK: 7186

I have a batch file that runs fine in a DOS window, but fails when run
through the task scheduler. Here is the line that fails:

dbunload -c "uid=dba;pwd=sql;dbf=c:\DB\bu\prior\MyDB.db" -an c:\db
\MyDB.db >> %reloadlog% 2>&1

which gives the following error in %reloading% log file:
SQL Anywhere Unload Utility Version 11.0.1.2405
Connecting and initializing
***** SQL error: Request to start/stop database denied

In both cases I am using the same user (Administrator).


John Smirnios [Sybase] Posted on 2012-10-30 01:38:42.0Z
From: "John Smirnios [Sybase]" <smirnios_at_sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121010 Thunderbird/16.0.1
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: sqlanywhere 11.01 unload-reload request to start/stop database denied in task schedular
References: <MPG.2af8285289cf184e989680@forums.sybase.com>
In-Reply-To: <MPG.2af8285289cf184e989680@forums.sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <508f2fa2@forums-1-dub>
Date: 29 Oct 2012 17:38:42 -0800
X-Trace: forums-1-dub 1351561122 172.20.134.152 (29 Oct 2012 17:38:42 -0800)
X-Original-Trace: 29 Oct 2012 17:38:42 -0800, vip152.sybase.com
Lines: 34
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8173
Article PK: 7185

By default when attempting to start a new database on a network server,
you must connect as DBA to a database that is already running. It is not
sufficient to attempt to try to connect to database that *isn't* already
running with DBA authority (because that would mean that anyone would be
able to start a database, albeit temporarily, so that we could check DBA
rights). Alternatively you can change the permissions required to start
databases. See the -gk switch:
http://dcx.sybase.com/index.html#1201/en/dbadmin/gk-database-dbengine.html*d5e13656

-john.

John Smirnios
Senior Staff Software Developer
iAnywhere Solutions Engineering

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

On 2012/10/29 8:45 AM, Frank Root wrote:
> I have a batch file that runs fine in a DOS window, but fails when run
> through the task scheduler. Here is the line that fails:
>
> dbunload -c "uid=dba;pwd=sql;dbf=c:\DB\bu\prior\MyDB.db" -an c:\db
> \MyDB.db >> %reloadlog% 2>&1
>
> which gives the following error in %reloading% log file:
> SQL Anywhere Unload Utility Version 11.0.1.2405
> Connecting and initializing
> ***** SQL error: Request to start/stop database denied
>
> In both cases I am using the same user (Administrator).
>
>