SQL Anywhere Mobile - mobilink, collation problem + connect problem.

Author

mobilink, collation problem + connect problem.

R. van der Wiele

2005-05-13, 11:24 am

Does someone knows this problem:

Situation:
Mobilink synchronization beteen desktop/server and pda:
ASA version on the pda was: 8.03.5002
ASA version on desktop was: 8.02.4301

I want to synchronize, look in the log file, ok, except for an error/warning
message 'Unable to convert the string ... from the system collation to the
database collation'.
After searching i found that de ASA version on the desktop (server) was
lower than on the PDA, i thought that that was the culprit.
After upgrading on de desktop/server to 8.03.5002, mobilink and ASA all had
the same version and build!
I even upgraded the databases (in Sybase Central).

But now, the error stayed the same _and_ i got an extra error; 'Unable to
connect to remote database' SQLCode = -140.

I'm confused
Does anyone knows the solution???

Thanks in advance,
Ron van der Wiele
ACI

Ron van der Wiele

2005-05-15, 11:23 am

Update: upgraded the server (consolidated database) to build 5223, the
problem stays.

Ron van der Wiele

David Fishburn

2005-05-16, 7:24 am

"R. van der Wiele" <r.vd.wiele@aci.nl> wrote in
news:4284cd23$1@foru
ms-1-dub of sybase.public.sqlanywhere.mobilink:

RvdW> Does someone knows this problem:
RvdW>
RvdW> Situation:
RvdW> Mobilink synchronization beteen desktop/server and pda:
RvdW> ASA version on the pda was: 8.03.5002
RvdW> ASA version on desktop was: 8.02.4301
RvdW>
RvdW> I want to synchronize, look in the log file, ok, except for an
RvdW> error/warning message 'Unable to convert the string ... from the
RvdW> system collation to the database collation'.
RvdW> After searching i found that de ASA version on the desktop (server)
RvdW> was lower than on the PDA, i thought that that was the culprit.
RvdW> After upgrading on de desktop/server to 8.03.5002, mobilink and ASA
RvdW> all had the same version and build!
RvdW> I even upgraded the databases (in Sybase Central).
RvdW>
RvdW> But now, the error stayed the same _and_ i got an extra error;
'Unable
RvdW> to connect to remote database' SQLCode = -140.

Okay, this is where you need to turn on heavy verbosity, and post it, so
we can see it.

Start ML using -v+ -o ml.txt
Start dbmlsync with:
-v+ (or just -v if syntax error) and -o rem.txt -e Verbose=on

Post the output.

Specify what is your consolidated database? Is it ASA, Oracle, SQL
Server, ...
Include the version of the software used to run it.

What code page was used to create the consolidated?
If it is ASA, then run dbinfo against it (from a command prompt) and
post the 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]

Ron van der Wiele

2005-05-16, 11:24 am

Hi, thanks for the reply, if I use the parameters as you say I get an error
message; error in command near "".
If I strip: -o rem.txt, I don't (thus the culprit is '-o rem.txt' ?)
So I can't log the output from dbmlsync!
Ron van der Wiele, ACI

<snip>
> Okay, this is where you need to turn on heavy verbosity, and post it, so
> we can see it.
>
> Start ML using -v+ -o ml.txt
> Start dbmlsync with:
> -v+ (or just -v if syntax error) and -o rem.txt -e Verbose=on
>
> Post the output.
>
> Specify what is your consolidated database? Is it ASA, Oracle, SQL
> Server, ...
> Include the version of the software used to run it.
>
> What code page was used to create the consolidated?
> If it is ASA, then run dbinfo against it (from a command prompt) and
> post the output.
>
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services

Ron van der Wiele

2005-05-16, 1:23 pm

<snip>

Further info:

Consolidated database (as the remote): ASA
Codepage: 1252

Output from dbinfo:

SERVER/CONSOLIDATED:

Adaptive Server Anywhere Information Utility Version 8.0.3.5223
Database : C:\gercomobile\gerco
mobile.db
Log file : C:\gercomobile\Gerco
Mobile.log
Log mirror: none
Compressed: No
Page size : 1024
Encrypted : No
Strings padded with blanks for comparisons: No
Respect letter-case when comparing: No ('A' equal to 'a')
Collation sequence: 1252LATIN1 (Code Page 1252, Windows Latin 1, Western)
Java classes installed: No

PDA/REMOTE (copied the database from the pda to this dir. and run dbinfo):

Adaptive Server Anywhere Information Utility Version 8.0.3.5223
Database : C:\gercomobile\pda\g
ercomobile.db
Log file : C:\gercomobile\pda\G
ercoMobile.log
Log mirror: none
Compressed: No
Page size : 1024
Encrypted : No
Strings padded with blanks for comparisons: No
Respect letter-case when comparing: No ('A' equal to 'a')
Collation sequence: 1252LATIN1 (Code Page 1252, Windows Latin 1, Western)
Java classes installed: No

Breck Carter [TeamSybase]

2005-05-16, 1:24 pm

Show us the command line you are using.

FWIW here is a command line that works:

" %ASANY9%\win32\dbmls
ync.exe" -c " ENG=remo;DBN=remo;UI
D=DBA;PWD=SQL"
-e adr=host=localhost;s
v=v1 -o dbmlsync_remo_log.txt -v+

Breck

On 16 May 2005 09:15:22 -0700, "Ron van der Wiele" <rwiele@zonnet.nl>
wrote:

>Hi, thanks for the reply, if I use the parameters as you say I get an error
>message; error in command near "".
>If I strip: -o rem.txt, I don't (thus the culprit is '-o rem.txt' ?)
>So I can't log the output from dbmlsync!
>Ron van der Wiele, ACI
>
><snip>
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Ron van der Wiele

2005-05-16, 1:24 pm

Commandline that is used (thus on de pda (win CE), 'commandline' is typed
in when dbmlsync is started on; 'Command switches:'
Extended option '-e' on 'Extended options' ):

Ron van der Wiele

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:k0nh81pqnaf70ds
7gpil5v3uv7rj0j151e@
4ax.com...
> Show us the command line you are using.

<snip>

Breck Carter [TeamSybase]

2005-05-16, 1:24 pm

On 16 May 2005 11:02:43 -0700, "Ron van der Wiele" <rwiele@zonnet.nl>
wrote:

>Commandline that is used (thus on de pda (win CE), 'commandline' is typed
>in when dbmlsync is started on; 'Command switches:'
>Extended option '-e' on 'Extended options' ):

I don't understand, sorry!

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Ron van der Wiele

2005-05-16, 1:24 pm

OK, let's first say that Adaptive Server Anywhere is used on the PDA:
Windows CE 4.0
The syncing of the data should be going automatically, but for now I start
dbmlsync with hand!
I get a startupwindow 'Dbmlsync startup options', where I get to fill in
some options.
The options I use are: ''Command switches:' and 'Extended options:'
Please note that we are still talking about ASA 8.0.3.5002 (see first post)
Ron

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:jioh81hv88skarq
sj5ohol4k7dcpj0as4p@
4ax.com...
> On 16 May 2005 11:02:43 -0700, "Ron van der Wiele" <rwiele@zonnet.nl>
> wrote:
>
typed[color=darkred]

>
> I don't understand, sorry!
>
> Breck

Ron van der Wiele

2005-05-16, 8:24 pm

Correction: Windows CE 4.0 is Windows CE 4.20 build 0

Breck Carter [TeamSybase]

2005-05-16, 8:24 pm

The interactive setup is rather awkward; have you tried using a batch
file?

Is there a checkbox "Display debugging information in a log file"? If
so, check it, and fill in the "Log file:" field.

Breck

On 16 May 2005 11:28:41 -0700, "Ron van der Wiele" <rwiele@zonnet.nl>
wrote:

>OK, let's first say that Adaptive Server Anywhere is used on the PDA:
>Windows CE 4.0
>The syncing of the data should be going automatically, but for now I start
>dbmlsync with hand!
>I get a startupwindow 'Dbmlsync startup options', where I get to fill in
>some options.
>The options I use are: ''Command switches:' and 'Extended options:'
>Please note that we are still talking about ASA 8.0.3.5002 (see first post)
>Ron
>
>
>"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
>message news:jioh81hv88skarq
sj5ohol4k7dcpj0as4p@
4ax.com...
>typed
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Ron van der Wiele

2005-05-16, 8:24 pm

There's no checkbox for creating a logfile.
On Windows CE, there's no way to call a batchfile (at least I didn't find
any).
So I must call dbmlsync from my windows CE program (that was initially also
the purpose)
But that can't be done until tonorrow :(

Ron

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:i8qh81ld9ge464n
k42db1mph9250rm7lle@
4ax.com...
> The interactive setup is rather awkward; have you tried using a batch
> file?
>
> Is there a checkbox "Display debugging information in a log file"? If
> so, check it, and fill in the "Log file:" field.
>
> Breck

<snip>

Reg Domaratzki $iAnywhere Solutions$

2005-05-16, 8:24 pm

You need to create a shortcut to call dbmlsync. Assuming that you want to
execute :

"\Program Files\Sybase\ASA9\db
mlsync" -c " eng=e1;uid=dba;pwd=s
ql" -mp
sql -v+ -o synch.txt -k

You create a file called "synch.lnk" on you desktop with the following
contents and place it somewhere on your CE device:

98#"\Program Files\Sybase\ASA9\db
mlsync" -c " eng=e1;uid=dba;pwd=s
ql" -mp
sql -v+ -o synch.txt -k

The "98#" placed at the beginning of the file is the total size of the
shortcut BTW. It will likely be different for your shortcut. Also note
that the total size INCLUDES the size of text you had to specify the total
size.

--
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

"Ron van der Wiele" <rwiele@zonnet.nl> wrote in message
news:4288f752$1@foru
ms-2-dub...
> There's no checkbox for creating a logfile.
> On Windows CE, there's no way to call a batchfile (at least I didn't find
> any).
> So I must call dbmlsync from my windows CE program (that was initially
also
> the purpose)
> But that can't be done until tonorrow :(
>
> Ron
>
> "Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
> message news:i8qh81ld9ge464n
k42db1mph9250rm7lle@
4ax.com...
>
> <snip>
>
>

Breck Carter [TeamSybase]

2005-05-16, 8:24 pm

Do you have cmd.exe on the device?

If so...

=====
Newsgroups: microsoft.public.handheldpc
From: "Reiner Medgenberg" <Medgenb...@gmx.de>
Date: Wed, 13 Feb 2002 00:47:48 +0100
Local: Tues,Feb 12 2002 6:47 pm
Subject: Re: Batch like BAT or CMD with Windows CE CMD.EXE ?
....
1. You may type the name of the BAT file inside CMD.EXE

2. Or one can have executed even the BAT file directly:
CMD [/c | /k] [{path name}\]{file name}[.BAT]

3. Or create a shortcut on CMD.EXE and the the BAT file as parameter:
\Windows\cmd.exe [/c | /k] [{path name}\]{file name}[.BAT]
=====

Breck

On 16 May 2005 12:41:11 -0700, "Ron van der Wiele" <rwiele@zonnet.nl>
wrote:

>There's no checkbox for creating a logfile.
>On Windows CE, there's no way to call a batchfile (at least I didn't find
>any).
>So I must call dbmlsync from my windows CE program (that was initially also
>the purpose)
>But that can't be done until tonorrow :(
>
>Ron
>
>"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
>message news:i8qh81ld9ge464n
k42db1mph9250rm7lle@
4ax.com...
>
><snip>
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

R. van der Wiele

2005-05-17, 3:24 am

<snip>

Logfile (rem.txt) is:

I. 04/23 04:35:11. Synchronization Started
I. 04/23 04:35:11. 1: -c
I. 04/23 04:35:11. 2: ***************
I. 04/23 04:35:11. 3: -n
I. 04/23 04:35:11. 4: gercomobile
I. 04/23 04:35:11. 5: -u
I. 04/23 04:35:11. 6: 537
I. 04/23 04:35:11. 7: -mp
I. 04/23 04:35:11. 8: ***
I. 04/23 04:35:11. 9: -v+
I. 04/23 04:35:11. 10: -e
I. 04/23 04:35:11. 11: verbose=on
I. 04/23 04:35:11. ASA MobiLink Synchronization Version 8.0.3.5002
I. 04/23 04:35:11.
I. 04/23 04:35:11. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004, iAnywhere Solutions, Inc.
I. 04/23 04:35:11. All rights reserved. All unpublished rights reserved.
I. 04/23 04:35:12.
I. 04/23 04:35:12. This software contains confidential and trade secret
information of
I. 04/23 04:35:12. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 04/23 04:35:12. by the U.S. Government is subject to restrictions set
forth in a license
I. 04/23 04:35:12. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 04/23 04:35:12. other written agreement specifying the Government's
rights to use the
I. 04/23 04:35:12. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 04/23 04:35:12.
I. 04/23 04:35:12. Sybase, Inc., One Sybase Drive, Dublin, CA 94568, USA
I. 04/23 04:35:12.
I. 04/23 04:35:12. Connecting to remote database
W. 04/23 04:35:12. Unable to convert the string "537" from the system
collation to the database collation.
E. 04/23 04:35:12. Unable to connect to remote database. SQLCode = -140.

David Fishburn

2005-05-20, 3:24 am

"R. van der Wiele" <r.vd.wiele@aci.nl> wrote in
news:4289a7bb$1@foru
ms-2-dub of sybase.public.sqlanywhere.mobilink:

I see Reg responded to your new thread today, sorry I have been very
busy.
--
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