I have set up a remote database on a local server. This in turn communicates
with the consolidated database on the web server using dbmlsync.
My issue is as follows.
I want different users to synchronise the remote database on the local server
with the consolidated database. There is an issue however in that when my
clients run the mobilink sync routine from their local PC an error occurs. I
use Visual Basic 6 to create a windows batch file to execute the dbmlsync
routine.
I use the following connection string
dbmlsync.exe -d -c DSN=testremote;UID=DBA;PWD=xxx;DBKEY=yyy -n testname -u 100
-ot c:\temp\testname.log -ra -v+ -x

The error is as follows I. 06/15 20:46:18. Processing transaction logs from
directory "D:\xxx\yyy"
E. 06/15 20:46:18. Cannot open transaction log directory "D:\xxx\yyy"
This, I believe is because the mobilink command is run on a local PC which
access the remote database on the local server. The server pc that holds the
remote database has the transaction log located in that directory but not the
local PC that runs the dbmlsync command
Does this mean it is only possible to synchronise from the same machine as where
the remote database resides?
I have tried to run xp_cmdshell from a stored procedure but again this has
proved unsuccessful.
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp

It means that the machine that is running dbmlsync needs access to the
offline transaction logs. The last option on the dbmlsyn command line can
be the loaction of the offline transaction logs. If you change your command
to somthing similar to the command below, it should work :

dbmlsync.exe -d -c DSN=testremote;UID=DBA;PWD=xxx;DBKEY=yyy -n testname -u
100 -ot c:\temp\testname.log -ra -v+ -x \\server_name\share\xxx\yyy


Reg

"Risteard" <rmaccionnaith (AT) hotmail (DOT) com> wrote

On 14 Jul 2006 05:41:40 -0700,
in sybase.public.sqlanywhere.mobilink
Reg Domaratzki <firstname.lastname (AT) ianywhere (DOT) com> wrote:
let you know how we get on