Get get HotSync to work

Hi,

I'm having problems synchronizing my custom Ultra-Lite application.  
After a HotSync the log file looks as follows:

HotSync operation started 11/06/01 03:47:36 PM
Expense - sync configured to Do Nothing
Outlook Calendar - sync configured to Do Nothing
Outlook Contacts - sync configured to Do Nothing
Outlook Tasks - sync configured to Do Nothing
Outlook Notes - sync configured to Do Nothing
Unable to open the stream 11/06/01 03:47:40 PM
OK PalmTCS (Adaptive Server Anywhere Conduit) with 1 message(s) 11/06/01
03:47:40 PM
OK System

Yet, the MobilLink Server still says:

I. 11/06 14:59:47. Sybase Adaptive Server Anywhere MobiLink Version 7.0.3.2067
I. 11/06 14:59:47. 
I. 11/06 14:59:47. This software contains confidential and trade secret
information of 
I. 11/06 14:59:47. Sybase, Inc.  Use, duplication or disclosure of the software
and 
I. 11/06 14:59:47. documentation by the U.S. Government is subject to
restrictions set forth 
I. 11/06 14:59:47. in a license agreement between the Government and Sybase,
Inc. or other 
I. 11/06 14:59:47. written agreement specifying the Government's rights to use
the software 
I. 11/06 14:59:47. and any applicable FAR provisions, for example, FAR
52.227-19.
I. 11/06 14:59:48.  
I. 11/06 14:59:48. Copyright 1989-2001 Sybase, Inc.  All rights reserved.
I. 11/06 14:59:48. All unpublished rights reserved.
I. 11/06 14:59:48.  
I. 11/06 14:59:48. Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
I. 11/06 14:59:48. 
I. 11/06 14:59:48. Networked Seat (per-seat) model. Access to the server is
limited to 1 seat(s).
                   This server is licensed to:
I. 11/06 14:59:48.     Lehman Brothers
I. 11/06 14:59:48.     Lehman Brothers
I. 11/06 14:59:48. Synchronization Server started
I. 11/06 14:59:48. Option 1: -x
I. 11/06 14:59:48. Option 2: tcpip
I. 11/06 14:59:48. Option 3: -c
I. 11/06 14:59:48. Option 4: ****************
I. 11/06 14:59:48. Option 5: -vcrs
I. 11/06 14:59:48. Verbose logging: show row values
I. 11/06 14:59:48. Verbose logging: show script names when invoked
I. 11/06 14:59:48. Verbose logging: show script contents when invoked
I. 11/06 14:59:48. Individual database connections will be closed after
synchronization errors.
I. 11/06 14:59:48. BLOB cache size: 0
I. 11/06 14:59:48. Maximum number of BLOB bytes to compare: 4294967295
I. 11/06 14:59:48. Maximum number of database connections: 6
I. 11/06 14:59:48. Maximum number of deadlock retries: 10
I. 11/06 14:59:48. Maximum delay between retries after deadlock: 30 seconds
I. 11/06 14:59:48. Rowset size: 10
I. 11/06 14:59:48. Upload cache size: 524288 bytes
I. 11/06 14:59:48. Number of worker threads: 5
I. 11/06 14:59:48. Maximum number of threads uploading concurrently: 5
I. 11/06 14:59:48. Warning: Unknown users will be added automatically (when
there is no authenticate_user script).
I. 11/06 14:59:48. Stream specifier 1: tcpip
I. 11/06 14:59:48. ODBC DBMS Name: Adaptive Server Anywhere
I. 11/06 14:59:48. ODBC DBMS Version: 07.00.0000
I. 11/06 14:59:48. ODBC DBMS Driver Version: 07.00.0003
I. 11/06 14:59:48. ODBC Version supported by the driver: 3.51
I. 11/06 14:59:48. Collation sequence of the consolidated database is 'cp1252'
I. 11/06 14:59:48. ODBC isolation set to: Read Committed
I. 11/06 14:59:48. Connected
I. 11/06 14:59:48. <thread 1.1>: Ready to handle requests
I. 11/06 14:59:48. <thread 1.2>: Ready to handle requests
I. 11/06 14:59:48. <thread 1.3>: Ready to handle requests
I. 11/06 14:59:48. <thread 1.4>: Ready to handle requests
I. 11/06 14:59:48. <thread 1.5>: Ready to handle requests

 

I am using Sybase Adaptive Server Anywhere Database Engine Version 7.0.3.2067.
My 
creator id in CodeWarrior is TCS1 and I register the conduit as follows:
   dbcond7 TCS1 -n PalmTCS

I start the mobilink server as follows:
   SET DB=C:\Program Files\Metrowerks\CodeWarrior for Palm OS Platform
7.0\Projects\PalmTCS\PalmTCS_DB
   "%ASANY7%\WIN32\dbmlsrv7.exe" -x tcpip -c "dsn=palmtcs" -ot
"%DB%\TCSDB_dbmlsrv7_log.txt" -vcrs -dl

And my PalmExit code looks like:
 ul_synch_info	info;

    ULInitSynchInfo( &info );
    info.stream = ULConduitStream();
    info.stream_parms = "host=localhost;port=2439;stream=tcpip";
    info.user_name = "50";
    info.version = "palmtcs";

    // A Palm application never really exits. The UltraLite database
    // connection is still valid. The GetOrderCursor is still open.
    if( !ULPalmExit( &sqlca, &info ) ) 
    {
        StrIToA( charDebugCode, SQLCODE );
        StrIToA( charDebugLine, __LINE__ );
        FrmCustomAlert( DebugAlert, charDebugCode, __FILE__,
                           charDebugLine );   
    	return( false );
    }

    return( true );

Lastly, I have copied *.dll from the ultralite ... folder to the
sqlanywhere/win32 folder.

Any ideas what I am doing wrong? It just doesn't look like anything is happening
when I synch?  It should be downloading thousands of rows of data from a table
but nothing happens.

Thanks in advance for you help.


Sal

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
0
Sal
11/6/2001 9:53:18 PM
sybase.sqlanywhere.mobilink 5254 articles. 0 followers. Follow

1 Replies
858 Views

Similar Articles

[PageSpeed] 50

Are you sure it's finding the DMC conduit .dll when it runs?

Did you stop and start HotSync Manager after changing the registry?

Does the registry entry look OK?

Anyway, have a look at "Unable to open the stream" at
http://www.risingroad.com/symptoms
Specifically...
http://www.risingroad.com/symptoms/symptom0158.html

If DMC's the culprit then Installing The DMC - UltraLite Direct
Manipulation Conduit at http://www.risingroad.com/tip005.html might be
of interest.

Breck

On Tue, 06 Nov 2001 16:53:18 -0500, "Sal" <sulto@lehman.com> wrote:

>Hi,
>
>I'm having problems synchronizing my custom Ultra-Lite application.  
>After a HotSync the log file looks as follows:
>
>HotSync operation started 11/06/01 03:47:36 PM
>Expense - sync configured to Do Nothing
>Outlook Calendar - sync configured to Do Nothing
>Outlook Contacts - sync configured to Do Nothing
>Outlook Tasks - sync configured to Do Nothing
>Outlook Notes - sync configured to Do Nothing
>Unable to open the stream 11/06/01 03:47:40 PM
>OK PalmTCS (Adaptive Server Anywhere Conduit) with 1 message(s) 11/06/01
>03:47:40 PM
>OK System
>
>Yet, the MobilLink Server still says:
>
>I. 11/06 14:59:47. Sybase Adaptive Server Anywhere MobiLink Version 7.0.3.2067
>I. 11/06 14:59:47. 
>I. 11/06 14:59:47. This software contains confidential and trade secret
>information of 
>I. 11/06 14:59:47. Sybase, Inc.  Use, duplication or disclosure of the software
>and 
>I. 11/06 14:59:47. documentation by the U.S. Government is subject to
>restrictions set forth 
>I. 11/06 14:59:47. in a license agreement between the Government and Sybase,
>Inc. or other 
>I. 11/06 14:59:47. written agreement specifying the Government's rights to use
>the software 
>I. 11/06 14:59:47. and any applicable FAR provisions, for example, FAR
>52.227-19.
>I. 11/06 14:59:48.  
>I. 11/06 14:59:48. Copyright 1989-2001 Sybase, Inc.  All rights reserved.
>I. 11/06 14:59:48. All unpublished rights reserved.
>I. 11/06 14:59:48.  
>I. 11/06 14:59:48. Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
>I. 11/06 14:59:48. 
>I. 11/06 14:59:48. Networked Seat (per-seat) model. Access to the server is
>limited to 1 seat(s).
>                   This server is licensed to:
>I. 11/06 14:59:48.     Lehman Brothers
>I. 11/06 14:59:48.     Lehman Brothers
>I. 11/06 14:59:48. Synchronization Server started
>I. 11/06 14:59:48. Option 1: -x
>I. 11/06 14:59:48. Option 2: tcpip
>I. 11/06 14:59:48. Option 3: -c
>I. 11/06 14:59:48. Option 4: ****************
>I. 11/06 14:59:48. Option 5: -vcrs
>I. 11/06 14:59:48. Verbose logging: show row values
>I. 11/06 14:59:48. Verbose logging: show script names when invoked
>I. 11/06 14:59:48. Verbose logging: show script contents when invoked
>I. 11/06 14:59:48. Individual database connections will be closed after
>synchronization errors.
>I. 11/06 14:59:48. BLOB cache size: 0
>I. 11/06 14:59:48. Maximum number of BLOB bytes to compare: 4294967295
>I. 11/06 14:59:48. Maximum number of database connections: 6
>I. 11/06 14:59:48. Maximum number of deadlock retries: 10
>I. 11/06 14:59:48. Maximum delay between retries after deadlock: 30 seconds
>I. 11/06 14:59:48. Rowset size: 10
>I. 11/06 14:59:48. Upload cache size: 524288 bytes
>I. 11/06 14:59:48. Number of worker threads: 5
>I. 11/06 14:59:48. Maximum number of threads uploading concurrently: 5
>I. 11/06 14:59:48. Warning: Unknown users will be added automatically (when
>there is no authenticate_user script).
>I. 11/06 14:59:48. Stream specifier 1: tcpip
>I. 11/06 14:59:48. ODBC DBMS Name: Adaptive Server Anywhere
>I. 11/06 14:59:48. ODBC DBMS Version: 07.00.0000
>I. 11/06 14:59:48. ODBC DBMS Driver Version: 07.00.0003
>I. 11/06 14:59:48. ODBC Version supported by the driver: 3.51
>I. 11/06 14:59:48. Collation sequence of the consolidated database is 'cp1252'
>I. 11/06 14:59:48. ODBC isolation set to: Read Committed
>I. 11/06 14:59:48. Connected
>I. 11/06 14:59:48. <thread 1.1>: Ready to handle requests
>I. 11/06 14:59:48. <thread 1.2>: Ready to handle requests
>I. 11/06 14:59:48. <thread 1.3>: Ready to handle requests
>I. 11/06 14:59:48. <thread 1.4>: Ready to handle requests
>I. 11/06 14:59:48. <thread 1.5>: Ready to handle requests
>
> 
>
>I am using Sybase Adaptive Server Anywhere Database Engine Version 7.0.3.2067.
>My 
>creator id in CodeWarrior is TCS1 and I register the conduit as follows:
>   dbcond7 TCS1 -n PalmTCS
>
>I start the mobilink server as follows:
>   SET DB=C:\Program Files\Metrowerks\CodeWarrior for Palm OS Platform
>7.0\Projects\PalmTCS\PalmTCS_DB
>   "%ASANY7%\WIN32\dbmlsrv7.exe" -x tcpip -c "dsn=palmtcs" -ot
>"%DB%\TCSDB_dbmlsrv7_log.txt" -vcrs -dl
>
>And my PalmExit code looks like:
> ul_synch_info	info;
>
>    ULInitSynchInfo( &info );
>    info.stream = ULConduitStream();
>    info.stream_parms = "host=localhost;port=2439;stream=tcpip";
>    info.user_name = "50";
>    info.version = "palmtcs";
>
>    // A Palm application never really exits. The UltraLite database
>    // connection is still valid. The GetOrderCursor is still open.
>    if( !ULPalmExit( &sqlca, &info ) ) 
>    {
>        StrIToA( charDebugCode, SQLCODE );
>        StrIToA( charDebugLine, __LINE__ );
>        FrmCustomAlert( DebugAlert, charDebugCode, __FILE__,
>                           charDebugLine );   
>    	return( false );
>    }
>
>    return( true );
>
>Lastly, I have copied *.dll from the ultralite ... folder to the
>sqlanywhere/win32 folder.
>
>Any ideas what I am doing wrong? It just doesn't look like anything is happening
>when I synch?  It should be downloading thousands of rows of data from a table
>but nothing happens.
>
>Thanks in advance for you help.
>
>
>Sal
>
>---== Posted via the PFCGuide Web Newsreader ==---
>http://www.pfcguide.com/_newsgroups/group_list.asp

bcarter@risingroad.com
Palm UltraLite Enterprise Applications
-----
Visit http://www.risingroad.com for Tips and Techniques
[TeamSybase]
0
Breck
11/6/2001 11:55:24 PM
Reply: