SQL Anywhere Mobile - Desktop sync works, PPC doesn't

Author

Desktop sync works, PPC doesn't

Hank

2005-06-08, 9:24 am

I'm a newbie at MobiLink and have gotten a sync to work from an ASA db on
the desktop to Oracle. Now I want to sync that same asa database from the
Pocket PC and am getting "Unable to connect to remote database" SQLCode -140
errors. No reqests are getting out of the PPC device (using tcpTrace).

I'm using the latest evaluation cd from the Sybase booth at Las Vegas MEDC.

I also am not getting a log file from my dbmlsync.
How do I get dbmlsync on the PPC to write to the log file?

Client dbmlsync params:
-c DBF=\Program Files\MobiLinkClient
\MV.DB;UID=DBA;PWD=SQL -o
dbmlsync.out -v+ -e sv=scriptversion1.0

I've tried using an ActiveSync connection and a wifi connection.

Also, how can I shut off the iAnywhere windows that come up on the PPC when
I make a connection to the dataase (do do local writes) and also when I do a
dbmlsync? After development and debugging, I'd like to not have theses
windows show.

Hank

2005-06-08, 9:24 am

MobiLink version 9.0.1.1922

"Hank" <sorry@noway.com> wrote in message news:42a6fe81$1@foru
ms-1-dub...
> I'm a newbie at MobiLink and have gotten a sync to work from an ASA db on
> the desktop to Oracle. Now I want to sync that same asa database from the
> Pocket PC and am getting "Unable to connect to remote database"
SQLCode -140
> errors. No reqests are getting out of the PPC device (using tcpTrace).
>
> I'm using the latest evaluation cd from the Sybase booth at Las Vegas
MEDC.
>
> I also am not getting a log file from my dbmlsync.
> How do I get dbmlsync on the PPC to write to the log file?
>
> Client dbmlsync params:
> -c DBF=\Program Files\MobiLinkClient
\MV.DB;UID=DBA;PWD=SQL -o
> dbmlsync.out -v+ -e sv=scriptversion1.0
>
> I've tried using an ActiveSync connection and a wifi connection.
>
> Also, how can I shut off the iAnywhere windows that come up on the PPC
when
> I make a connection to the dataase (do do local writes) and also when I do
a
> dbmlsync? After development and debugging, I'd like to not have theses
> windows show.
>
>
>

Reg Domaratzki $iAnywhere Solutions$

2005-06-08, 9:24 am

The problem has nothing to do with your network connection from the PPC
device. dbmlsync is failing to connect to the ASA database on the device.

Because your connection parameters have a space in them, the entire
connection string needs to be enclosed in double quotes.

Try :

Client dbmlsync params:
-c "DBF=\Program Files\MobiLinkClient
\MV.DB;UID=DBA;PWD=SQL" -o
dbmlsync.out -v+ -e sv=scriptversion1.0

Answers to other questions :

1) I believe the -Q switch will prevent the window from showing up. I'm
100% certain this is true on the desktop, but only about 90% certain this is
true on PPC. If "-Q" doesn't work, try "-q".

2) You run dbmlsync whenever you want to synchronize the data in your remote
database with the data in the consolidated database.

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

"Hank" <sorry@noway.com> wrote in message news:42a6fe81$1@foru
ms-1-dub...
> I'm a newbie at MobiLink and have gotten a sync to work from an ASA db on
> the desktop to Oracle. Now I want to sync that same asa database from the
> Pocket PC and am getting "Unable to connect to remote database"
SQLCode -140
> errors. No reqests are getting out of the PPC device (using tcpTrace).
>
> I'm using the latest evaluation cd from the Sybase booth at Las Vegas
MEDC.
>
> I also am not getting a log file from my dbmlsync.
> How do I get dbmlsync on the PPC to write to the log file?
>
> Client dbmlsync params:
> -c DBF=\Program Files\MobiLinkClient
\MV.DB;UID=DBA;PWD=SQL -o
> dbmlsync.out -v+ -e sv=scriptversion1.0
>
> I've tried using an ActiveSync connection and a wifi connection.
>
> Also, how can I shut off the iAnywhere windows that come up on the PPC
when
> I make a connection to the dataase (do do local writes) and also when I do
a
> dbmlsync? After development and debugging, I'd like to not have theses
> windows show.
>
>
>

Hank

2005-06-08, 11:24 am

The double quotest fixed it.

The -q suppressed the iA window for dbmlsync on the PPC.

Thanks

When I open an asa database connection on the PPC
dbConn = new AsaConnection(@"DBF=\Program
Files\MobiLinkClient
\MV.DB;UID=DBA;PWD=SQL");
dbConn.Open();
I get an iA window that comes up from the Open() method and prints a bunch
of log data then closes. There must be a way to suppress that window from
coming up, but I couldn't find it in the docs:
ASA Database Administration Guide
Connecting to a Database
Connection parameters

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:42a701a7$1@foru
ms-2-dub...
> The problem has nothing to do with your network connection from the PPC
> device. dbmlsync is failing to connect to the ASA database on the device.
>
> Because your connection parameters have a space in them, the entire
> connection string needs to be enclosed in double quotes.
>
> Try :
>
> Client dbmlsync params:
> -c "DBF=\Program Files\MobiLinkClient
\MV.DB;UID=DBA;PWD=SQL" -o
> dbmlsync.out -v+ -e sv=scriptversion1.0
>
> Answers to other questions :
>
> 1) I believe the -Q switch will prevent the window from showing up. I'm
> 100% certain this is true on the desktop, but only about 90% certain this
is
> true on PPC. If "-Q" doesn't work, try "-q".
>
> 2) You run dbmlsync whenever you want to synchronize the data in your
remote
> database with the data in the consolidated database.
>
>
> --
> 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
>
> "Hank" <sorry@noway.com> wrote in message news:42a6fe81$1@foru
ms-1-dub...
on[color=darkred]
the[color=darkred]
> SQLCode -140
> MEDC.
> when
do[color=darkred]
> a
>
>

Reg Domaratzki $iAnywhere Solutions$

2005-06-08, 11:24 am

Hiding the window is a command line switch for the database engine. Try :

dbConn = new AsaConnection(@"DBF=\Program
Files\MobiLinkClient
\MV. DB;UID=DBA;PWD=SQL;S
TART=\Program
Files\Sybase\ASA\dbs
rv9 -qw");
dbConn.Open();

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

"Hank" <sorry@noway.com> wrote in message news:42a70ff1$1@foru
ms-1-dub...
> The double quotest fixed it.
>
> The -q suppressed the iA window for dbmlsync on the PPC.
>
> Thanks
>
> When I open an asa database connection on the PPC
> dbConn = new AsaConnection(@"DBF=\Program
> Files\MobiLinkClient
\MV.DB;UID=DBA;PWD=SQL");
> dbConn.Open();
> I get an iA window that comes up from the Open() method and prints a bunch
> of log data then closes. There must be a way to suppress that window from
> coming up, but I couldn't find it in the docs:
> ASA Database Administration Guide
> Connecting to a Database
> Connection parameters
>
>
>
> "Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
> wrote in message news:42a701a7$1@foru
ms-2-dub...
device.[color=darkred]
this[color=darkred]
> is
> remote
> http://www.ianywhere.com/developer/product_manuals
news:42a6fe81$1@foru
ms-1-dub...[color=darkred]
> on
> the
I[color=darkred]
> do
>
>

Hank

2005-06-08, 11:24 am

That worked -- I found that it wanted the ".exe" explicitly used:

START=\Program Files\Sybase\ASA9\db
srv9.exe -qw

START=\Program Files\Sybase\ASA9\db
srv9 -qw ---- this one gave "unable to
start database server" error

Thanks!
Hank

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:42a712d0$1@foru
ms-1-dub...
> Hiding the window is a command line switch for the database engine. Try :
>
> dbConn = new AsaConnection(@"DBF=\Program
> Files\MobiLinkClient
\MV. DB;UID=DBA;PWD=SQL;S
TART=\Program
> Files\Sybase\ASA\dbs
rv9 -qw");
> dbConn.Open();
>
>
>
> --
> 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
>
> "Hank" <sorry@noway.com> wrote in message news:42a70ff1$1@foru
ms-1-dub...
bunch[color=darkred]

from[color=darkred]
<FirstName.LastName@ianywhere.com>[color=darkred]
PPC[color=darkred]
> device.
I'm[color=darkred]
> this
> news:42a6fe81$1@foru
ms-1-dub...
db[color=darkred]
from[color=darkred]
tcpTrace).[color=darkred]
Vegas[color=darkred]

PPC[color=darkred]
when[color=darkred]
> I
theses[color=darkred
]
>
>

Sponsored Links