SQL Anywhere database replication - DBRemote window not closing

Author

DBRemote window not closing

jclanton@propertyboss.com

2006-02-01, 8:25 pm

We are on ASA 8.03 running SQLRemote.

We have DBRemote scheduled to run every hour using Windows Task
Scheduler. We run the following batch file:

echo on
dbremote -c "dsn=cb;uid=*;pwd=*" -b -t -k -v -o cb.txt

95% of the time, the dbremote runs and the windows closes. Once a day
or so, dbremote runs and leaves the window open.

It ran successfully and has completed, the window just won't close.

I've read where you need the -k and -o option which we have, but it
hasn't made a difference.

Thanks,

James Clanton
PropertyBoss Solutions

Reg Domaratzki \(iAnywhere Solutions\)

2006-02-03, 9:23 am

Most of the time when I see this problem, it's because dbremote has an open
port to another machine that is in the process of timing out, which could
take as long as 4 hours if your Windoze machine is using the defaults. When
dbremote refuses to shut down, if you run tcpview from www.sysinternals.com,
can you see that dbremote still has a port open to another machine?

--
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/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

< jclanton@propertybos
s.com> wrote in message
news:ol72u11avb4pnvj
vsrdm08c86rf6v1b3q0@
4ax.com...
>
> We are on ASA 8.03 running SQLRemote.
>
> We have DBRemote scheduled to run every hour using Windows Task
> Scheduler. We run the following batch file:
>
> echo on
> dbremote -c "dsn=cb;uid=*;pwd=*" -b -t -k -v -o cb.txt
>
> 95% of the time, the dbremote runs and the windows closes. Once a day
> or so, dbremote runs and leaves the window open.
>
> It ran successfully and has completed, the window just won't close.
>
> I've read where you need the -k and -o option which we have, but it
> hasn't made a difference.
>
> Thanks,
>
> James Clanton
> PropertyBoss Solutions

Sponsored Links