Running Sync from network PC - 07-14-2006 , 04:17 AM
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
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
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
---== Posted via the PFCGuide Web Newsreader ==---
Re: Running Sync from network PC - 07-14-2006 , 07:41 AM
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
"Risteard" <rmaccionnaith (AT) hotmail (DOT) com> wrote
Re: Running Sync from network PC - 07-14-2006 , 07:57 AM
On 14 Jul 2006 05:41:40 -0700,
Reg Domaratzki <firstname.lastname (AT) ianywhere (DOT) com> wrote: