SQL Anywhere Mobile - mobilink synchronization errors

Author

mobilink synchronization errors

R. van der Wiele

2005-05-19, 7:24 am

I have a synchronisation problem:

Situation:
Mobilink synchronization beteen desktop/server and pda:

ASA version on the pda was: 8.03.5002
ASA version on desktop was: 8.03.5002 (upgraded from 8.02.4301)
Codepage databases: 1252
Upgraded the databases in Sybase Central to the new version (to be sure).
Consolidated database is on the desktop, synchronisation started from pda.

I synchronise, got an error; 'Unable to convert the string ... from the
system collation to the
database collation'.

With version 8.02.4301 on the desktop that was the only error, after
upgrading the desktop to
version 8.03.5002, I got an extra error;
'Unable to connect to remote database' SQLCode = -140.

I thought upgrading was necessary because the version of sybase was at first
lower on the
desktop (not good I think).

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

Below are the dbmlsync command line used _and_ the logfile generated.

Ron van der Wiele

====================
=================
COMMAND LINE:
dbmlsync.exe -c dsn=gercomobile -n gercomobile -u 537 -mp sql -v+ -o
rem.txt -e verbose=ON

====================
=================
LOGFILE:

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

====================
===================

DBINFO:

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

Reg Domaratzki $iAnywhere Solutions$

2005-05-19, 9:23 am

What happens if you specify your connection parameters in the -c switch of
dbmlsync instead of the DSN? I.e. instead of -c dsn=gercomobile, use -c
" dbf=\Application\ger
comobile.db;uid=dba;pwd=sql". I'm not familiar with
using ODBC on CE devices, so I'm just trying to eliminate one of the things
I'm not familiar with to see where the problem may lie.

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

"R. van der Wiele" <r.vd.wiele@aci.nl> wrote in message
news:428c557e@forums
-1-dub...
> I have a synchronisation problem:
>
> Situation:
> Mobilink synchronization beteen desktop/server and pda:
>
> ASA version on the pda was: 8.03.5002
> ASA version on desktop was: 8.03.5002 (upgraded from 8.02.4301)
> Codepage databases: 1252
> Upgraded the databases in Sybase Central to the new version (to be sure).
> Consolidated database is on the desktop, synchronisation started from pda.
>
> I synchronise, got an error; 'Unable to convert the string ... from the
> system collation to the
> database collation'.
>
> With version 8.02.4301 on the desktop that was the only error, after
> upgrading the desktop to
> version 8.03.5002, I got an extra error;
> 'Unable to connect to remote database' SQLCode = -140.
>
> I thought upgrading was necessary because the version of sybase was at
first

> lower on the
> desktop (not good I think).
>
> I'm confused
> Does anyone knows the solution???
>
> Below are the dbmlsync command line used _and_ the logfile generated.
>
> Ron van der Wiele
>
> ====================
=================
> COMMAND LINE:
> dbmlsync.exe -c dsn=gercomobile -n gercomobile -u 537 -mp sql -v+ -o
> rem.txt -e verbose=ON
>
> ====================
=================
> LOGFILE:
>
> I. 05/19 10:28:47. Synchronization Started
> I. 05/19 10:28:47. 1: -c
> I. 05/19 10:28:47. 2: ***************
> I. 05/19 10:28:48. 3: -n
> I. 05/19 10:28:48. 4: gercomobile
> I. 05/19 10:28:48. 5: -u
> I. 05/19 10:28:48. 6: 537
> I. 05/19 10:28:48. 7: -mp
> I. 05/19 10:28:48. 8: ***
> I. 05/19 10:28:48. 9: -v+
> I. 05/19 10:28:48. 10: -e
> I. 05/19 10:28:48. 11: verbose=ON
> I. 05/19 10:28:48. ASA MobiLink Synchronization Version 8.0.3.5002
> I. 05/19 10:28:48.
> I. 05/19 10:28:48. Copyright © 1989-2004 Sybase, Inc.
> Portions Copyright © 2002-2004, iAnywhere Solutions,
Inc.
> I. 05/19 10:28:48. All rights reserved. All unpublished rights reserved.
> I. 05/19 10:28:48.
> I. 05/19 10:28:48. This software contains confidential and trade secret
> information of
> I. 05/19 10:28:48. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the software and
> documentation
> I. 05/19 10:28:49. by the U.S. Government is subject to restrictions set
> forth in a license
> I. 05/19 10:28:49. agreement between the Government and iAnywhere
Solutions,
> Inc. or
> I. 05/19 10:28:49. other written agreement specifying the Government's
> rights to use the
> I. 05/19 10:28:49. software and any applicable FAR provisions, for
example,
> FAR 52.227-19.
> I. 05/19 10:28:49.
> I. 05/19 10:28:49. Sybase, Inc., One Sybase Drive, Dublin, CA 94568, USA
> I. 05/19 10:28:49.
> I. 05/19 10:28:49. Connecting to remote database
> W. 05/19 10:28:49. Unable to convert the string "537" from the system
> collation to the database collation.
> E. 05/19 10:28:49. Unable to connect to remote database. SQLCode = -140.
>
> ====================
===================
>
> DBINFO:
>
> DESKTOP/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
>
>
>

R. van der Wiele

2005-05-19, 1:24 pm

Hi Greg, that was the problem, how strange.
Thanks for the time.
Ron van der Wiele

"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:428ca296$1@foru
ms-1-dub...
> What happens if you specify your connection parameters in the -c switch of
> dbmlsync instead of the DSN? I.e. instead of -c dsn=gercomobile, use -c
> " dbf=\Application\ger
comobile.db;uid=dba;pwd=sql". I'm not familiar with
> using ODBC on CE devices, so I'm just trying to eliminate one of the
things
> I'm not familiar with to see where the problem may lie.
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup

Breck Carter [TeamSybase]

2005-05-19, 8:24 pm

Wow, that was voodoo :)... we're sorry it took so long to figure out.

Breck

(Reg must be a Sith, he as *dark* powers :)

On 19 May 2005 10:08:06 -0700, "R. van der Wiele" <r.vd.wiele@aci.nl>
wrote:

>Hi Greg, that was the problem, how strange.
>Thanks for the time.
>Ron van der Wiele
>
>"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
>wrote in message news:428ca296$1@foru
ms-1-dub...
>things
>

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

Sponsored Links