SQL Anywhere database replication - SQL Remote tutorial error

Author

SQL Remote tutorial error

dominiek hots

2005-08-11, 3:24 am

Hi,
I'm getting an error trying to complete the SQL Remote
tutorial from the SQL Remote manual.
When I want to start replicating using 'dbremote', I get
this error :

SQL statement failed: (-75) Request to start/stop database
denied
E. 08/11 09:15:44. Error connecting to database

The server is started with -gd all -gk all option, the HQ db
is running on this server.

I am using Adaptive Server Anywhere 8.0.3.5267

Anyone has any ideas.

Reg Domaratzki \(iAnywhere Solutions\)

2005-08-12, 9:24 am

Can you show the exact command you used to start the database engine ( and
mount the HQ database ) as well as the dbremote command line you used.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<dominiek hots> wrote in message news:42fafcc7.5586.1681692777@sybase.com...
> Hi,
> I'm getting an error trying to complete the SQL Remote
> tutorial from the SQL Remote manual.
> When I want to start replicating using 'dbremote', I get
> this error :
>
> SQL statement failed: (-75) Request to start/stop database
> denied
> E. 08/11 09:15:44. Error connecting to database
>
> The server is started with -gd all -gk all option, the HQ db
> is running on this server.
>
> I am using Adaptive Server Anywhere 8.0.3.5267
>
> Anyone has any ideas.

Paul

2005-10-27, 7:41 am

I had the same problem as you, found the problem was resolved by shutting down
other ASA db's we had running on the server (even though ports assigned to the
other db's were checked and were correctly assigned), then restarting the db
which we needed dbremote to connect to.

In future when rebooting our server we will only have our production db start
automatically, test db's will need to be manually started.

Regards - Paul

On 12 Aug 2005 05:25:16 -0700,
in sybase.public.sqlanywhere.replication
Reg Domaratzki \(iAnywhere Solutions\) <FirstName.LastName@ianywhere.com> wrote:
>Can you show the exact command you used to start the database engine ( and
>mount the HQ database ) as well as the dbremote command line you used.
>
>--
>Reg Domaratzki, Sybase iAnywhere Solutions
>Sybase Certified Professional - Sybase ASA Developer Version 8
>Please reply only to the newsgroup
>
>iAnywhere Developer Community : http://www.ianywhere.com/developer
>iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
>ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
><dominiek hots> wrote in message news:42fafcc7.5586.1681692777@sybase.com...
>
>

Sponsored Links