SQL Anywhere Mobile - Dbmlsync.exe startup option on PDA

Author

Dbmlsync.exe startup option on PDA

SangMin, Kim

2006-02-03, 3:24 am

Hi, I am poor at English grammar.. bad grammar. sorry ^^;;
We are currently using the ASA 8.0.1 version
and it is synchronizing with the PDA using windows Ce.
I have test_consol.db in my harddisk,and test_remote file in pda.
"dbmlsrv8 -c "dsn=test_consol" -o mlserver.mls -v+ -dl -zu+" execute a
program in harddisk.
but I don't know how dbmlsync.exe action in pda..this topic explain to me

David Fishburn

2006-02-03, 9:24 am

"SangMin, Kim" <sooniettl@nate.com> wrote in news:43e325bf$1@foru
ms-1-dub
of sybase.public.sqlanywhere.mobilink:

....
SK> but I don't know how dbmlsync.exe action in pda..this topic explain to
me

See this previous post for examples:
http://groups.google.com/group/syba...ilink/browse_th
read/thread/587a1ef5613244a5/7f4d304c0bcbdf30?
lnk=st& q=fishburn+pocket+st
art+menu+group%
3Asybase.public.sqlanywhere.mobilink&rnum=1& hl=en#7f4d304c0bcbdf
30

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

SangMin, Kim

2006-02-07, 3:24 am

Thankful, but I can't What I wanted...
I am currently using the ASA 8.0.1(2600) version.

spec,
Pda: Hp ipaq hx4700

dbdsn -w pda_remote -c
" eng=mySrv;uid=dba;pw
d=sql;commlinks=tcpi
p{host=127.0.0.1;
dobroadcast=none}"

this example is DSN naming that pda_remote is connected by usb.

next step.
I wrote from the command line

dbmlsrv8 -c "dsn=pda_remote" -o mlserver.mls -v+ -dl -zu+
//the mobilink synchroniztion server is started.

dbmlsync -c "dsn=test_table" -o dbmlsync.out -v

I wrote from the command line

but error...

I can check that the output screen is displayed to my synchronization has
failed
____________________
____________________
____________________
______
Connecting to remote database
I. 02/07 16:33:53. Loading synchronization information
I. 02/07 16:33:53. Loading synchronization information
I. 02/07 16:33:53. Loading synchronization information
I. 02/07 16:33:53. Begin synchronizing 'emp_cust' for MobiLink user
'ml_user'
I. 02/07 16:33:53. Options for this synchronization:
I. 02/07 16:33:53. CTP='tcpip',ADR='hos
t=localhost'
E. 02/07 16:33:53. Missing transaction log(s) after file "C:\Program
Files\Sybase\SQL Anywhere 8\Samples\MobiLink\A
utoScripting\060203A
A.LOG"
(ends at offset 0000353103) and the on-line transaction log starts at offset
0000360438.
I. 02/07 16:33:53. Hovering at end of active log
E. 02/07 16:33:53. Upload aborted at offset 0000353015
E. 02/07 16:33:53. Download aborted
I. 02/07 16:33:53. Execution completed
I. 02/07 16:33:53. Disconnecting from remote database
____________________
____________________
____________________
______

this error is a problem that must be solved as soon as possible..
give me a solution ...

Greg Fenton

2006-02-07, 9:24 am

SangMin, Kim wrote:
>
> dbdsn -w pda_remote -c
> " eng=mySrv;uid=dba;pw
d=sql;commlinks=tcpi
p{host=127.0.0.1;
> dobroadcast=none}"
>

I'm a bit confused. Is the database running on the PDA or on the
desktop machine? 127.0.0.1 is the loopback of the current machine and
since the dbdsn utility is not available for PDAs, then the above DSN
creation would connect to a server running on the current desktop.

To connect to the PDA, assuming it is connected using ActiveSync, you
would use "host=192.168.55.101".

> dbmlsrv8 -c "dsn=pda_remote" -o mlserver.mls -v+ -dl -zu+
> //the mobilink synchroniztion server is started.

So this has ML connecting to the DSN "pda_remote", which would be the
*consolidated* and not the *remote*.

> E. 02/07 16:33:53. Missing transaction log(s) after file "C:\Program
> Files\Sybase\SQL Anywhere 8\Samples\MobiLink\A
utoScripting\060203A
A.LOG"
> (ends at offset 0000353103) and the on-line transaction log starts at offset
> 0000360438.

What this says is that the database (the one that "dsn=test_table"
connects to) has had its transaction log renamed during backup
processes, that one of the backed up files is 060203AA.LOG which
contains log offsets up to 0000353103, and that there is supposed to be
at least one other renamed transaction log after that one that contains
offset 0000360438.

But again, I am somewhat confused. If this is a remote database on a
PDA, then why is its transaction log being backed up to C:\Program
Files\Sybase\...., which is most likely a desktop machine ?

> this error is a problem that must be solved as soon as possible..
> give me a solution ...

These newsgroups are run on a voluntary basis; they are not official
technical support forums. For official and/or speedy resolution to
problems, please contact iAnywhere Technical Support:

http://www.ianywhere.com/support/co...ct_support.html

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sang Min, Kim

2006-02-08, 3:24 am

Greg Fenton, thanks for your reply.

I'm currently using asa 8.0.1(2600).
[color=darkred]

Database running both on the pda and desktop
there are database server in the pda and desktop database.
ip: "127.0.0.1" and 2638 port.
certainly I started connected pda by activeSync.
/**
dbisql -c
" eng=mySrv;uid=dba;pw
d=sql;commlinks=tcpi
p{host=127.0.0.1;dobroadcast=none}"
*/
I has confirmed command line and SQL query in desktop machine
before I execute the command, I started server on pda.

[color=darkred]

yes, It's connected using activesync,
I use "host=127.0.0.1" however, This IP is connected using activeSync.

I know how to do in desktop with two database.
I want to know how to synchronize between pda and desktop.
give a outline.

David Fishburn

2006-02-08, 9:24 am

"Sang Min, Kim" <sooniettl@nate.com> wrote in news:43e99342@forums
-2-dub
of sybase.public.sqlanywhere.mobilink:

SMK> I know how to do in desktop with two database.
SMK> I want to know how to synchronize between pda and desktop.
SMK> give a outline.

Well, start with the Help under this book:
MobiLink Tutorials

1. When you created the publication/sync user/sync subscription what
address did you provide for the MobiLink server?

2. When you create the dbmlsync shortcut on the PDA (in the Start Menu
folder), did you override the ML server address via the command
line? That might be necessary depending on what you did in 1 above.
dbmlsync ... -e adr="host=192.168.55.100"

As long as the MobiLink server is running on your desktop and you are
connected via ActiveSync, that should work.

If it is not then we need the following information:
1. MobiLink server command line
2. Is the ML server running
3. dbunload run against the remote database using -n (no schema), from
the reload.sql file it creates we want all the information in the
"REMOTE DEFINITIONS" section.
4. The dbmlsync command line.
5. Start ML server with -v+ -ot ml.txt
6. Start dbmlsync with -v+ -o rem.txt
7. Include both the ml.txt and the rem.txt in your output.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links