Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Alternative for Mobilink Synchronization

29 posts in Pocket PowerBuilder Last posting was on 2003-10-03 21:18:29.0Z
Jun Posted on 2003-09-15 20:06:54.0Z
From: "Jun " <junredillas@wvdhhr.org>
Newsgroups: sybase.public.pocketpowerbuilder
Organization: 129.71.238.253
X-Newsreader: AspNNTP 1.50 (Tri Hoang)
Subject: Alternative for Mobilink Synchronization
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: transinc-win02.netoptex.com
Message-ID: <3f661c53$1@forums-2-dub>
X-Original-Trace: 15 Sep 2003 13:08:51 -0700, transinc-win02.netoptex.com
Lines: 22
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Sep 2003 13:03:32 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Sep 2003 13:06:54 -0700
X-Trace: forums-1-dub 1063656414 10.22.108.75 (15 Sep 2003 13:06:54 -0700)
X-Original-Trace: 15 Sep 2003 13:06:54 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:468
Article PK: 267000

I have been trying the Pocket Powerbuilder 1.0 Evaluation and has successfully
created a simple application. Our consolidated database is ORACLE and I
understand we have to run a SQL to create the ML_* tables for the Mobilink
synchronization process. Moreover, we have to purchase a license in deploying
these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
Synchronization technologies and Sybase Central Administration tool. Now, that
turns me off (sorry..).

My question: Is there any other way to synchronize with the consolidated Oracle
database without using the Mobilink synchronization technique? I knew we can
write a Powerbuilder application to read an ASA local database but again it's
not royalty free since we will be deploying that database off the Pocket PC
2002. Can we use the SaveAs function to create a text or Excel or DBF file on
Pocket PC 2002 then ActiveSync to transfer to local PC and then manipulate or
use it within Powerbuilder application to update Consolidated Oracle database?

Your input is greatly appreciated.

Thanks,
Jun
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Dean Jones [TeamSybase] Posted on 2003-09-16 14:44:01.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 76
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 216.207.144.172
X-Original-NNTP-Posting-Host: 216.207.144.172
Message-ID: <3f6721b1$1@forums-1-dub>
Date: 16 Sep 2003 07:44:01 -0700
X-Trace: forums-1-dub 1063723441 216.207.144.172 (16 Sep 2003 07:44:01 -0700)
X-Original-Trace: 16 Sep 2003 07:44:01 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:473
Article PK: 267006

There is a cost associated with using these tools because they add value.

You will spend a great deal of time and effort trying to develop your own
sync options.

There are other 3rd party tools on the market that do the same thing and
they all cost money. MS SQL CE cost money if you sync with a consolidated
database. ASA is free for a stand alone device, but you must license it if
you sync with a backend db. MobilLink is much more powerful then SQL Remote.

Before you write your own sync process you should find out if you still
require a license of ASA on the PC device. Its my understanding you need a
license if you sync data from the device, not if you use MobiLink.

ASA for the PocketPC device is around $120. The cost of developing you own
sync could be enormous and it might never work correctly? How will you
handle getting new keys? How will you handle deleted records? How will you
handle partitioned data?

iAnywhere solution is very powerful and a great solution. Before you get mad
about having to purchase the software look at what it does for you. Look at
how well Pocket PowerBuilder and ASA are integrated and how easily it is to
develop your solution.

What are you using for devices? The device is normally your most expensive
part of the solution. Working with the right company you can get a great
price for device and software bundled together. Feel free to contact me for
more information.

--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Jun " <junredillas@wvdhhr.org> wrote in message
news:3f661c53$1@forums-2-dub...
> I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
successfully
> created a simple application. Our consolidated database is ORACLE and I
> understand we have to run a SQL to create the ML_* tables for the Mobilink
> synchronization process. Moreover, we have to purchase a license in
deploying
> these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> Synchronization technologies and Sybase Central Administration tool. Now,
that
> turns me off (sorry..).
>
> My question: Is there any other way to synchronize with the consolidated
Oracle
> database without using the Mobilink synchronization technique? I knew we
can
> write a Powerbuilder application to read an ASA local database but again
it's
> not royalty free since we will be deploying that database off the Pocket
PC
> 2002. Can we use the SaveAs function to create a text or Excel or DBF file
on
> Pocket PC 2002 then ActiveSync to transfer to local PC and then manipulate
or
> use it within Powerbuilder application to update Consolidated Oracle
database?
>
> Your input is greatly appreciated.
>
> Thanks,
> Jun
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


Dean Jones [TeamSybase] Posted on 2003-09-17 19:03:43.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f6721b1$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 168
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 216.207.144.172
Message-ID: <3f68b08c$1@forums-2-dub>
X-Original-Trace: 17 Sep 2003 12:05:48 -0700, 216.207.144.172
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Sep 2003 12:00:11 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Sep 2003 12:03:43 -0700
X-Trace: forums-1-dub 1063825423 10.22.108.75 (17 Sep 2003 12:03:43 -0700)
X-Original-Trace: 17 Sep 2003 12:03:43 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:501
Article PK: 267035

I have done a little research on ASA on the PPC. It is the same as ASA
runtime for the desktop and CE.

The major restrictions for the Desktop Runtime Edition are as follows:



¨ No remote data access You cannot access data on remote servers

using the Desktop Runtime Edition.

¨ No transaction log The Desktop Runtime Edition does not use a

transaction log. Consequently, it cannot take part in a replication or

synchronization environment.

¨ No data definition You cannot create or alter database objects such as

stored procedures, tables, and indexes.

¨ No stored procedures, events, or triggers The Desktop Runtime

Edition does not support the use of stored procedures, events, or triggers.

Consequently, procedure profiling is not available.

¨ No events or schedules The Desktop Runtime Edition does not

support events or scheduling of events.

¨ No defragmentation support You cannot query the database for

fragmentation, nor can you issue defragmentation commands.

¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition

does not support transactions involved with Distributed Transaction

Coordination.

¨ No support for SMP-capable machines The Desktop Runtime Edition

does not support multi-processor machines.

No Java The Java-in-the-database features are not available in the

Desktop Runtime Edition.

¨ No jConnect access You can access the Desktop Runtime Edition

from JDBC using the iAnywhere JDBC driver, but not using the Sybase

jConnect JDBC driver.

¨ No database file encryption The Desktop Runtime Edition does not

support database file encryption.

¨ No communication encryption You cannot encrypt client/server

communications using the Desktop Runtime Edition.

¨ No web services The Desktop Runtime Edition does not support web

services, including HTTP server and SOAP.


--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f6721b1$1@forums-1-dub...
> There is a cost associated with using these tools because they add value.
>
> You will spend a great deal of time and effort trying to develop your own
> sync options.
>
> There are other 3rd party tools on the market that do the same thing and
> they all cost money. MS SQL CE cost money if you sync with a consolidated
> database. ASA is free for a stand alone device, but you must license it if
> you sync with a backend db. MobilLink is much more powerful then SQL
Remote.
>
> Before you write your own sync process you should find out if you still
> require a license of ASA on the PC device. Its my understanding you need a
> license if you sync data from the device, not if you use MobiLink.
>
> ASA for the PocketPC device is around $120. The cost of developing you own
> sync could be enormous and it might never work correctly? How will you
> handle getting new keys? How will you handle deleted records? How will you
> handle partitioned data?
>
> iAnywhere solution is very powerful and a great solution. Before you get
mad
> about having to purchase the software look at what it does for you. Look
at
> how well Pocket PowerBuilder and ASA are integrated and how easily it is
to
> develop your solution.
>
> What are you using for devices? The device is normally your most expensive
> part of the solution. Working with the right company you can get a great
> price for device and software bundled together. Feel free to contact me
for
> more information.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Jun " <junredillas@wvdhhr.org> wrote in message
> news:3f661c53$1@forums-2-dub...
> > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> successfully
> > created a simple application. Our consolidated database is ORACLE and I
> > understand we have to run a SQL to create the ML_* tables for the
Mobilink
> > synchronization process. Moreover, we have to purchase a license in
> deploying
> > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > Synchronization technologies and Sybase Central Administration tool.
Now,
> that
> > turns me off (sorry..).
> >
> > My question: Is there any other way to synchronize with the consolidated
> Oracle
> > database without using the Mobilink synchronization technique? I knew we
> can
> > write a Powerbuilder application to read an ASA local database but again
> it's
> > not royalty free since we will be deploying that database off the Pocket
> PC
> > 2002. Can we use the SaveAs function to create a text or Excel or DBF
file
> on
> > Pocket PC 2002 then ActiveSync to transfer to local PC and then
manipulate
> or
> > use it within Powerbuilder application to update Consolidated Oracle
> database?
> >
> > Your input is greatly appreciated.
> >
> > Thanks,
> > Jun
> > ---== Posted via the PFCGuide Web Newsreader ==---
> > http://www.pfcguide.com/_newsgroups/group_list.asp
>
>


Greg W Posted on 2003-09-16 14:48:17.0Z
From: "Greg W" <sales@winfieldsolutions.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: toronto-hse-ppp3896116.sympatico.ca
X-Original-NNTP-Posting-Host: toronto-hse-ppp3896116.sympatico.ca
Message-ID: <3f6722b1@forums-1-dub>
Date: 16 Sep 2003 07:48:17 -0700
X-Trace: forums-1-dub 1063723697 67.70.160.103 (16 Sep 2003 07:48:17 -0700)
X-Original-Trace: 16 Sep 2003 07:48:17 -0700, toronto-hse-ppp3896116.sympatico.ca
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:474
Article PK: 267008

Take a look at Pipelines....we use them to run data in both directions

Greg

"Jun " <junredillas@wvdhhr.org> wrote in message
news:3f661c53$1@forums-2-dub...
> I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
successfully
> created a simple application. Our consolidated database is ORACLE and I
> understand we have to run a SQL to create the ML_* tables for the Mobilink
> synchronization process. Moreover, we have to purchase a license in
deploying
> these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> Synchronization technologies and Sybase Central Administration tool. Now,
that
> turns me off (sorry..).
>
> My question: Is there any other way to synchronize with the consolidated
Oracle
> database without using the Mobilink synchronization technique? I knew we
can
> write a Powerbuilder application to read an ASA local database but again
it's
> not royalty free since we will be deploying that database off the Pocket
PC
> 2002. Can we use the SaveAs function to create a text or Excel or DBF file
on
> Pocket PC 2002 then ActiveSync to transfer to local PC and then manipulate
or
> use it within Powerbuilder application to update Consolidated Oracle
database?
>
> Your input is greatly appreciated.
>
> Thanks,
> Jun
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


Chris Pollach Posted on 2003-09-16 14:55:43.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 51
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: firewall.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: firewall.scc-csc.gc.ca
Message-ID: <3f67246f$1@forums-1-dub>
Date: 16 Sep 2003 07:55:43 -0700
X-Trace: forums-1-dub 1063724143 209.47.227.130 (16 Sep 2003 07:55:43 -0700)
X-Original-Trace: 16 Sep 2003 07:55:43 -0700, firewall.scc-csc.gc.ca
X-Authenticated-User: PPBBeta11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:475
Article PK: 267009

Jun;

I developed my own "Sync" utility using PB 9 and Pipelines. It took me
about a day to program and another day to unit test. It is now in production
and rock solid. The utility (runs on the PC) connects to the corporate DB
and PPC ASA simultaneously and pipes data both ways! I was in the same
quandary as you currently, as the MobiLink solution was elegant but way too
costly to charge to the client to make my application cost effective.

So a home grown solution may not be that bad. Anyway ... food for thought.

regards ... Chris
Great White North Technical Evangelist

"Jun " <junredillas@wvdhhr.org> wrote in message
news:3f661c53$1@forums-2-dub...
> I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
successfully
> created a simple application. Our consolidated database is ORACLE and I
> understand we have to run a SQL to create the ML_* tables for the Mobilink
> synchronization process. Moreover, we have to purchase a license in
deploying
> these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> Synchronization technologies and Sybase Central Administration tool. Now,
that
> turns me off (sorry..).
>
> My question: Is there any other way to synchronize with the consolidated
Oracle
> database without using the Mobilink synchronization technique? I knew we
can
> write a Powerbuilder application to read an ASA local database but again
it's
> not royalty free since we will be deploying that database off the Pocket
PC
> 2002. Can we use the SaveAs function to create a text or Excel or DBF file
on
> Pocket PC 2002 then ActiveSync to transfer to local PC and then manipulate
or
> use it within Powerbuilder application to update Consolidated Oracle
database?
>
> Your input is greatly appreciated.
>
> Thanks,
> Jun
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


Dean Jones [TeamSybase] Posted on 2003-09-16 18:06:10.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 78
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 216.207.144.172
X-Original-NNTP-Posting-Host: 216.207.144.172
Message-ID: <3f675112@forums-1-dub>
Date: 16 Sep 2003 11:06:10 -0700
X-Trace: forums-1-dub 1063735570 216.207.144.172 (16 Sep 2003 11:06:10 -0700)
X-Original-Trace: 16 Sep 2003 11:06:10 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:476
Article PK: 267010

Chris -

If you connect to a remote database you must license ASA on the handled. I
did not realize there was an additional license to use mobilink beyond
licensing ASA. I will find out and post what I find.

--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f67246f$1@forums-1-dub...
> Jun;
>
> I developed my own "Sync" utility using PB 9 and Pipelines. It took me
> about a day to program and another day to unit test. It is now in
production
> and rock solid. The utility (runs on the PC) connects to the corporate DB
> and PPC ASA simultaneously and pipes data both ways! I was in the same
> quandary as you currently, as the MobiLink solution was elegant but way
too
> costly to charge to the client to make my application cost effective.
>
> So a home grown solution may not be that bad. Anyway ... food for thought.
>
> regards ... Chris
> Great White North Technical Evangelist
>
>
> "Jun " <junredillas@wvdhhr.org> wrote in message
> news:3f661c53$1@forums-2-dub...
> > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> successfully
> > created a simple application. Our consolidated database is ORACLE and I
> > understand we have to run a SQL to create the ML_* tables for the
Mobilink
> > synchronization process. Moreover, we have to purchase a license in
> deploying
> > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > Synchronization technologies and Sybase Central Administration tool.
Now,
> that
> > turns me off (sorry..).
> >
> > My question: Is there any other way to synchronize with the consolidated
> Oracle
> > database without using the Mobilink synchronization technique? I knew we
> can
> > write a Powerbuilder application to read an ASA local database but again
> it's
> > not royalty free since we will be deploying that database off the Pocket
> PC
> > 2002. Can we use the SaveAs function to create a text or Excel or DBF
file
> on
> > Pocket PC 2002 then ActiveSync to transfer to local PC and then
manipulate
> or
> > use it within Powerbuilder application to update Consolidated Oracle
> database?
> >
> > Your input is greatly appreciated.
> >
> > Thanks,
> > Jun
> > ---== Posted via the PFCGuide Web Newsreader ==---
> > http://www.pfcguide.com/_newsgroups/group_list.asp
>
>


Greg W Posted on 2003-09-16 18:53:33.0Z
From: "Greg W" <sales@winfieldsolutions.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f675112@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: toronto-hse-ppp3896116.sympatico.ca
X-Original-NNTP-Posting-Host: toronto-hse-ppp3896116.sympatico.ca
Message-ID: <3f675c2d$1@forums-1-dub>
Date: 16 Sep 2003 11:53:33 -0700
X-Trace: forums-1-dub 1063738413 67.70.160.103 (16 Sep 2003 11:53:33 -0700)
X-Original-Trace: 16 Sep 2003 11:53:33 -0700, toronto-hse-ppp3896116.sympatico.ca
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:477
Article PK: 267012

There was a thread in this ng where Martin had explained some of this
pricing from his perspective. It was dated 8/26 but it appears there are a
bunch of threads missing from that date/time.

I can't recall his answer(I'm wearing too many hats) but if you folks could
restate the policy for all concerned I'd appreciate it.

Greg

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f675112@forums-1-dub...
> Chris -
>
> If you connect to a remote database you must license ASA on the handled. I
> did not realize there was an additional license to use mobilink beyond
> licensing ASA. I will find out and post what I find.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f67246f$1@forums-1-dub...
> > Jun;
> >
> > I developed my own "Sync" utility using PB 9 and Pipelines. It took me
> > about a day to program and another day to unit test. It is now in
> production
> > and rock solid. The utility (runs on the PC) connects to the corporate
DB
> > and PPC ASA simultaneously and pipes data both ways! I was in the same
> > quandary as you currently, as the MobiLink solution was elegant but way
> too
> > costly to charge to the client to make my application cost effective.
> >
> > So a home grown solution may not be that bad. Anyway ... food for
thought.
> >
> > regards ... Chris
> > Great White North Technical Evangelist
> >
> >
> > "Jun " <junredillas@wvdhhr.org> wrote in message
> > news:3f661c53$1@forums-2-dub...
> > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> > successfully
> > > created a simple application. Our consolidated database is ORACLE and
I
> > > understand we have to run a SQL to create the ML_* tables for the
> Mobilink
> > > synchronization process. Moreover, we have to purchase a license in
> > deploying
> > > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > > Synchronization technologies and Sybase Central Administration tool.
> Now,
> > that
> > > turns me off (sorry..).
> > >
> > > My question: Is there any other way to synchronize with the
consolidated
> > Oracle
> > > database without using the Mobilink synchronization technique? I knew
we
> > can
> > > write a Powerbuilder application to read an ASA local database but
again
> > it's
> > > not royalty free since we will be deploying that database off the
Pocket
> > PC
> > > 2002. Can we use the SaveAs function to create a text or Excel or DBF
> file
> > on
> > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> manipulate
> > or
> > > use it within Powerbuilder application to update Consolidated Oracle
> > database?
> > >
> > > Your input is greatly appreciated.
> > >
> > > Thanks,
> > > Jun
> > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > http://www.pfcguide.com/_newsgroups/group_list.asp
> >
> >
>
>


Bharat Patel Posted on 2003-09-16 19:15:05.0Z
From: "Bharat Patel" <bharatp_NOSPAM@sybase.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f675112@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 113
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: bharatp-pc2.sybase.com
X-Original-NNTP-Posting-Host: bharatp-pc2.sybase.com
Message-ID: <3f676139$1@forums-1-dub>
Date: 16 Sep 2003 12:15:05 -0700
X-Trace: forums-1-dub 1063739705 172.31.141.100 (16 Sep 2003 12:15:05 -0700)
X-Original-Trace: 16 Sep 2003 12:15:05 -0700, bharatp-pc2.sybase.com
X-Authenticated-User: ppb
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:478
Article PK: 267013

I found the entry Greg was alluding to re: pricing (I think):

"Martyn Mallick" <mmallick.removethis@ianywhere.com> wrote in message
news:3f4ba1d6@forums-1-dub...
> Greg,
>
> You are close:
>
> There are two versions of ASA available for Pocket PowerBuilder
>
> 1) The full licensed version which is provided for development use with
the
> product. This version does have a distribution fees at deployment time,
> whether you are using synchronization or not.
>
> 2) There is a royalty-free runtime that is provided in the Support
directory
> of Pocket PB. This version has some restrictions, but can be deployed
> without fees. There is a readme file included with it that contains the
> full details. It does not allow for synchronization.
>
> -Marty
>

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f675112@forums-1-dub...
> Chris -
>
> If you connect to a remote database you must license ASA on the handled. I
> did not realize there was an additional license to use mobilink beyond
> licensing ASA. I will find out and post what I find.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f67246f$1@forums-1-dub...
> > Jun;
> >
> > I developed my own "Sync" utility using PB 9 and Pipelines. It took me
> > about a day to program and another day to unit test. It is now in
> production
> > and rock solid. The utility (runs on the PC) connects to the corporate
DB
> > and PPC ASA simultaneously and pipes data both ways! I was in the same
> > quandary as you currently, as the MobiLink solution was elegant but way
> too
> > costly to charge to the client to make my application cost effective.
> >
> > So a home grown solution may not be that bad. Anyway ... food for
thought.
> >
> > regards ... Chris
> > Great White North Technical Evangelist
> >
> >
> > "Jun " <junredillas@wvdhhr.org> wrote in message
> > news:3f661c53$1@forums-2-dub...
> > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> > successfully
> > > created a simple application. Our consolidated database is ORACLE and
I
> > > understand we have to run a SQL to create the ML_* tables for the
> Mobilink
> > > synchronization process. Moreover, we have to purchase a license in
> > deploying
> > > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > > Synchronization technologies and Sybase Central Administration tool.
> Now,
> > that
> > > turns me off (sorry..).
> > >
> > > My question: Is there any other way to synchronize with the
consolidated
> > Oracle
> > > database without using the Mobilink synchronization technique? I knew
we
> > can
> > > write a Powerbuilder application to read an ASA local database but
again
> > it's
> > > not royalty free since we will be deploying that database off the
Pocket
> > PC
> > > 2002. Can we use the SaveAs function to create a text or Excel or DBF
> file
> > on
> > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> manipulate
> > or
> > > use it within Powerbuilder application to update Consolidated Oracle
> > database?
> > >
> > > Your input is greatly appreciated.
> > >
> > > Thanks,
> > > Jun
> > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > http://www.pfcguide.com/_newsgroups/group_list.asp
> >
> >
>
>


Chris Pollach Posted on 2003-09-16 19:57:01.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f675112@forums-1-dub> <3f676139$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 138
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: firewall.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: firewall.scc-csc.gc.ca
Message-ID: <3f676b0d$1@forums-1-dub>
Date: 16 Sep 2003 12:57:01 -0700
X-Trace: forums-1-dub 1063742221 209.47.227.130 (16 Sep 2003 12:57:01 -0700)
X-Original-Trace: 16 Sep 2003 12:57:01 -0700, firewall.scc-csc.gc.ca
X-Authenticated-User: PPBBeta11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:480
Article PK: 267017

The key is the 2nd one which IS Royalty free. The only restrictions that I
know of are ...

1) No Stored Procedures.
2) No replication
3) Can not be used with MobiLink.

Otherwise it is free, regardless of the #of connections or, where they come
from!

regards ... Chris

"Bharat Patel" <bharatp_NOSPAM@sybase.com> wrote in message
news:3f676139$1@forums-1-dub...
> I found the entry Greg was alluding to re: pricing (I think):
>
> "Martyn Mallick" <mmallick.removethis@ianywhere.com> wrote in message
> news:3f4ba1d6@forums-1-dub...
> > Greg,
> >
> > You are close:
> >
> > There are two versions of ASA available for Pocket PowerBuilder
> >
> > 1) The full licensed version which is provided for development use with
> the
> > product. This version does have a distribution fees at deployment time,
> > whether you are using synchronization or not.
> >
> > 2) There is a royalty-free runtime that is provided in the Support
> directory
> > of Pocket PB. This version has some restrictions, but can be deployed
> > without fees. There is a readme file included with it that contains the
> > full details. It does not allow for synchronization.
> >
> > -Marty
> >
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f675112@forums-1-dub...
> > Chris -
> >
> > If you connect to a remote database you must license ASA on the handled.
I
> > did not realize there was an additional license to use mobilink beyond
> > licensing ASA. I will find out and post what I find.
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > news:3f67246f$1@forums-1-dub...
> > > Jun;
> > >
> > > I developed my own "Sync" utility using PB 9 and Pipelines. It took
me
> > > about a day to program and another day to unit test. It is now in
> > production
> > > and rock solid. The utility (runs on the PC) connects to the corporate
> DB
> > > and PPC ASA simultaneously and pipes data both ways! I was in the same
> > > quandary as you currently, as the MobiLink solution was elegant but
way
> > too
> > > costly to charge to the client to make my application cost effective.
> > >
> > > So a home grown solution may not be that bad. Anyway ... food for
> thought.
> > >
> > > regards ... Chris
> > > Great White North Technical Evangelist
> > >
> > >
> > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > news:3f661c53$1@forums-2-dub...
> > > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> > > successfully
> > > > created a simple application. Our consolidated database is ORACLE
and
> I
> > > > understand we have to run a SQL to create the ML_* tables for the
> > Mobilink
> > > > synchronization process. Moreover, we have to purchase a license in
> > > deploying
> > > > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > > > Synchronization technologies and Sybase Central Administration tool.
> > Now,
> > > that
> > > > turns me off (sorry..).
> > > >
> > > > My question: Is there any other way to synchronize with the
> consolidated
> > > Oracle
> > > > database without using the Mobilink synchronization technique? I
knew
> we
> > > can
> > > > write a Powerbuilder application to read an ASA local database but
> again
> > > it's
> > > > not royalty free since we will be deploying that database off the
> Pocket
> > > PC
> > > > 2002. Can we use the SaveAs function to create a text or Excel or
DBF
> > file
> > > on
> > > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> > manipulate
> > > or
> > > > use it within Powerbuilder application to update Consolidated Oracle
> > > database?
> > > >
> > > > Your input is greatly appreciated.
> > > >
> > > > Thanks,
> > > > Jun
> > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-16 19:54:04.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f675112@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 95
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: www.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: www.scc-csc.gc.ca
Message-ID: <3f676a5c$1@forums-1-dub>
Date: 16 Sep 2003 12:54:04 -0700
X-Trace: forums-1-dub 1063742044 209.47.227.132 (16 Sep 2003 12:54:04 -0700)
X-Original-Trace: 16 Sep 2003 12:54:04 -0700, www.scc-csc.gc.ca
X-Authenticated-User: PPBBeta11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:479
Article PK: 267014

Dean;

I am not connecting using PPB. It is from a native PB 9 application.

regards ... Chris

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f675112@forums-1-dub...
> Chris -
>
> If you connect to a remote database you must license ASA on the handled. I
> did not realize there was an additional license to use mobilink beyond
> licensing ASA. I will find out and post what I find.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f67246f$1@forums-1-dub...
> > Jun;
> >
> > I developed my own "Sync" utility using PB 9 and Pipelines. It took me
> > about a day to program and another day to unit test. It is now in
> production
> > and rock solid. The utility (runs on the PC) connects to the corporate
DB
> > and PPC ASA simultaneously and pipes data both ways! I was in the same
> > quandary as you currently, as the MobiLink solution was elegant but way
> too
> > costly to charge to the client to make my application cost effective.
> >
> > So a home grown solution may not be that bad. Anyway ... food for
thought.
> >
> > regards ... Chris
> > Great White North Technical Evangelist
> >
> >
> > "Jun " <junredillas@wvdhhr.org> wrote in message
> > news:3f661c53$1@forums-2-dub...
> > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> > successfully
> > > created a simple application. Our consolidated database is ORACLE and
I
> > > understand we have to run a SQL to create the ML_* tables for the
> Mobilink
> > > synchronization process. Moreover, we have to purchase a license in
> > deploying
> > > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > > Synchronization technologies and Sybase Central Administration tool.
> Now,
> > that
> > > turns me off (sorry..).
> > >
> > > My question: Is there any other way to synchronize with the
consolidated
> > Oracle
> > > database without using the Mobilink synchronization technique? I knew
we
> > can
> > > write a Powerbuilder application to read an ASA local database but
again
> > it's
> > > not royalty free since we will be deploying that database off the
Pocket
> > PC
> > > 2002. Can we use the SaveAs function to create a text or Excel or DBF
> file
> > on
> > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> manipulate
> > or
> > > use it within Powerbuilder application to update Consolidated Oracle
> > database?
> > >
> > > Your input is greatly appreciated.
> > >
> > > Thanks,
> > > Jun
> > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > http://www.pfcguide.com/_newsgroups/group_list.asp
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-09-17 13:45:44.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f675112@forums-1-dub> <3f676a5c$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 119
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 216.207.144.172
Message-ID: <3f686607$1@forums-2-dub>
X-Original-Trace: 17 Sep 2003 06:47:51 -0700, 216.207.144.172
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Sep 2003 06:42:15 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Sep 2003 06:45:44 -0700
X-Trace: forums-1-dub 1063806344 10.22.108.75 (17 Sep 2003 06:45:44 -0700)
X-Original-Trace: 17 Sep 2003 06:45:44 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:495
Article PK: 267029

The newsgroup caused me to assume this was a PPC app.

--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f676a5c$1@forums-1-dub...
> Dean;
>
> I am not connecting using PPB. It is from a native PB 9 application.
>
> regards ... Chris
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f675112@forums-1-dub...
> > Chris -
> >
> > If you connect to a remote database you must license ASA on the handled.
I
> > did not realize there was an additional license to use mobilink beyond
> > licensing ASA. I will find out and post what I find.
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > news:3f67246f$1@forums-1-dub...
> > > Jun;
> > >
> > > I developed my own "Sync" utility using PB 9 and Pipelines. It took
me
> > > about a day to program and another day to unit test. It is now in
> > production
> > > and rock solid. The utility (runs on the PC) connects to the corporate
> DB
> > > and PPC ASA simultaneously and pipes data both ways! I was in the same
> > > quandary as you currently, as the MobiLink solution was elegant but
way
> > too
> > > costly to charge to the client to make my application cost effective.
> > >
> > > So a home grown solution may not be that bad. Anyway ... food for
> thought.
> > >
> > > regards ... Chris
> > > Great White North Technical Evangelist
> > >
> > >
> > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > news:3f661c53$1@forums-2-dub...
> > > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> > > successfully
> > > > created a simple application. Our consolidated database is ORACLE
and
> I
> > > > understand we have to run a SQL to create the ML_* tables for the
> > Mobilink
> > > > synchronization process. Moreover, we have to purchase a license in
> > > deploying
> > > > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > > > Synchronization technologies and Sybase Central Administration tool.
> > Now,
> > > that
> > > > turns me off (sorry..).
> > > >
> > > > My question: Is there any other way to synchronize with the
> consolidated
> > > Oracle
> > > > database without using the Mobilink synchronization technique? I
knew
> we
> > > can
> > > > write a Powerbuilder application to read an ASA local database but
> again
> > > it's
> > > > not royalty free since we will be deploying that database off the
> Pocket
> > > PC
> > > > 2002. Can we use the SaveAs function to create a text or Excel or
DBF
> > file
> > > on
> > > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> > manipulate
> > > or
> > > > use it within Powerbuilder application to update Consolidated Oracle
> > > database?
> > > >
> > > > Your input is greatly appreciated.
> > > >
> > > > Thanks,
> > > > Jun
> > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-17 17:14:43.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f675112@forums-1-dub> <3f676a5c$1@forums-1-dub> <3f686607$1@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 135
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 209.47.227.135
X-Original-NNTP-Posting-Host: 209.47.227.135
Message-ID: <3f689683@forums-1-dub>
Date: 17 Sep 2003 10:14:43 -0700
X-Trace: forums-1-dub 1063818883 209.47.227.135 (17 Sep 2003 10:14:43 -0700)
X-Original-Trace: 17 Sep 2003 10:14:43 -0700, 209.47.227.135
X-Authenticated-User: PPBBeta11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:499
Article PK: 267033

OK I will forgive you this time ... just kidding - thought that might be
your view point.

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f686607$1@forums-2-dub...
> The newsgroup caused me to assume this was a PPC app.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f676a5c$1@forums-1-dub...
> > Dean;
> >
> > I am not connecting using PPB. It is from a native PB 9 application.
> >
> > regards ... Chris
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f675112@forums-1-dub...
> > > Chris -
> > >
> > > If you connect to a remote database you must license ASA on the
handled.
> I
> > > did not realize there was an additional license to use mobilink beyond
> > > licensing ASA. I will find out and post what I find.
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > news:3f67246f$1@forums-1-dub...
> > > > Jun;
> > > >
> > > > I developed my own "Sync" utility using PB 9 and Pipelines. It took
> me
> > > > about a day to program and another day to unit test. It is now in
> > > production
> > > > and rock solid. The utility (runs on the PC) connects to the
corporate
> > DB
> > > > and PPC ASA simultaneously and pipes data both ways! I was in the
same
> > > > quandary as you currently, as the MobiLink solution was elegant but
> way
> > > too
> > > > costly to charge to the client to make my application cost
effective.
> > > >
> > > > So a home grown solution may not be that bad. Anyway ... food for
> > thought.
> > > >
> > > > regards ... Chris
> > > > Great White North Technical Evangelist
> > > >
> > > >
> > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > news:3f661c53$1@forums-2-dub...
> > > > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> > > > successfully
> > > > > created a simple application. Our consolidated database is ORACLE
> and
> > I
> > > > > understand we have to run a SQL to create the ML_* tables for the
> > > Mobilink
> > > > > synchronization process. Moreover, we have to purchase a license
in
> > > > deploying
> > > > > these components of Pocket Powerbuilder i.e. Mobilink and SQL
Remote
> > > > > Synchronization technologies and Sybase Central Administration
tool.
> > > Now,
> > > > that
> > > > > turns me off (sorry..).
> > > > >
> > > > > My question: Is there any other way to synchronize with the
> > consolidated
> > > > Oracle
> > > > > database without using the Mobilink synchronization technique? I
> knew
> > we
> > > > can
> > > > > write a Powerbuilder application to read an ASA local database but
> > again
> > > > it's
> > > > > not royalty free since we will be deploying that database off the
> > Pocket
> > > > PC
> > > > > 2002. Can we use the SaveAs function to create a text or Excel or
> DBF
> > > file
> > > > on
> > > > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> > > manipulate
> > > > or
> > > > > use it within Powerbuilder application to update Consolidated
Oracle
> > > > database?
> > > > >
> > > > > Your input is greatly appreciated.
> > > > >
> > > > > Thanks,
> > > > > Jun
> > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Sylvain Posted on 2003-09-17 01:33:25.0Z
From: Sylvain <newsgroup@cyberlog.ca>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: Alternative for Mobilink Synchronization
Message-ID: <MPG.19d183574bad2d54989695@forums.sybase.com>
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub>
Organization: Cyberlog
X-Newsreader: MicroPlanet Gravity v2.50
NNTP-Posting-Host: modemcable192.65-201-24.mtl.mc.videotron.ca
X-Original-NNTP-Posting-Host: modemcable192.65-201-24.mtl.mc.videotron.ca
Date: 16 Sep 2003 18:33:25 -0700
X-Trace: forums-1-dub 1063762405 24.201.65.192 (16 Sep 2003 18:33:25 -0700)
X-Original-Trace: 16 Sep 2003 18:33:25 -0700, modemcable192.65-201-24.mtl.mc.videotron.ca
Lines: 18
X-Authenticated-User: ppb
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:483
Article PK: 267019

Hi

Can you extend, or give more details on your solution?
Thank you


In article <3f67246f$1@forums-1-dub>, PollachC@SCC-CSC.gc.ca says...

> Jun;
>
> I developed my own "Sync" utility using PB 9 and Pipelines. It took me
> about a day to program and another day to unit test. It is now in production
> and rock solid. The utility (runs on the PC) connects to the corporate DB
> and PPC ASA simultaneously and pipes data both ways! I was in the same
> quandary as you currently, as the MobiLink solution was elegant but way too
> costly to charge to the client to make my application cost effective.
>
> So a home grown solution may not be that bad. Anyway ... food for thought.
>


Chris Pollach Posted on 2003-09-17 11:23:16.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <MPG.19d183574bad2d54989695@forums.sybase.com>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 34
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 209.47.227.135
X-Original-NNTP-Posting-Host: 209.47.227.135
Message-ID: <3f684424$1@forums-1-dub>
Date: 17 Sep 2003 04:23:16 -0700
X-Trace: forums-1-dub 1063797796 209.47.227.135 (17 Sep 2003 04:23:16 -0700)
X-Original-Trace: 17 Sep 2003 04:23:16 -0700, 209.47.227.135
X-Authenticated-User: PPBBeta11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:486
Article PK: 267021

Sylvain;

What would you like to know?
If you would like to take this discussion off-line, please e-mail me
directly!

regards ... Chris

"Sylvain" <newsgroup@cyberlog.ca> wrote in message
news:MPG.19d183574bad2d54989695@forums.sybase.com...
> Hi
>
> Can you extend, or give more details on your solution?
> Thank you
>
>
> In article <3f67246f$1@forums-1-dub>, PollachC@SCC-CSC.gc.ca says...
> > Jun;
> >
> > I developed my own "Sync" utility using PB 9 and Pipelines. It took me
> > about a day to program and another day to unit test. It is now in
production
> > and rock solid. The utility (runs on the PC) connects to the corporate
DB
> > and PPC ASA simultaneously and pipes data both ways! I was in the same
> > quandary as you currently, as the MobiLink solution was elegant but way
too
> > costly to charge to the client to make my application cost effective.
> >
> > So a home grown solution may not be that bad. Anyway ... food for
thought.
> >


Mark Hampton Posted on 2003-10-03 21:18:29.0Z
From: "Mark Hampton" <mhampton.removeme@datavantagecorp.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <MPG.19d183574bad2d54989695@forums.sybase.com> <3f684424$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: firewall.datavantagecorp.com
Message-ID: <3f7de85d@forums-2-dub>
X-Original-Trace: 3 Oct 2003 14:21:33 -0700, firewall.datavantagecorp.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Oct 2003 14:13:22 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Oct 2003 14:18:29 -0700
X-Trace: forums-1-dub 1065215909 10.22.108.75 (3 Oct 2003 14:18:29 -0700)
X-Original-Trace: 3 Oct 2003 14:18:29 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:700
Article PK: 267234

How are you connecting to the PPC database from the desktop PC? I can't
figure this one out...

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f684424$1@forums-1-dub...
> Sylvain;
>
> What would you like to know?
> If you would like to take this discussion off-line, please e-mail me
> directly!
>
> regards ... Chris
>
> "Sylvain" <newsgroup@cyberlog.ca> wrote in message
> news:MPG.19d183574bad2d54989695@forums.sybase.com...
> > Hi
> >
> > Can you extend, or give more details on your solution?
> > Thank you
> >
> >
> > In article <3f67246f$1@forums-1-dub>, PollachC@SCC-CSC.gc.ca says...
> > > Jun;
> > >
> > > I developed my own "Sync" utility using PB 9 and Pipelines. It took
me
> > > about a day to program and another day to unit test. It is now in
> production
> > > and rock solid. The utility (runs on the PC) connects to the corporate
> DB
> > > and PPC ASA simultaneously and pipes data both ways! I was in the same
> > > quandary as you currently, as the MobiLink solution was elegant but
way
> too
> > > costly to charge to the client to make my application cost effective.
> > >
> > > So a home grown solution may not be that bad. Anyway ... food for
> thought.
> > >
>
>


Dave Pylatuk Posted on 2003-09-22 19:25:33.0Z
From: "Dave Pylatuk" <davep@centurysystems.net>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 95
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 216.209.35.102
X-Original-NNTP-Posting-Host: 216.209.35.102
Message-ID: <3f6f4cad$1@forums-1-dub>
Date: 22 Sep 2003 12:25:33 -0700
X-Trace: forums-1-dub 1064258733 216.209.35.102 (22 Sep 2003 12:25:33 -0700)
X-Original-Trace: 22 Sep 2003 12:25:33 -0700, 216.209.35.102
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:533
Article PK: 267067

I noticed your post on the news groups, I am hoping I can follow up with

You a bit. We are attempting to move data as follows.

Case 1:

---------------------------------------------

PocketPC device (asa8) -> DesktopPC (asa 8)

We have this working. But we are stuck on the

Fact an ASA 8 engine has to be running on

The desktop before the pocket PC will connect

To it.

Case 2:

---------------------------------------------

Just to clarify, are you saying that you can

Use pb9/pipelines to connect between a database

On a server, and move data between the pocketPC

Database and the server ? Probably sounds like

A silly question but...

Thanks in advance

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f67246f$1@forums-1-dub...
> Jun;
>
> I developed my own "Sync" utility using PB 9 and Pipelines. It took me
> about a day to program and another day to unit test. It is now in
production
> and rock solid. The utility (runs on the PC) connects to the corporate DB
> and PPC ASA simultaneously and pipes data both ways! I was in the same
> quandary as you currently, as the MobiLink solution was elegant but way
too
> costly to charge to the client to make my application cost effective.
>
> So a home grown solution may not be that bad. Anyway ... food for thought.
>
> regards ... Chris
> Great White North Technical Evangelist
>
>
> "Jun " <junredillas@wvdhhr.org> wrote in message
> news:3f661c53$1@forums-2-dub...
> > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> successfully
> > created a simple application. Our consolidated database is ORACLE and I
> > understand we have to run a SQL to create the ML_* tables for the
Mobilink
> > synchronization process. Moreover, we have to purchase a license in
> deploying
> > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > Synchronization technologies and Sybase Central Administration tool.
Now,
> that
> > turns me off (sorry..).
> >
> > My question: Is there any other way to synchronize with the consolidated
> Oracle
> > database without using the Mobilink synchronization technique? I knew we
> can
> > write a Powerbuilder application to read an ASA local database but again
> it's
> > not royalty free since we will be deploying that database off the Pocket
> PC
> > 2002. Can we use the SaveAs function to create a text or Excel or DBF
file
> on
> > Pocket PC 2002 then ActiveSync to transfer to local PC and then
manipulate
> or
> > use it within Powerbuilder application to update Consolidated Oracle
> database?
> >
> > Your input is greatly appreciated.
> >
> > Thanks,
> > Jun
> > ---== Posted via the PFCGuide Web Newsreader ==---
> > http://www.pfcguide.com/_newsgroups/group_list.asp
>
>


Dean Jones [TeamSybase] Posted on 2003-09-23 20:16:41.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 122
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: dsl130.outtech.com
Message-ID: <3f70aabd$1@forums-2-dub>
X-Original-Trace: 23 Sep 2003 13:19:09 -0700, dsl130.outtech.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Sep 2003 13:12:33 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Sep 2003 13:16:41 -0700
X-Trace: forums-1-dub 1064348201 10.22.108.75 (23 Sep 2003 13:16:41 -0700)
X-Original-Trace: 23 Sep 2003 13:16:41 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:540
Article PK: 267073

If you sync databases you must license ASA. If you only run the desktop
version you can deploy without licensing. Basically its just like MS SQL CE.
If the data is used off of the hand held device in any way by any means you
must license the ASA database.

--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Dave Pylatuk" <davep@centurysystems.net> wrote in message
news:3f6f4cad$1@forums-1-dub...
> I noticed your post on the news groups, I am hoping I can follow up with
>
> You a bit. We are attempting to move data as follows.
>
> Case 1:
>
> ---------------------------------------------
>
> PocketPC device (asa8) -> DesktopPC (asa 8)
>
> We have this working. But we are stuck on the
>
> Fact an ASA 8 engine has to be running on
>
> The desktop before the pocket PC will connect
>
> To it.
>
> Case 2:
>
> ---------------------------------------------
>
> Just to clarify, are you saying that you can
>
> Use pb9/pipelines to connect between a database
>
> On a server, and move data between the pocketPC
>
> Database and the server ? Probably sounds like
>
> A silly question but...
>
> Thanks in advance
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f67246f$1@forums-1-dub...
> > Jun;
> >
> > I developed my own "Sync" utility using PB 9 and Pipelines. It took me
> > about a day to program and another day to unit test. It is now in
> production
> > and rock solid. The utility (runs on the PC) connects to the corporate
DB
> > and PPC ASA simultaneously and pipes data both ways! I was in the same
> > quandary as you currently, as the MobiLink solution was elegant but way
> too
> > costly to charge to the client to make my application cost effective.
> >
> > So a home grown solution may not be that bad. Anyway ... food for
thought.
> >
> > regards ... Chris
> > Great White North Technical Evangelist
> >
> >
> > "Jun " <junredillas@wvdhhr.org> wrote in message
> > news:3f661c53$1@forums-2-dub...
> > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> > successfully
> > > created a simple application. Our consolidated database is ORACLE and
I
> > > understand we have to run a SQL to create the ML_* tables for the
> Mobilink
> > > synchronization process. Moreover, we have to purchase a license in
> > deploying
> > > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > > Synchronization technologies and Sybase Central Administration tool.
> Now,
> > that
> > > turns me off (sorry..).
> > >
> > > My question: Is there any other way to synchronize with the
consolidated
> > Oracle
> > > database without using the Mobilink synchronization technique? I knew
we
> > can
> > > write a Powerbuilder application to read an ASA local database but
again
> > it's
> > > not royalty free since we will be deploying that database off the
Pocket
> > PC
> > > 2002. Can we use the SaveAs function to create a text or Excel or DBF
> file
> > on
> > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> manipulate
> > or
> > > use it within Powerbuilder application to update Consolidated Oracle
> > database?
> > >
> > > Your input is greatly appreciated.
> > >
> > > Thanks,
> > > Jun
> > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > http://www.pfcguide.com/_newsgroups/group_list.asp
> >
> >
>
>


Chris Pollach Posted on 2003-09-24 10:51:24.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 135
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: www.scc-csc.gc.ca
Message-ID: <3f7177c2$1@forums-2-dub>
X-Original-Trace: 24 Sep 2003 03:53:54 -0700, www.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Sep 2003 03:47:12 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Sep 2003 03:51:24 -0700
X-Trace: forums-1-dub 1064400684 10.22.108.75 (24 Sep 2003 03:51:24 -0700)
X-Original-Trace: 24 Sep 2003 03:51:24 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:544
Article PK: 267079

NO, not from PowerBuilder (cradled PC).

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f70aabd$1@forums-2-dub...
> If you sync databases you must license ASA. If you only run the desktop
> version you can deploy without licensing. Basically its just like MS SQL
CE.
> If the data is used off of the hand held device in any way by any means
you
> must license the ASA database.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> news:3f6f4cad$1@forums-1-dub...
> > I noticed your post on the news groups, I am hoping I can follow up with
> >
> > You a bit. We are attempting to move data as follows.
> >
> > Case 1:
> >
> > ---------------------------------------------
> >
> > PocketPC device (asa8) -> DesktopPC (asa 8)
> >
> > We have this working. But we are stuck on the
> >
> > Fact an ASA 8 engine has to be running on
> >
> > The desktop before the pocket PC will connect
> >
> > To it.
> >
> > Case 2:
> >
> > ---------------------------------------------
> >
> > Just to clarify, are you saying that you can
> >
> > Use pb9/pipelines to connect between a database
> >
> > On a server, and move data between the pocketPC
> >
> > Database and the server ? Probably sounds like
> >
> > A silly question but...
> >
> > Thanks in advance
> >
> > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > news:3f67246f$1@forums-1-dub...
> > > Jun;
> > >
> > > I developed my own "Sync" utility using PB 9 and Pipelines. It took
me
> > > about a day to program and another day to unit test. It is now in
> > production
> > > and rock solid. The utility (runs on the PC) connects to the corporate
> DB
> > > and PPC ASA simultaneously and pipes data both ways! I was in the same
> > > quandary as you currently, as the MobiLink solution was elegant but
way
> > too
> > > costly to charge to the client to make my application cost effective.
> > >
> > > So a home grown solution may not be that bad. Anyway ... food for
> thought.
> > >
> > > regards ... Chris
> > > Great White North Technical Evangelist
> > >
> > >
> > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > news:3f661c53$1@forums-2-dub...
> > > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> > > successfully
> > > > created a simple application. Our consolidated database is ORACLE
and
> I
> > > > understand we have to run a SQL to create the ML_* tables for the
> > Mobilink
> > > > synchronization process. Moreover, we have to purchase a license in
> > > deploying
> > > > these components of Pocket Powerbuilder i.e. Mobilink and SQL Remote
> > > > Synchronization technologies and Sybase Central Administration tool.
> > Now,
> > > that
> > > > turns me off (sorry..).
> > > >
> > > > My question: Is there any other way to synchronize with the
> consolidated
> > > Oracle
> > > > database without using the Mobilink synchronization technique? I
knew
> we
> > > can
> > > > write a Powerbuilder application to read an ASA local database but
> again
> > > it's
> > > > not royalty free since we will be deploying that database off the
> Pocket
> > > PC
> > > > 2002. Can we use the SaveAs function to create a text or Excel or
DBF
> > file
> > > on
> > > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> > manipulate
> > > or
> > > > use it within Powerbuilder application to update Consolidated Oracle
> > > database?
> > > >
> > > > Your input is greatly appreciated.
> > > >
> > > > Thanks,
> > > > Jun
> > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > >
> > >
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-09-24 13:41:37.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 175
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 216.207.144.172
X-Original-NNTP-Posting-Host: 216.207.144.172
Message-ID: <3f719f11$1@forums-1-dub>
Date: 24 Sep 2003 06:41:37 -0700
X-Trace: forums-1-dub 1064410897 216.207.144.172 (24 Sep 2003 06:41:37 -0700)
X-Original-Trace: 24 Sep 2003 06:41:37 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:549
Article PK: 267083

I have been on the phone with Sybase on this issue a lot lately. The version
of ASA that can be distributed is not license to sync data back to any
database. If you sync data you must license the database for each install.
About $120 per client. My company is a iAnywhere partner and I have research
this. I would not tell developers they can do this without approval from
Sybase/iAnywhere.

I am referring to the Desktop Runtime Edition. The one that you can
distribute with your applications. I will follow up with this some more, but
I have been sent several documents and so far they all save the data from
the desktop runtime edition cannot assess data from remote database and
cannot sync data with a remote database.

I will get on the phone again and see if I can get someone from Sybase to
clarify this issue.

--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f7177c2$1@forums-2-dub...
> NO, not from PowerBuilder (cradled PC).
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f70aabd$1@forums-2-dub...
> > If you sync databases you must license ASA. If you only run the desktop
> > version you can deploy without licensing. Basically its just like MS SQL
> CE.
> > If the data is used off of the hand held device in any way by any means
> you
> > must license the ASA database.
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > news:3f6f4cad$1@forums-1-dub...
> > > I noticed your post on the news groups, I am hoping I can follow up
with
> > >
> > > You a bit. We are attempting to move data as follows.
> > >
> > > Case 1:
> > >
> > > ---------------------------------------------
> > >
> > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > >
> > > We have this working. But we are stuck on the
> > >
> > > Fact an ASA 8 engine has to be running on
> > >
> > > The desktop before the pocket PC will connect
> > >
> > > To it.
> > >
> > > Case 2:
> > >
> > > ---------------------------------------------
> > >
> > > Just to clarify, are you saying that you can
> > >
> > > Use pb9/pipelines to connect between a database
> > >
> > > On a server, and move data between the pocketPC
> > >
> > > Database and the server ? Probably sounds like
> > >
> > > A silly question but...
> > >
> > > Thanks in advance
> > >
> > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > news:3f67246f$1@forums-1-dub...
> > > > Jun;
> > > >
> > > > I developed my own "Sync" utility using PB 9 and Pipelines. It took
> me
> > > > about a day to program and another day to unit test. It is now in
> > > production
> > > > and rock solid. The utility (runs on the PC) connects to the
corporate
> > DB
> > > > and PPC ASA simultaneously and pipes data both ways! I was in the
same
> > > > quandary as you currently, as the MobiLink solution was elegant but
> way
> > > too
> > > > costly to charge to the client to make my application cost
effective.
> > > >
> > > > So a home grown solution may not be that bad. Anyway ... food for
> > thought.
> > > >
> > > > regards ... Chris
> > > > Great White North Technical Evangelist
> > > >
> > > >
> > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > news:3f661c53$1@forums-2-dub...
> > > > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and has
> > > > successfully
> > > > > created a simple application. Our consolidated database is ORACLE
> and
> > I
> > > > > understand we have to run a SQL to create the ML_* tables for the
> > > Mobilink
> > > > > synchronization process. Moreover, we have to purchase a license
in
> > > > deploying
> > > > > these components of Pocket Powerbuilder i.e. Mobilink and SQL
Remote
> > > > > Synchronization technologies and Sybase Central Administration
tool.
> > > Now,
> > > > that
> > > > > turns me off (sorry..).
> > > > >
> > > > > My question: Is there any other way to synchronize with the
> > consolidated
> > > > Oracle
> > > > > database without using the Mobilink synchronization technique? I
> knew
> > we
> > > > can
> > > > > write a Powerbuilder application to read an ASA local database but
> > again
> > > > it's
> > > > > not royalty free since we will be deploying that database off the
> > Pocket
> > > > PC
> > > > > 2002. Can we use the SaveAs function to create a text or Excel or
> DBF
> > > file
> > > > on
> > > > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> > > manipulate
> > > > or
> > > > > use it within Powerbuilder application to update Consolidated
Oracle
> > > > database?
> > > > >
> > > > > Your input is greatly appreciated.
> > > > >
> > > > > Thanks,
> > > > > Jun
> > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-24 14:58:46.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 198
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: firewall.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: firewall.scc-csc.gc.ca
Message-ID: <3f71b126$1@forums-1-dub>
Date: 24 Sep 2003 07:58:46 -0700
X-Trace: forums-1-dub 1064415526 209.47.227.130 (24 Sep 2003 07:58:46 -0700)
X-Original-Trace: 24 Sep 2003 07:58:46 -0700, firewall.scc-csc.gc.ca
X-Authenticated-User: PPBBeta11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:558
Article PK: 267095

No, that is for Mobilink. You are free to Export/Import data from where
ever. The only run time ASA engine restriction is you can not perform DDL
and no SP's!

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f719f11$1@forums-1-dub...
> I have been on the phone with Sybase on this issue a lot lately. The
version
> of ASA that can be distributed is not license to sync data back to any
> database. If you sync data you must license the database for each install.
> About $120 per client. My company is a iAnywhere partner and I have
research
> this. I would not tell developers they can do this without approval from
> Sybase/iAnywhere.
>
> I am referring to the Desktop Runtime Edition. The one that you can
> distribute with your applications. I will follow up with this some more,
but
> I have been sent several documents and so far they all save the data from
> the desktop runtime edition cannot assess data from remote database and
> cannot sync data with a remote database.
>
> I will get on the phone again and see if I can get someone from Sybase to
> clarify this issue.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f7177c2$1@forums-2-dub...
> > NO, not from PowerBuilder (cradled PC).
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f70aabd$1@forums-2-dub...
> > > If you sync databases you must license ASA. If you only run the
desktop
> > > version you can deploy without licensing. Basically its just like MS
SQL
> > CE.
> > > If the data is used off of the hand held device in any way by any
means
> > you
> > > must license the ASA database.
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > news:3f6f4cad$1@forums-1-dub...
> > > > I noticed your post on the news groups, I am hoping I can follow up
> with
> > > >
> > > > You a bit. We are attempting to move data as follows.
> > > >
> > > > Case 1:
> > > >
> > > > ---------------------------------------------
> > > >
> > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > >
> > > > We have this working. But we are stuck on the
> > > >
> > > > Fact an ASA 8 engine has to be running on
> > > >
> > > > The desktop before the pocket PC will connect
> > > >
> > > > To it.
> > > >
> > > > Case 2:
> > > >
> > > > ---------------------------------------------
> > > >
> > > > Just to clarify, are you saying that you can
> > > >
> > > > Use pb9/pipelines to connect between a database
> > > >
> > > > On a server, and move data between the pocketPC
> > > >
> > > > Database and the server ? Probably sounds like
> > > >
> > > > A silly question but...
> > > >
> > > > Thanks in advance
> > > >
> > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > news:3f67246f$1@forums-1-dub...
> > > > > Jun;
> > > > >
> > > > > I developed my own "Sync" utility using PB 9 and Pipelines. It
took
> > me
> > > > > about a day to program and another day to unit test. It is now in
> > > > production
> > > > > and rock solid. The utility (runs on the PC) connects to the
> corporate
> > > DB
> > > > > and PPC ASA simultaneously and pipes data both ways! I was in the
> same
> > > > > quandary as you currently, as the MobiLink solution was elegant
but
> > way
> > > > too
> > > > > costly to charge to the client to make my application cost
> effective.
> > > > >
> > > > > So a home grown solution may not be that bad. Anyway ... food for
> > > thought.
> > > > >
> > > > > regards ... Chris
> > > > > Great White North Technical Evangelist
> > > > >
> > > > >
> > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > news:3f661c53$1@forums-2-dub...
> > > > > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and
has
> > > > > successfully
> > > > > > created a simple application. Our consolidated database is
ORACLE
> > and
> > > I
> > > > > > understand we have to run a SQL to create the ML_* tables for
the
> > > > Mobilink
> > > > > > synchronization process. Moreover, we have to purchase a license
> in
> > > > > deploying
> > > > > > these components of Pocket Powerbuilder i.e. Mobilink and SQL
> Remote
> > > > > > Synchronization technologies and Sybase Central Administration
> tool.
> > > > Now,
> > > > > that
> > > > > > turns me off (sorry..).
> > > > > >
> > > > > > My question: Is there any other way to synchronize with the
> > > consolidated
> > > > > Oracle
> > > > > > database without using the Mobilink synchronization technique? I
> > knew
> > > we
> > > > > can
> > > > > > write a Powerbuilder application to read an ASA local database
but
> > > again
> > > > > it's
> > > > > > not royalty free since we will be deploying that database off
the
> > > Pocket
> > > > > PC
> > > > > > 2002. Can we use the SaveAs function to create a text or Excel
or
> > DBF
> > > > file
> > > > > on
> > > > > > Pocket PC 2002 then ActiveSync to transfer to local PC and then
> > > > manipulate
> > > > > or
> > > > > > use it within Powerbuilder application to update Consolidated
> Oracle
> > > > > database?
> > > > > >
> > > > > > Your input is greatly appreciated.
> > > > > >
> > > > > > Thanks,
> > > > > > Jun
> > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-09-24 15:11:27.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub> <3f71b126$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 306
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 216.207.144.172
Message-ID: <3f71b4b8@forums-2-dub>
X-Original-Trace: 24 Sep 2003 08:14:00 -0700, 216.207.144.172
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Sep 2003 08:07:16 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Sep 2003 08:11:27 -0700
X-Trace: forums-1-dub 1064416287 10.22.108.75 (24 Sep 2003 08:11:27 -0700)
X-Original-Trace: 24 Sep 2003 08:11:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:561
Article PK: 267094

Here is the answer from Sybase.

>>
Both accessing and sending are prohibited. This is a stipulation of the
licensing for the runtime. No replication by any means.

<<

Here is the ReadMe. This is a list of restrictions. The No remote data
access is the only one that is confussing. Does it mean you cannot access
data on a remote server or send data to a remote server. I just talked with
iAnywhere and the answer stated above. No replication by any means or you
must license the software. Again I'm stating what I'm told from iAnywhere
and information I'm reading in the ASA runtime engine files.



The major restrictions for the Desktop Runtime Edition are as follows:

¨ No transaction log The Desktop Runtime Edition does not use a

transaction log. Consequently, it cannot take part in a replication or

synchronization environment.

¨ No data definition You cannot create or alter database objects such as

stored procedures, tables, and indexes.

¨ No stored procedures, events, or triggers The Desktop Runtime

Edition does not support the use of stored procedures, events, or triggers.

Consequently, procedure profiling is not available.

¨ No events or schedules The Desktop Runtime Edition does not

support events or scheduling of events.

¨ No defragmentation support You cannot query the database for

fragmentation, nor can you issue defragmentation commands.

¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition

does not support transactions involved with Distributed Transaction

Coordination.

¨ No support for SMP-capable machines The Desktop Runtime Edition

does not support multi-processor machines.

No Java The Java-in-the-database features are not available in the

Desktop Runtime Edition.

¨ No remote data access You cannot access data on remote servers

using the Desktop Runtime Edition.

¨ No jConnect access You can access the Desktop Runtime Edition

from JDBC using the iAnywhere JDBC driver, but not using the Sybase

jConnect JDBC driver.

¨ No database file encryption The Desktop Runtime Edition does not

support database file encryption.

¨ No communication encryption You cannot encrypt client/server

communications using the Desktop Runtime Edition.

¨ No web services The Desktop Runtime Edition does not support web

services, including HTTP server and SOAP.




--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f71b126$1@forums-1-dub...
> No, that is for Mobilink. You are free to Export/Import data from where
> ever. The only run time ASA engine restriction is you can not perform DDL
> and no SP's!
>
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f719f11$1@forums-1-dub...
> > I have been on the phone with Sybase on this issue a lot lately. The
> version
> > of ASA that can be distributed is not license to sync data back to any
> > database. If you sync data you must license the database for each
install.
> > About $120 per client. My company is a iAnywhere partner and I have
> research
> > this. I would not tell developers they can do this without approval from
> > Sybase/iAnywhere.
> >
> > I am referring to the Desktop Runtime Edition. The one that you can
> > distribute with your applications. I will follow up with this some more,
> but
> > I have been sent several documents and so far they all save the data
from
> > the desktop runtime edition cannot assess data from remote database and
> > cannot sync data with a remote database.
> >
> > I will get on the phone again and see if I can get someone from Sybase
to
> > clarify this issue.
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > news:3f7177c2$1@forums-2-dub...
> > > NO, not from PowerBuilder (cradled PC).
> > >
> > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > message
> > > news:3f70aabd$1@forums-2-dub...
> > > > If you sync databases you must license ASA. If you only run the
> desktop
> > > > version you can deploy without licensing. Basically its just like MS
> SQL
> > > CE.
> > > > If the data is used off of the hand held device in any way by any
> means
> > > you
> > > > must license the ASA database.
> > > >
> > > > --
> > > > Dean Jones [TeamSybase]
> > > > CEO
> > > > PowerObjects
> > > > http://www.powerobjects.com
> > > > (612) 339-3355 ext 112
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > news:3f6f4cad$1@forums-1-dub...
> > > > > I noticed your post on the news groups, I am hoping I can follow
up
> > with
> > > > >
> > > > > You a bit. We are attempting to move data as follows.
> > > > >
> > > > > Case 1:
> > > > >
> > > > > ---------------------------------------------
> > > > >
> > > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > > >
> > > > > We have this working. But we are stuck on the
> > > > >
> > > > > Fact an ASA 8 engine has to be running on
> > > > >
> > > > > The desktop before the pocket PC will connect
> > > > >
> > > > > To it.
> > > > >
> > > > > Case 2:
> > > > >
> > > > > ---------------------------------------------
> > > > >
> > > > > Just to clarify, are you saying that you can
> > > > >
> > > > > Use pb9/pipelines to connect between a database
> > > > >
> > > > > On a server, and move data between the pocketPC
> > > > >
> > > > > Database and the server ? Probably sounds like
> > > > >
> > > > > A silly question but...
> > > > >
> > > > > Thanks in advance
> > > > >
> > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > news:3f67246f$1@forums-1-dub...
> > > > > > Jun;
> > > > > >
> > > > > > I developed my own "Sync" utility using PB 9 and Pipelines. It
> took
> > > me
> > > > > > about a day to program and another day to unit test. It is now
in
> > > > > production
> > > > > > and rock solid. The utility (runs on the PC) connects to the
> > corporate
> > > > DB
> > > > > > and PPC ASA simultaneously and pipes data both ways! I was in
the
> > same
> > > > > > quandary as you currently, as the MobiLink solution was elegant
> but
> > > way
> > > > > too
> > > > > > costly to charge to the client to make my application cost
> > effective.
> > > > > >
> > > > > > So a home grown solution may not be that bad. Anyway ... food
for
> > > > thought.
> > > > > >
> > > > > > regards ... Chris
> > > > > > Great White North Technical Evangelist
> > > > > >
> > > > > >
> > > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > > news:3f661c53$1@forums-2-dub...
> > > > > > > I have been trying the Pocket Powerbuilder 1.0 Evaluation and
> has
> > > > > > successfully
> > > > > > > created a simple application. Our consolidated database is
> ORACLE
> > > and
> > > > I
> > > > > > > understand we have to run a SQL to create the ML_* tables for
> the
> > > > > Mobilink
> > > > > > > synchronization process. Moreover, we have to purchase a
license
> > in
> > > > > > deploying
> > > > > > > these components of Pocket Powerbuilder i.e. Mobilink and SQL
> > Remote
> > > > > > > Synchronization technologies and Sybase Central Administration
> > tool.
> > > > > Now,
> > > > > > that
> > > > > > > turns me off (sorry..).
> > > > > > >
> > > > > > > My question: Is there any other way to synchronize with the
> > > > consolidated
> > > > > > Oracle
> > > > > > > database without using the Mobilink synchronization technique?
I
> > > knew
> > > > we
> > > > > > can
> > > > > > > write a Powerbuilder application to read an ASA local database
> but
> > > > again
> > > > > > it's
> > > > > > > not royalty free since we will be deploying that database off
> the
> > > > Pocket
> > > > > > PC
> > > > > > > 2002. Can we use the SaveAs function to create a text or Excel
> or
> > > DBF
> > > > > file
> > > > > > on
> > > > > > > Pocket PC 2002 then ActiveSync to transfer to local PC and
then
> > > > > manipulate
> > > > > > or
> > > > > > > use it within Powerbuilder application to update Consolidated
> > Oracle
> > > > > > database?
> > > > > > >
> > > > > > > Your input is greatly appreciated.
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Jun
> > > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-24 16:50:06.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub> <3f71b126$1@forums-1-dub> <3f71b4b8@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 335
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 209.47.227.134
X-Original-NNTP-Posting-Host: 209.47.227.134
Message-ID: <3f71cb3e$1@forums-1-dub>
Date: 24 Sep 2003 09:50:06 -0700
X-Trace: forums-1-dub 1064422206 209.47.227.134 (24 Sep 2003 09:50:06 -0700)
X-Original-Trace: 24 Sep 2003 09:50:06 -0700, 209.47.227.134
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:564
Article PK: 267097

Dean;

So how do you load the database???????
Come one really!

Chris

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f71b4b8@forums-2-dub...
> Here is the answer from Sybase.
>
> >>
> Both accessing and sending are prohibited. This is a stipulation of the
> licensing for the runtime. No replication by any means.
>
> <<
>
> Here is the ReadMe. This is a list of restrictions. The No remote data
> access is the only one that is confussing. Does it mean you cannot access
> data on a remote server or send data to a remote server. I just talked
with
> iAnywhere and the answer stated above. No replication by any means or you
> must license the software. Again I'm stating what I'm told from iAnywhere
> and information I'm reading in the ASA runtime engine files.
>
>
>
> The major restrictions for the Desktop Runtime Edition are as follows:
>
> ¨ No transaction log The Desktop Runtime Edition does not use a
>
> transaction log. Consequently, it cannot take part in a replication or
>
> synchronization environment.
>
> ¨ No data definition You cannot create or alter database objects such as
>
> stored procedures, tables, and indexes.
>
> ¨ No stored procedures, events, or triggers The Desktop Runtime
>
> Edition does not support the use of stored procedures, events, or
triggers.
>
> Consequently, procedure profiling is not available.
>
> ¨ No events or schedules The Desktop Runtime Edition does not
>
> support events or scheduling of events.
>
> ¨ No defragmentation support You cannot query the database for
>
> fragmentation, nor can you issue defragmentation commands.
>
> ¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition
>
> does not support transactions involved with Distributed Transaction
>
> Coordination.
>
> ¨ No support for SMP-capable machines The Desktop Runtime Edition
>
> does not support multi-processor machines.
>
> No Java The Java-in-the-database features are not available in the
>
> Desktop Runtime Edition.
>
> ¨ No remote data access You cannot access data on remote servers
>
> using the Desktop Runtime Edition.
>
> ¨ No jConnect access You can access the Desktop Runtime Edition
>
> from JDBC using the iAnywhere JDBC driver, but not using the Sybase
>
> jConnect JDBC driver.
>
> ¨ No database file encryption The Desktop Runtime Edition does not
>
> support database file encryption.
>
> ¨ No communication encryption You cannot encrypt client/server
>
> communications using the Desktop Runtime Edition.
>
> ¨ No web services The Desktop Runtime Edition does not support web
>
> services, including HTTP server and SOAP.
>
>
>
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f71b126$1@forums-1-dub...
> > No, that is for Mobilink. You are free to Export/Import data from where
> > ever. The only run time ASA engine restriction is you can not perform
DDL
> > and no SP's!
> >
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f719f11$1@forums-1-dub...
> > > I have been on the phone with Sybase on this issue a lot lately. The
> > version
> > > of ASA that can be distributed is not license to sync data back to any
> > > database. If you sync data you must license the database for each
> install.
> > > About $120 per client. My company is a iAnywhere partner and I have
> > research
> > > this. I would not tell developers they can do this without approval
from
> > > Sybase/iAnywhere.
> > >
> > > I am referring to the Desktop Runtime Edition. The one that you can
> > > distribute with your applications. I will follow up with this some
more,
> > but
> > > I have been sent several documents and so far they all save the data
> from
> > > the desktop runtime edition cannot assess data from remote database
and
> > > cannot sync data with a remote database.
> > >
> > > I will get on the phone again and see if I can get someone from Sybase
> to
> > > clarify this issue.
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > news:3f7177c2$1@forums-2-dub...
> > > > NO, not from PowerBuilder (cradled PC).
> > > >
> > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > > message
> > > > news:3f70aabd$1@forums-2-dub...
> > > > > If you sync databases you must license ASA. If you only run the
> > desktop
> > > > > version you can deploy without licensing. Basically its just like
MS
> > SQL
> > > > CE.
> > > > > If the data is used off of the hand held device in any way by any
> > means
> > > > you
> > > > > must license the ASA database.
> > > > >
> > > > > --
> > > > > Dean Jones [TeamSybase]
> > > > > CEO
> > > > > PowerObjects
> > > > > http://www.powerobjects.com
> > > > > (612) 339-3355 ext 112
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > news:3f6f4cad$1@forums-1-dub...
> > > > > > I noticed your post on the news groups, I am hoping I can follow
> up
> > > with
> > > > > >
> > > > > > You a bit. We are attempting to move data as follows.
> > > > > >
> > > > > > Case 1:
> > > > > >
> > > > > > ---------------------------------------------
> > > > > >
> > > > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > > > >
> > > > > > We have this working. But we are stuck on the
> > > > > >
> > > > > > Fact an ASA 8 engine has to be running on
> > > > > >
> > > > > > The desktop before the pocket PC will connect
> > > > > >
> > > > > > To it.
> > > > > >
> > > > > > Case 2:
> > > > > >
> > > > > > ---------------------------------------------
> > > > > >
> > > > > > Just to clarify, are you saying that you can
> > > > > >
> > > > > > Use pb9/pipelines to connect between a database
> > > > > >
> > > > > > On a server, and move data between the pocketPC
> > > > > >
> > > > > > Database and the server ? Probably sounds like
> > > > > >
> > > > > > A silly question but...
> > > > > >
> > > > > > Thanks in advance
> > > > > >
> > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > news:3f67246f$1@forums-1-dub...
> > > > > > > Jun;
> > > > > > >
> > > > > > > I developed my own "Sync" utility using PB 9 and Pipelines.
It
> > took
> > > > me
> > > > > > > about a day to program and another day to unit test. It is now
> in
> > > > > > production
> > > > > > > and rock solid. The utility (runs on the PC) connects to the
> > > corporate
> > > > > DB
> > > > > > > and PPC ASA simultaneously and pipes data both ways! I was in
> the
> > > same
> > > > > > > quandary as you currently, as the MobiLink solution was
elegant
> > but
> > > > way
> > > > > > too
> > > > > > > costly to charge to the client to make my application cost
> > > effective.
> > > > > > >
> > > > > > > So a home grown solution may not be that bad. Anyway ... food
> for
> > > > > thought.
> > > > > > >
> > > > > > > regards ... Chris
> > > > > > > Great White North Technical Evangelist
> > > > > > >
> > > > > > >
> > > > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > > > news:3f661c53$1@forums-2-dub...
> > > > > > > > I have been trying the Pocket Powerbuilder 1.0 Evaluation
and
> > has
> > > > > > > successfully
> > > > > > > > created a simple application. Our consolidated database is
> > ORACLE
> > > > and
> > > > > I
> > > > > > > > understand we have to run a SQL to create the ML_* tables
for
> > the
> > > > > > Mobilink
> > > > > > > > synchronization process. Moreover, we have to purchase a
> license
> > > in
> > > > > > > deploying
> > > > > > > > these components of Pocket Powerbuilder i.e. Mobilink and
SQL
> > > Remote
> > > > > > > > Synchronization technologies and Sybase Central
Administration
> > > tool.
> > > > > > Now,
> > > > > > > that
> > > > > > > > turns me off (sorry..).
> > > > > > > >
> > > > > > > > My question: Is there any other way to synchronize with the
> > > > > consolidated
> > > > > > > Oracle
> > > > > > > > database without using the Mobilink synchronization
technique?
> I
> > > > knew
> > > > > we
> > > > > > > can
> > > > > > > > write a Powerbuilder application to read an ASA local
database
> > but
> > > > > again
> > > > > > > it's
> > > > > > > > not royalty free since we will be deploying that database
off
> > the
> > > > > Pocket
> > > > > > > PC
> > > > > > > > 2002. Can we use the SaveAs function to create a text or
Excel
> > or
> > > > DBF
> > > > > > file
> > > > > > > on
> > > > > > > > Pocket PC 2002 then ActiveSync to transfer to local PC and
> then
> > > > > > manipulate
> > > > > > > or
> > > > > > > > use it within Powerbuilder application to update
Consolidated
> > > Oracle
> > > > > > > database?
> > > > > > > >
> > > > > > > > Your input is greatly appreciated.
> > > > > > > >
> > > > > > > > Thanks,
> > > > > > > > Jun
> > > > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-09-25 03:31:28.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub> <3f71b126$1@forums-1-dub> <3f71b4b8@forums-2-dub> <3f71cb3e$1@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 383
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: dsl130.outtech.com
Message-ID: <3f726227@forums-2-dub>
X-Original-Trace: 24 Sep 2003 20:33:59 -0700, dsl130.outtech.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Sep 2003 20:27:13 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Sep 2003 20:31:28 -0700
X-Trace: forums-1-dub 1064460688 10.22.108.75 (24 Sep 2003 20:31:28 -0700)
X-Original-Trace: 24 Sep 2003 20:31:28 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:575
Article PK: 267109

you would load it with your program. If data is sync'ed to the db or sync'ed
from it you must license the database.

If Sybase didn't make users license the database how would they make
money??????
Come on really!

My point is the argument can sounds dumb either direction. MS SQL CE is the
same way. If the data is used off the device it must be licensed. The
runtime engine is a stand-alone database for a stand-alone application.

Adaptive Server Anywhere is a great database. Its very inexpensive, small
foot-print, scalable... that's way companies purchase licenses of this great
DB.

My guess is if Sybase create drivers to connect directly to other databases
they will become part of ASA product. Just my .02.

--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f71cb3e$1@forums-1-dub...
> Dean;
>
> So how do you load the database???????
> Come one really!
>
> Chris
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f71b4b8@forums-2-dub...
> > Here is the answer from Sybase.
> >
> > >>
> > Both accessing and sending are prohibited. This is a stipulation of the
> > licensing for the runtime. No replication by any means.
> >
> > <<
> >
> > Here is the ReadMe. This is a list of restrictions. The No remote data
> > access is the only one that is confussing. Does it mean you cannot
access
> > data on a remote server or send data to a remote server. I just talked
> with
> > iAnywhere and the answer stated above. No replication by any means or
you
> > must license the software. Again I'm stating what I'm told from
iAnywhere
> > and information I'm reading in the ASA runtime engine files.
> >
> >
> >
> > The major restrictions for the Desktop Runtime Edition are as follows:
> >
> > ¨ No transaction log The Desktop Runtime Edition does not use a
> >
> > transaction log. Consequently, it cannot take part in a replication or
> >
> > synchronization environment.
> >
> > ¨ No data definition You cannot create or alter database objects such as
> >
> > stored procedures, tables, and indexes.
> >
> > ¨ No stored procedures, events, or triggers The Desktop Runtime
> >
> > Edition does not support the use of stored procedures, events, or
> triggers.
> >
> > Consequently, procedure profiling is not available.
> >
> > ¨ No events or schedules The Desktop Runtime Edition does not
> >
> > support events or scheduling of events.
> >
> > ¨ No defragmentation support You cannot query the database for
> >
> > fragmentation, nor can you issue defragmentation commands.
> >
> > ¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition
> >
> > does not support transactions involved with Distributed Transaction
> >
> > Coordination.
> >
> > ¨ No support for SMP-capable machines The Desktop Runtime Edition
> >
> > does not support multi-processor machines.
> >
> > No Java The Java-in-the-database features are not available in the
> >
> > Desktop Runtime Edition.
> >
> > ¨ No remote data access You cannot access data on remote servers
> >
> > using the Desktop Runtime Edition.
> >
> > ¨ No jConnect access You can access the Desktop Runtime Edition
> >
> > from JDBC using the iAnywhere JDBC driver, but not using the Sybase
> >
> > jConnect JDBC driver.
> >
> > ¨ No database file encryption The Desktop Runtime Edition does not
> >
> > support database file encryption.
> >
> > ¨ No communication encryption You cannot encrypt client/server
> >
> > communications using the Desktop Runtime Edition.
> >
> > ¨ No web services The Desktop Runtime Edition does not support web
> >
> > services, including HTTP server and SOAP.
> >
> >
> >
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > news:3f71b126$1@forums-1-dub...
> > > No, that is for Mobilink. You are free to Export/Import data from
where
> > > ever. The only run time ASA engine restriction is you can not perform
> DDL
> > > and no SP's!
> > >
> > >
> > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > message
> > > news:3f719f11$1@forums-1-dub...
> > > > I have been on the phone with Sybase on this issue a lot lately. The
> > > version
> > > > of ASA that can be distributed is not license to sync data back to
any
> > > > database. If you sync data you must license the database for each
> > install.
> > > > About $120 per client. My company is a iAnywhere partner and I have
> > > research
> > > > this. I would not tell developers they can do this without approval
> from
> > > > Sybase/iAnywhere.
> > > >
> > > > I am referring to the Desktop Runtime Edition. The one that you can
> > > > distribute with your applications. I will follow up with this some
> more,
> > > but
> > > > I have been sent several documents and so far they all save the data
> > from
> > > > the desktop runtime edition cannot assess data from remote database
> and
> > > > cannot sync data with a remote database.
> > > >
> > > > I will get on the phone again and see if I can get someone from
Sybase
> > to
> > > > clarify this issue.
> > > >
> > > > --
> > > > Dean Jones [TeamSybase]
> > > > CEO
> > > > PowerObjects
> > > > http://www.powerobjects.com
> > > > (612) 339-3355 ext 112
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > news:3f7177c2$1@forums-2-dub...
> > > > > NO, not from PowerBuilder (cradled PC).
> > > > >
> > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote
in
> > > > message
> > > > > news:3f70aabd$1@forums-2-dub...
> > > > > > If you sync databases you must license ASA. If you only run the
> > > desktop
> > > > > > version you can deploy without licensing. Basically its just
like
> MS
> > > SQL
> > > > > CE.
> > > > > > If the data is used off of the hand held device in any way by
any
> > > means
> > > > > you
> > > > > > must license the ASA database.
> > > > > >
> > > > > > --
> > > > > > Dean Jones [TeamSybase]
> > > > > > CEO
> > > > > > PowerObjects
> > > > > > http://www.powerobjects.com
> > > > > > (612) 339-3355 ext 112
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > > news:3f6f4cad$1@forums-1-dub...
> > > > > > > I noticed your post on the news groups, I am hoping I can
follow
> > up
> > > > with
> > > > > > >
> > > > > > > You a bit. We are attempting to move data as follows.
> > > > > > >
> > > > > > > Case 1:
> > > > > > >
> > > > > > > ---------------------------------------------
> > > > > > >
> > > > > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > > > > >
> > > > > > > We have this working. But we are stuck on the
> > > > > > >
> > > > > > > Fact an ASA 8 engine has to be running on
> > > > > > >
> > > > > > > The desktop before the pocket PC will connect
> > > > > > >
> > > > > > > To it.
> > > > > > >
> > > > > > > Case 2:
> > > > > > >
> > > > > > > ---------------------------------------------
> > > > > > >
> > > > > > > Just to clarify, are you saying that you can
> > > > > > >
> > > > > > > Use pb9/pipelines to connect between a database
> > > > > > >
> > > > > > > On a server, and move data between the pocketPC
> > > > > > >
> > > > > > > Database and the server ? Probably sounds like
> > > > > > >
> > > > > > > A silly question but...
> > > > > > >
> > > > > > > Thanks in advance
> > > > > > >
> > > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > > news:3f67246f$1@forums-1-dub...
> > > > > > > > Jun;
> > > > > > > >
> > > > > > > > I developed my own "Sync" utility using PB 9 and Pipelines.
> It
> > > took
> > > > > me
> > > > > > > > about a day to program and another day to unit test. It is
now
> > in
> > > > > > > production
> > > > > > > > and rock solid. The utility (runs on the PC) connects to the
> > > > corporate
> > > > > > DB
> > > > > > > > and PPC ASA simultaneously and pipes data both ways! I was
in
> > the
> > > > same
> > > > > > > > quandary as you currently, as the MobiLink solution was
> elegant
> > > but
> > > > > way
> > > > > > > too
> > > > > > > > costly to charge to the client to make my application cost
> > > > effective.
> > > > > > > >
> > > > > > > > So a home grown solution may not be that bad. Anyway ...
food
> > for
> > > > > > thought.
> > > > > > > >
> > > > > > > > regards ... Chris
> > > > > > > > Great White North Technical Evangelist
> > > > > > > >
> > > > > > > >
> > > > > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > > > > news:3f661c53$1@forums-2-dub...
> > > > > > > > > I have been trying the Pocket Powerbuilder 1.0 Evaluation
> and
> > > has
> > > > > > > > successfully
> > > > > > > > > created a simple application. Our consolidated database is
> > > ORACLE
> > > > > and
> > > > > > I
> > > > > > > > > understand we have to run a SQL to create the ML_* tables
> for
> > > the
> > > > > > > Mobilink
> > > > > > > > > synchronization process. Moreover, we have to purchase a
> > license
> > > > in
> > > > > > > > deploying
> > > > > > > > > these components of Pocket Powerbuilder i.e. Mobilink and
> SQL
> > > > Remote
> > > > > > > > > Synchronization technologies and Sybase Central
> Administration
> > > > tool.
> > > > > > > Now,
> > > > > > > > that
> > > > > > > > > turns me off (sorry..).
> > > > > > > > >
> > > > > > > > > My question: Is there any other way to synchronize with
the
> > > > > > consolidated
> > > > > > > > Oracle
> > > > > > > > > database without using the Mobilink synchronization
> technique?
> > I
> > > > > knew
> > > > > > we
> > > > > > > > can
> > > > > > > > > write a Powerbuilder application to read an ASA local
> database
> > > but
> > > > > > again
> > > > > > > > it's
> > > > > > > > > not royalty free since we will be deploying that database
> off
> > > the
> > > > > > Pocket
> > > > > > > > PC
> > > > > > > > > 2002. Can we use the SaveAs function to create a text or
> Excel
> > > or
> > > > > DBF
> > > > > > > file
> > > > > > > > on
> > > > > > > > > Pocket PC 2002 then ActiveSync to transfer to local PC and
> > then
> > > > > > > manipulate
> > > > > > > > or
> > > > > > > > > use it within Powerbuilder application to update
> Consolidated
> > > > Oracle
> > > > > > > > database?
> > > > > > > > >
> > > > > > > > > Your input is greatly appreciated.
> > > > > > > > >
> > > > > > > > > Thanks,
> > > > > > > > > Jun
> > > > > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-25 11:11:44.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub> <3f71b126$1@forums-1-dub> <3f71b4b8@forums-2-dub> <3f71cb3e$1@forums-1-dub> <3f726227@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 417
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: www.scc-csc.gc.ca
Message-ID: <3f72ce0a$1@forums-2-dub>
X-Original-Trace: 25 Sep 2003 04:14:18 -0700, www.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Sep 2003 04:07:26 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Sep 2003 04:11:44 -0700
X-Trace: forums-1-dub 1064488304 10.22.108.75 (25 Sep 2003 04:11:44 -0700)
X-Original-Trace: 25 Sep 2003 04:11:44 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:576
Article PK: 267110

If your DB on the PDA is holding a copy (sub-set) of your corporate
data, you have to be able to load it and keep it up to date. The PDA PPB
application is not updating a corporate server, just a copy of "your" data.
This does NOT require a license!

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f726227@forums-2-dub...
> you would load it with your program. If data is sync'ed to the db or
sync'ed
> from it you must license the database.
>
> If Sybase didn't make users license the database how would they make
> money??????
> Come on really!
>
> My point is the argument can sounds dumb either direction. MS SQL CE is
the
> same way. If the data is used off the device it must be licensed. The
> runtime engine is a stand-alone database for a stand-alone application.
>
> Adaptive Server Anywhere is a great database. Its very inexpensive, small
> foot-print, scalable... that's way companies purchase licenses of this
great
> DB.
>
> My guess is if Sybase create drivers to connect directly to other
databases
> they will become part of ASA product. Just my .02.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f71cb3e$1@forums-1-dub...
> > Dean;
> >
> > So how do you load the database???????
> > Come one really!
> >
> > Chris
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f71b4b8@forums-2-dub...
> > > Here is the answer from Sybase.
> > >
> > > >>
> > > Both accessing and sending are prohibited. This is a stipulation of
the
> > > licensing for the runtime. No replication by any means.
> > >
> > > <<
> > >
> > > Here is the ReadMe. This is a list of restrictions. The No remote
data
> > > access is the only one that is confussing. Does it mean you cannot
> access
> > > data on a remote server or send data to a remote server. I just talked
> > with
> > > iAnywhere and the answer stated above. No replication by any means or
> you
> > > must license the software. Again I'm stating what I'm told from
> iAnywhere
> > > and information I'm reading in the ASA runtime engine files.
> > >
> > >
> > >
> > > The major restrictions for the Desktop Runtime Edition are as follows:
> > >
> > > ¨ No transaction log The Desktop Runtime Edition does not use a
> > >
> > > transaction log. Consequently, it cannot take part in a replication or
> > >
> > > synchronization environment.
> > >
> > > ¨ No data definition You cannot create or alter database objects such
as
> > >
> > > stored procedures, tables, and indexes.
> > >
> > > ¨ No stored procedures, events, or triggers The Desktop Runtime
> > >
> > > Edition does not support the use of stored procedures, events, or
> > triggers.
> > >
> > > Consequently, procedure profiling is not available.
> > >
> > > ¨ No events or schedules The Desktop Runtime Edition does not
> > >
> > > support events or scheduling of events.
> > >
> > > ¨ No defragmentation support You cannot query the database for
> > >
> > > fragmentation, nor can you issue defragmentation commands.
> > >
> > > ¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition
> > >
> > > does not support transactions involved with Distributed Transaction
> > >
> > > Coordination.
> > >
> > > ¨ No support for SMP-capable machines The Desktop Runtime Edition
> > >
> > > does not support multi-processor machines.
> > >
> > > No Java The Java-in-the-database features are not available in the
> > >
> > > Desktop Runtime Edition.
> > >
> > > ¨ No remote data access You cannot access data on remote servers
> > >
> > > using the Desktop Runtime Edition.
> > >
> > > ¨ No jConnect access You can access the Desktop Runtime Edition
> > >
> > > from JDBC using the iAnywhere JDBC driver, but not using the Sybase
> > >
> > > jConnect JDBC driver.
> > >
> > > ¨ No database file encryption The Desktop Runtime Edition does not
> > >
> > > support database file encryption.
> > >
> > > ¨ No communication encryption You cannot encrypt client/server
> > >
> > > communications using the Desktop Runtime Edition.
> > >
> > > ¨ No web services The Desktop Runtime Edition does not support web
> > >
> > > services, including HTTP server and SOAP.
> > >
> > >
> > >
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > news:3f71b126$1@forums-1-dub...
> > > > No, that is for Mobilink. You are free to Export/Import data from
> where
> > > > ever. The only run time ASA engine restriction is you can not
perform
> > DDL
> > > > and no SP's!
> > > >
> > > >
> > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > > message
> > > > news:3f719f11$1@forums-1-dub...
> > > > > I have been on the phone with Sybase on this issue a lot lately.
The
> > > > version
> > > > > of ASA that can be distributed is not license to sync data back to
> any
> > > > > database. If you sync data you must license the database for each
> > > install.
> > > > > About $120 per client. My company is a iAnywhere partner and I
have
> > > > research
> > > > > this. I would not tell developers they can do this without
approval
> > from
> > > > > Sybase/iAnywhere.
> > > > >
> > > > > I am referring to the Desktop Runtime Edition. The one that you
can
> > > > > distribute with your applications. I will follow up with this some
> > more,
> > > > but
> > > > > I have been sent several documents and so far they all save the
data
> > > from
> > > > > the desktop runtime edition cannot assess data from remote
database
> > and
> > > > > cannot sync data with a remote database.
> > > > >
> > > > > I will get on the phone again and see if I can get someone from
> Sybase
> > > to
> > > > > clarify this issue.
> > > > >
> > > > > --
> > > > > Dean Jones [TeamSybase]
> > > > > CEO
> > > > > PowerObjects
> > > > > http://www.powerobjects.com
> > > > > (612) 339-3355 ext 112
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > news:3f7177c2$1@forums-2-dub...
> > > > > > NO, not from PowerBuilder (cradled PC).
> > > > > >
> > > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
wrote
> in
> > > > > message
> > > > > > news:3f70aabd$1@forums-2-dub...
> > > > > > > If you sync databases you must license ASA. If you only run
the
> > > > desktop
> > > > > > > version you can deploy without licensing. Basically its just
> like
> > MS
> > > > SQL
> > > > > > CE.
> > > > > > > If the data is used off of the hand held device in any way by
> any
> > > > means
> > > > > > you
> > > > > > > must license the ASA database.
> > > > > > >
> > > > > > > --
> > > > > > > Dean Jones [TeamSybase]
> > > > > > > CEO
> > > > > > > PowerObjects
> > > > > > > http://www.powerobjects.com
> > > > > > > (612) 339-3355 ext 112
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > > > news:3f6f4cad$1@forums-1-dub...
> > > > > > > > I noticed your post on the news groups, I am hoping I can
> follow
> > > up
> > > > > with
> > > > > > > >
> > > > > > > > You a bit. We are attempting to move data as follows.
> > > > > > > >
> > > > > > > > Case 1:
> > > > > > > >
> > > > > > > > ---------------------------------------------
> > > > > > > >
> > > > > > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > > > > > >
> > > > > > > > We have this working. But we are stuck on the
> > > > > > > >
> > > > > > > > Fact an ASA 8 engine has to be running on
> > > > > > > >
> > > > > > > > The desktop before the pocket PC will connect
> > > > > > > >
> > > > > > > > To it.
> > > > > > > >
> > > > > > > > Case 2:
> > > > > > > >
> > > > > > > > ---------------------------------------------
> > > > > > > >
> > > > > > > > Just to clarify, are you saying that you can
> > > > > > > >
> > > > > > > > Use pb9/pipelines to connect between a database
> > > > > > > >
> > > > > > > > On a server, and move data between the pocketPC
> > > > > > > >
> > > > > > > > Database and the server ? Probably sounds like
> > > > > > > >
> > > > > > > > A silly question but...
> > > > > > > >
> > > > > > > > Thanks in advance
> > > > > > > >
> > > > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > > > news:3f67246f$1@forums-1-dub...
> > > > > > > > > Jun;
> > > > > > > > >
> > > > > > > > > I developed my own "Sync" utility using PB 9 and
Pipelines.
> > It
> > > > took
> > > > > > me
> > > > > > > > > about a day to program and another day to unit test. It is
> now
> > > in
> > > > > > > > production
> > > > > > > > > and rock solid. The utility (runs on the PC) connects to
the
> > > > > corporate
> > > > > > > DB
> > > > > > > > > and PPC ASA simultaneously and pipes data both ways! I was
> in
> > > the
> > > > > same
> > > > > > > > > quandary as you currently, as the MobiLink solution was
> > elegant
> > > > but
> > > > > > way
> > > > > > > > too
> > > > > > > > > costly to charge to the client to make my application cost
> > > > > effective.
> > > > > > > > >
> > > > > > > > > So a home grown solution may not be that bad. Anyway ...
> food
> > > for
> > > > > > > thought.
> > > > > > > > >
> > > > > > > > > regards ... Chris
> > > > > > > > > Great White North Technical Evangelist
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > > > > > news:3f661c53$1@forums-2-dub...
> > > > > > > > > > I have been trying the Pocket Powerbuilder 1.0
Evaluation
> > and
> > > > has
> > > > > > > > > successfully
> > > > > > > > > > created a simple application. Our consolidated database
is
> > > > ORACLE
> > > > > > and
> > > > > > > I
> > > > > > > > > > understand we have to run a SQL to create the ML_*
tables
> > for
> > > > the
> > > > > > > > Mobilink
> > > > > > > > > > synchronization process. Moreover, we have to purchase a
> > > license
> > > > > in
> > > > > > > > > deploying
> > > > > > > > > > these components of Pocket Powerbuilder i.e. Mobilink
and
> > SQL
> > > > > Remote
> > > > > > > > > > Synchronization technologies and Sybase Central
> > Administration
> > > > > tool.
> > > > > > > > Now,
> > > > > > > > > that
> > > > > > > > > > turns me off (sorry..).
> > > > > > > > > >
> > > > > > > > > > My question: Is there any other way to synchronize with
> the
> > > > > > > consolidated
> > > > > > > > > Oracle
> > > > > > > > > > database without using the Mobilink synchronization
> > technique?
> > > I
> > > > > > knew
> > > > > > > we
> > > > > > > > > can
> > > > > > > > > > write a Powerbuilder application to read an ASA local
> > database
> > > > but
> > > > > > > again
> > > > > > > > > it's
> > > > > > > > > > not royalty free since we will be deploying that
database
> > off
> > > > the
> > > > > > > Pocket
> > > > > > > > > PC
> > > > > > > > > > 2002. Can we use the SaveAs function to create a text or
> > Excel
> > > > or
> > > > > > DBF
> > > > > > > > file
> > > > > > > > > on
> > > > > > > > > > Pocket PC 2002 then ActiveSync to transfer to local PC
and
> > > then
> > > > > > > > manipulate
> > > > > > > > > or
> > > > > > > > > > use it within Powerbuilder application to update
> > Consolidated
> > > > > Oracle
> > > > > > > > > database?
> > > > > > > > > >
> > > > > > > > > > Your input is greatly appreciated.
> > > > > > > > > >
> > > > > > > > > > Thanks,
> > > > > > > > > > Jun
> > > > > > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-09-25 13:51:13.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub> <3f71b126$1@forums-1-dub> <3f71b4b8@forums-2-dub> <3f71cb3e$1@forums-1-dub> <3f726227@forums-2-dub> <3f72ce0a$1@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 455
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 216.207.144.172
X-Original-NNTP-Posting-Host: 216.207.144.172
Message-ID: <3f72f2d1$1@forums-1-dub>
Date: 25 Sep 2003 06:51:13 -0700
X-Trace: forums-1-dub 1064497873 216.207.144.172 (25 Sep 2003 06:51:13 -0700)
X-Original-Trace: 25 Sep 2003 06:51:13 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:580
Article PK: 267114

Who told you this does not require a license? Someone from Sybase or
iAnywhere?

--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f72ce0a$1@forums-2-dub...
> If your DB on the PDA is holding a copy (sub-set) of your corporate
> data, you have to be able to load it and keep it up to date. The PDA PPB
> application is not updating a corporate server, just a copy of "your"
data.
> This does NOT require a license!
>
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f726227@forums-2-dub...
> > you would load it with your program. If data is sync'ed to the db or
> sync'ed
> > from it you must license the database.
> >
> > If Sybase didn't make users license the database how would they make
> > money??????
> > Come on really!
> >
> > My point is the argument can sounds dumb either direction. MS SQL CE is
> the
> > same way. If the data is used off the device it must be licensed. The
> > runtime engine is a stand-alone database for a stand-alone application.
> >
> > Adaptive Server Anywhere is a great database. Its very inexpensive,
small
> > foot-print, scalable... that's way companies purchase licenses of this
> great
> > DB.
> >
> > My guess is if Sybase create drivers to connect directly to other
> databases
> > they will become part of ASA product. Just my .02.
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > news:3f71cb3e$1@forums-1-dub...
> > > Dean;
> > >
> > > So how do you load the database???????
> > > Come one really!
> > >
> > > Chris
> > >
> > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > message
> > > news:3f71b4b8@forums-2-dub...
> > > > Here is the answer from Sybase.
> > > >
> > > > >>
> > > > Both accessing and sending are prohibited. This is a stipulation of
> the
> > > > licensing for the runtime. No replication by any means.
> > > >
> > > > <<
> > > >
> > > > Here is the ReadMe. This is a list of restrictions. The No remote
> data
> > > > access is the only one that is confussing. Does it mean you cannot
> > access
> > > > data on a remote server or send data to a remote server. I just
talked
> > > with
> > > > iAnywhere and the answer stated above. No replication by any means
or
> > you
> > > > must license the software. Again I'm stating what I'm told from
> > iAnywhere
> > > > and information I'm reading in the ASA runtime engine files.
> > > >
> > > >
> > > >
> > > > The major restrictions for the Desktop Runtime Edition are as
follows:
> > > >
> > > > ¨ No transaction log The Desktop Runtime Edition does not use a
> > > >
> > > > transaction log. Consequently, it cannot take part in a replication
or
> > > >
> > > > synchronization environment.
> > > >
> > > > ¨ No data definition You cannot create or alter database objects
such
> as
> > > >
> > > > stored procedures, tables, and indexes.
> > > >
> > > > ¨ No stored procedures, events, or triggers The Desktop Runtime
> > > >
> > > > Edition does not support the use of stored procedures, events, or
> > > triggers.
> > > >
> > > > Consequently, procedure profiling is not available.
> > > >
> > > > ¨ No events or schedules The Desktop Runtime Edition does not
> > > >
> > > > support events or scheduling of events.
> > > >
> > > > ¨ No defragmentation support You cannot query the database for
> > > >
> > > > fragmentation, nor can you issue defragmentation commands.
> > > >
> > > > ¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition
> > > >
> > > > does not support transactions involved with Distributed Transaction
> > > >
> > > > Coordination.
> > > >
> > > > ¨ No support for SMP-capable machines The Desktop Runtime Edition
> > > >
> > > > does not support multi-processor machines.
> > > >
> > > > No Java The Java-in-the-database features are not available in the
> > > >
> > > > Desktop Runtime Edition.
> > > >
> > > > ¨ No remote data access You cannot access data on remote servers
> > > >
> > > > using the Desktop Runtime Edition.
> > > >
> > > > ¨ No jConnect access You can access the Desktop Runtime Edition
> > > >
> > > > from JDBC using the iAnywhere JDBC driver, but not using the Sybase
> > > >
> > > > jConnect JDBC driver.
> > > >
> > > > ¨ No database file encryption The Desktop Runtime Edition does not
> > > >
> > > > support database file encryption.
> > > >
> > > > ¨ No communication encryption You cannot encrypt client/server
> > > >
> > > > communications using the Desktop Runtime Edition.
> > > >
> > > > ¨ No web services The Desktop Runtime Edition does not support web
> > > >
> > > > services, including HTTP server and SOAP.
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Dean Jones [TeamSybase]
> > > > CEO
> > > > PowerObjects
> > > > http://www.powerobjects.com
> > > > (612) 339-3355 ext 112
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > news:3f71b126$1@forums-1-dub...
> > > > > No, that is for Mobilink. You are free to Export/Import data from
> > where
> > > > > ever. The only run time ASA engine restriction is you can not
> perform
> > > DDL
> > > > > and no SP's!
> > > > >
> > > > >
> > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote
in
> > > > message
> > > > > news:3f719f11$1@forums-1-dub...
> > > > > > I have been on the phone with Sybase on this issue a lot lately.
> The
> > > > > version
> > > > > > of ASA that can be distributed is not license to sync data back
to
> > any
> > > > > > database. If you sync data you must license the database for
each
> > > > install.
> > > > > > About $120 per client. My company is a iAnywhere partner and I
> have
> > > > > research
> > > > > > this. I would not tell developers they can do this without
> approval
> > > from
> > > > > > Sybase/iAnywhere.
> > > > > >
> > > > > > I am referring to the Desktop Runtime Edition. The one that you
> can
> > > > > > distribute with your applications. I will follow up with this
some
> > > more,
> > > > > but
> > > > > > I have been sent several documents and so far they all save the
> data
> > > > from
> > > > > > the desktop runtime edition cannot assess data from remote
> database
> > > and
> > > > > > cannot sync data with a remote database.
> > > > > >
> > > > > > I will get on the phone again and see if I can get someone from
> > Sybase
> > > > to
> > > > > > clarify this issue.
> > > > > >
> > > > > > --
> > > > > > Dean Jones [TeamSybase]
> > > > > > CEO
> > > > > > PowerObjects
> > > > > > http://www.powerobjects.com
> > > > > > (612) 339-3355 ext 112
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > news:3f7177c2$1@forums-2-dub...
> > > > > > > NO, not from PowerBuilder (cradled PC).
> > > > > > >
> > > > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
> wrote
> > in
> > > > > > message
> > > > > > > news:3f70aabd$1@forums-2-dub...
> > > > > > > > If you sync databases you must license ASA. If you only run
> the
> > > > > desktop
> > > > > > > > version you can deploy without licensing. Basically its just
> > like
> > > MS
> > > > > SQL
> > > > > > > CE.
> > > > > > > > If the data is used off of the hand held device in any way
by
> > any
> > > > > means
> > > > > > > you
> > > > > > > > must license the ASA database.
> > > > > > > >
> > > > > > > > --
> > > > > > > > Dean Jones [TeamSybase]
> > > > > > > > CEO
> > > > > > > > PowerObjects
> > > > > > > > http://www.powerobjects.com
> > > > > > > > (612) 339-3355 ext 112
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > > > > news:3f6f4cad$1@forums-1-dub...
> > > > > > > > > I noticed your post on the news groups, I am hoping I can
> > follow
> > > > up
> > > > > > with
> > > > > > > > >
> > > > > > > > > You a bit. We are attempting to move data as follows.
> > > > > > > > >
> > > > > > > > > Case 1:
> > > > > > > > >
> > > > > > > > > ---------------------------------------------
> > > > > > > > >
> > > > > > > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > > > > > > >
> > > > > > > > > We have this working. But we are stuck on the
> > > > > > > > >
> > > > > > > > > Fact an ASA 8 engine has to be running on
> > > > > > > > >
> > > > > > > > > The desktop before the pocket PC will connect
> > > > > > > > >
> > > > > > > > > To it.
> > > > > > > > >
> > > > > > > > > Case 2:
> > > > > > > > >
> > > > > > > > > ---------------------------------------------
> > > > > > > > >
> > > > > > > > > Just to clarify, are you saying that you can
> > > > > > > > >
> > > > > > > > > Use pb9/pipelines to connect between a database
> > > > > > > > >
> > > > > > > > > On a server, and move data between the pocketPC
> > > > > > > > >
> > > > > > > > > Database and the server ? Probably sounds like
> > > > > > > > >
> > > > > > > > > A silly question but...
> > > > > > > > >
> > > > > > > > > Thanks in advance
> > > > > > > > >
> > > > > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > > > > news:3f67246f$1@forums-1-dub...
> > > > > > > > > > Jun;
> > > > > > > > > >
> > > > > > > > > > I developed my own "Sync" utility using PB 9 and
> Pipelines.
> > > It
> > > > > took
> > > > > > > me
> > > > > > > > > > about a day to program and another day to unit test. It
is
> > now
> > > > in
> > > > > > > > > production
> > > > > > > > > > and rock solid. The utility (runs on the PC) connects to
> the
> > > > > > corporate
> > > > > > > > DB
> > > > > > > > > > and PPC ASA simultaneously and pipes data both ways! I
was
> > in
> > > > the
> > > > > > same
> > > > > > > > > > quandary as you currently, as the MobiLink solution was
> > > elegant
> > > > > but
> > > > > > > way
> > > > > > > > > too
> > > > > > > > > > costly to charge to the client to make my application
cost
> > > > > > effective.
> > > > > > > > > >
> > > > > > > > > > So a home grown solution may not be that bad. Anyway ...
> > food
> > > > for
> > > > > > > > thought.
> > > > > > > > > >
> > > > > > > > > > regards ... Chris
> > > > > > > > > > Great White North Technical Evangelist
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > > > > > > news:3f661c53$1@forums-2-dub...
> > > > > > > > > > > I have been trying the Pocket Powerbuilder 1.0
> Evaluation
> > > and
> > > > > has
> > > > > > > > > > successfully
> > > > > > > > > > > created a simple application. Our consolidated
database
> is
> > > > > ORACLE
> > > > > > > and
> > > > > > > > I
> > > > > > > > > > > understand we have to run a SQL to create the ML_*
> tables
> > > for
> > > > > the
> > > > > > > > > Mobilink
> > > > > > > > > > > synchronization process. Moreover, we have to purchase
a
> > > > license
> > > > > > in
> > > > > > > > > > deploying
> > > > > > > > > > > these components of Pocket Powerbuilder i.e. Mobilink
> and
> > > SQL
> > > > > > Remote
> > > > > > > > > > > Synchronization technologies and Sybase Central
> > > Administration
> > > > > > tool.
> > > > > > > > > Now,
> > > > > > > > > > that
> > > > > > > > > > > turns me off (sorry..).
> > > > > > > > > > >
> > > > > > > > > > > My question: Is there any other way to synchronize
with
> > the
> > > > > > > > consolidated
> > > > > > > > > > Oracle
> > > > > > > > > > > database without using the Mobilink synchronization
> > > technique?
> > > > I
> > > > > > > knew
> > > > > > > > we
> > > > > > > > > > can
> > > > > > > > > > > write a Powerbuilder application to read an ASA local
> > > database
> > > > > but
> > > > > > > > again
> > > > > > > > > > it's
> > > > > > > > > > > not royalty free since we will be deploying that
> database
> > > off
> > > > > the
> > > > > > > > Pocket
> > > > > > > > > > PC
> > > > > > > > > > > 2002. Can we use the SaveAs function to create a text
or
> > > Excel
> > > > > or
> > > > > > > DBF
> > > > > > > > > file
> > > > > > > > > > on
> > > > > > > > > > > Pocket PC 2002 then ActiveSync to transfer to local PC
> and
> > > > then
> > > > > > > > > manipulate
> > > > > > > > > > or
> > > > > > > > > > > use it within Powerbuilder application to update
> > > Consolidated
> > > > > > Oracle
> > > > > > > > > > database?
> > > > > > > > > > >
> > > > > > > > > > > Your input is greatly appreciated.
> > > > > > > > > > >
> > > > > > > > > > > Thanks,
> > > > > > > > > > > Jun
> > > > > > > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-25 11:29:13.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub> <3f71b126$1@forums-1-dub> <3f71b4b8@forums-2-dub> <3f71cb3e$1@forums-1-dub> <3f726227@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 482
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: listserv.scc-csc.gc.ca
Message-ID: <3f72d222$1@forums-2-dub>
X-Original-Trace: 25 Sep 2003 04:31:46 -0700, listserv.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Sep 2003 04:24:55 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Sep 2003 04:29:13 -0700
X-Trace: forums-1-dub 1064489353 10.22.108.75 (25 Sep 2003 04:29:13 -0700)
X-Original-Trace: 25 Sep 2003 04:29:13 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:577
Article PK: 267111

Dean;

Ok here is the official scoop from my Sybase contacts:
First of all here at the RT restrictions for the royalty free ASA
version.....
Restriction summary

The major restrictions for the Adaptive Server Anywhere for Windows CE

Royalty-Free Runtime Edition are as follows:

¨ No transaction log The Adaptive Server Anywhere for Windows CE

Royalty-Free Runtime Edition does not use a transaction log.

Consequently, it cannot take part in a replication environment.

¨ No data definition You cannot create or alter database objects such as

stored procedures, tables, and indexes.

¨ No stored procedures, events, or triggers The Adaptive Server

Anywhere for Windows CE Royalty-Free Runtime Edition does not

support the use of stored procedures, events, or triggers. Consequently,

procedure profiling is not available.

¨ No events or schedules The Adaptive Server Anywhere for Windows

CE Royalty-Free Runtime Edition does not support events or scheduling

of events.

¨ No defragmentation support You cannot query the database for

fragmentation, nor can you issue defragmentation commands.

¨ No Java The Java-in-the-database features are not available in the

Adaptive Server Anywhere for Windows CE Royalty-Free Runtime

Edition.

¨ No remote data access You cannot access data on remote servers

using the Adaptive Server Anywhere for Windows CE Royalty-Free

Runtime Edition.

¨ No database file encryption The Adaptive Server Anywhere for

Windows CE Royalty-Free Runtime Edition does not support database

file encryption.


The Key clause above is "no remote data access". This means from within an
ASA database to any other! For example, you could use "replication"
(ASA=>ASA) services or, write an ASA - Trigger, SP, Function, etc that
updates a "remote" table. The main theme is accessing remote data from
"WITHIN ASA". This has nothing to do with how you manipulate the data
outside of ASA (i.e.: SQL script files, VB, PB, Delphi, Java, etc).

So please do not confuse the PPB developers with what you can or can not do
with ASA from PB or PPB vs. "within ASA".

Thanks ... Chris

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f726227@forums-2-dub...
> you would load it with your program. If data is sync'ed to the db or
sync'ed
> from it you must license the database.
>
> If Sybase didn't make users license the database how would they make
> money??????
> Come on really!
>
> My point is the argument can sounds dumb either direction. MS SQL CE is
the
> same way. If the data is used off the device it must be licensed. The
> runtime engine is a stand-alone database for a stand-alone application.
>
> Adaptive Server Anywhere is a great database. Its very inexpensive, small
> foot-print, scalable... that's way companies purchase licenses of this
great
> DB.
>
> My guess is if Sybase create drivers to connect directly to other
databases
> they will become part of ASA product. Just my .02.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f71cb3e$1@forums-1-dub...
> > Dean;
> >
> > So how do you load the database???????
> > Come one really!
> >
> > Chris
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f71b4b8@forums-2-dub...
> > > Here is the answer from Sybase.
> > >
> > > >>
> > > Both accessing and sending are prohibited. This is a stipulation of
the
> > > licensing for the runtime. No replication by any means.
> > >
> > > <<
> > >
> > > Here is the ReadMe. This is a list of restrictions. The No remote
data
> > > access is the only one that is confussing. Does it mean you cannot
> access
> > > data on a remote server or send data to a remote server. I just talked
> > with
> > > iAnywhere and the answer stated above. No replication by any means or
> you
> > > must license the software. Again I'm stating what I'm told from
> iAnywhere
> > > and information I'm reading in the ASA runtime engine files.
> > >
> > >
> > >
> > > The major restrictions for the Desktop Runtime Edition are as follows:
> > >
> > > ¨ No transaction log The Desktop Runtime Edition does not use a
> > >
> > > transaction log. Consequently, it cannot take part in a replication or
> > >
> > > synchronization environment.
> > >
> > > ¨ No data definition You cannot create or alter database objects such
as
> > >
> > > stored procedures, tables, and indexes.
> > >
> > > ¨ No stored procedures, events, or triggers The Desktop Runtime
> > >
> > > Edition does not support the use of stored procedures, events, or
> > triggers.
> > >
> > > Consequently, procedure profiling is not available.
> > >
> > > ¨ No events or schedules The Desktop Runtime Edition does not
> > >
> > > support events or scheduling of events.
> > >
> > > ¨ No defragmentation support You cannot query the database for
> > >
> > > fragmentation, nor can you issue defragmentation commands.
> > >
> > > ¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition
> > >
> > > does not support transactions involved with Distributed Transaction
> > >
> > > Coordination.
> > >
> > > ¨ No support for SMP-capable machines The Desktop Runtime Edition
> > >
> > > does not support multi-processor machines.
> > >
> > > No Java The Java-in-the-database features are not available in the
> > >
> > > Desktop Runtime Edition.
> > >
> > > ¨ No remote data access You cannot access data on remote servers
> > >
> > > using the Desktop Runtime Edition.
> > >
> > > ¨ No jConnect access You can access the Desktop Runtime Edition
> > >
> > > from JDBC using the iAnywhere JDBC driver, but not using the Sybase
> > >
> > > jConnect JDBC driver.
> > >
> > > ¨ No database file encryption The Desktop Runtime Edition does not
> > >
> > > support database file encryption.
> > >
> > > ¨ No communication encryption You cannot encrypt client/server
> > >
> > > communications using the Desktop Runtime Edition.
> > >
> > > ¨ No web services The Desktop Runtime Edition does not support web
> > >
> > > services, including HTTP server and SOAP.
> > >
> > >
> > >
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > news:3f71b126$1@forums-1-dub...
> > > > No, that is for Mobilink. You are free to Export/Import data from
> where
> > > > ever. The only run time ASA engine restriction is you can not
perform
> > DDL
> > > > and no SP's!
> > > >
> > > >
> > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > > message
> > > > news:3f719f11$1@forums-1-dub...
> > > > > I have been on the phone with Sybase on this issue a lot lately.
The
> > > > version
> > > > > of ASA that can be distributed is not license to sync data back to
> any
> > > > > database. If you sync data you must license the database for each
> > > install.
> > > > > About $120 per client. My company is a iAnywhere partner and I
have
> > > > research
> > > > > this. I would not tell developers they can do this without
approval
> > from
> > > > > Sybase/iAnywhere.
> > > > >
> > > > > I am referring to the Desktop Runtime Edition. The one that you
can
> > > > > distribute with your applications. I will follow up with this some
> > more,
> > > > but
> > > > > I have been sent several documents and so far they all save the
data
> > > from
> > > > > the desktop runtime edition cannot assess data from remote
database
> > and
> > > > > cannot sync data with a remote database.
> > > > >
> > > > > I will get on the phone again and see if I can get someone from
> Sybase
> > > to
> > > > > clarify this issue.
> > > > >
> > > > > --
> > > > > Dean Jones [TeamSybase]
> > > > > CEO
> > > > > PowerObjects
> > > > > http://www.powerobjects.com
> > > > > (612) 339-3355 ext 112
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > news:3f7177c2$1@forums-2-dub...
> > > > > > NO, not from PowerBuilder (cradled PC).
> > > > > >
> > > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
wrote
> in
> > > > > message
> > > > > > news:3f70aabd$1@forums-2-dub...
> > > > > > > If you sync databases you must license ASA. If you only run
the
> > > > desktop
> > > > > > > version you can deploy without licensing. Basically its just
> like
> > MS
> > > > SQL
> > > > > > CE.
> > > > > > > If the data is used off of the hand held device in any way by
> any
> > > > means
> > > > > > you
> > > > > > > must license the ASA database.
> > > > > > >
> > > > > > > --
> > > > > > > Dean Jones [TeamSybase]
> > > > > > > CEO
> > > > > > > PowerObjects
> > > > > > > http://www.powerobjects.com
> > > > > > > (612) 339-3355 ext 112
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > > > news:3f6f4cad$1@forums-1-dub...
> > > > > > > > I noticed your post on the news groups, I am hoping I can
> follow
> > > up
> > > > > with
> > > > > > > >
> > > > > > > > You a bit. We are attempting to move data as follows.
> > > > > > > >
> > > > > > > > Case 1:
> > > > > > > >
> > > > > > > > ---------------------------------------------
> > > > > > > >
> > > > > > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > > > > > >
> > > > > > > > We have this working. But we are stuck on the
> > > > > > > >
> > > > > > > > Fact an ASA 8 engine has to be running on
> > > > > > > >
> > > > > > > > The desktop before the pocket PC will connect
> > > > > > > >
> > > > > > > > To it.
> > > > > > > >
> > > > > > > > Case 2:
> > > > > > > >
> > > > > > > > ---------------------------------------------
> > > > > > > >
> > > > > > > > Just to clarify, are you saying that you can
> > > > > > > >
> > > > > > > > Use pb9/pipelines to connect between a database
> > > > > > > >
> > > > > > > > On a server, and move data between the pocketPC
> > > > > > > >
> > > > > > > > Database and the server ? Probably sounds like
> > > > > > > >
> > > > > > > > A silly question but...
> > > > > > > >
> > > > > > > > Thanks in advance
> > > > > > > >
> > > > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > > > news:3f67246f$1@forums-1-dub...
> > > > > > > > > Jun;
> > > > > > > > >
> > > > > > > > > I developed my own "Sync" utility using PB 9 and
Pipelines.
> > It
> > > > took
> > > > > > me
> > > > > > > > > about a day to program and another day to unit test. It is
> now
> > > in
> > > > > > > > production
> > > > > > > > > and rock solid. The utility (runs on the PC) connects to
the
> > > > > corporate
> > > > > > > DB
> > > > > > > > > and PPC ASA simultaneously and pipes data both ways! I was
> in
> > > the
> > > > > same
> > > > > > > > > quandary as you currently, as the MobiLink solution was
> > elegant
> > > > but
> > > > > > way
> > > > > > > > too
> > > > > > > > > costly to charge to the client to make my application cost
> > > > > effective.
> > > > > > > > >
> > > > > > > > > So a home grown solution may not be that bad. Anyway ...
> food
> > > for
> > > > > > > thought.
> > > > > > > > >
> > > > > > > > > regards ... Chris
> > > > > > > > > Great White North Technical Evangelist
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > > > > > news:3f661c53$1@forums-2-dub...
> > > > > > > > > > I have been trying the Pocket Powerbuilder 1.0
Evaluation
> > and
> > > > has
> > > > > > > > > successfully
> > > > > > > > > > created a simple application. Our consolidated database
is
> > > > ORACLE
> > > > > > and
> > > > > > > I
> > > > > > > > > > understand we have to run a SQL to create the ML_*
tables
> > for
> > > > the
> > > > > > > > Mobilink
> > > > > > > > > > synchronization process. Moreover, we have to purchase a
> > > license
> > > > > in
> > > > > > > > > deploying
> > > > > > > > > > these components of Pocket Powerbuilder i.e. Mobilink
and
> > SQL
> > > > > Remote
> > > > > > > > > > Synchronization technologies and Sybase Central
> > Administration
> > > > > tool.
> > > > > > > > Now,
> > > > > > > > > that
> > > > > > > > > > turns me off (sorry..).
> > > > > > > > > >
> > > > > > > > > > My question: Is there any other way to synchronize with
> the
> > > > > > > consolidated
> > > > > > > > > Oracle
> > > > > > > > > > database without using the Mobilink synchronization
> > technique?
> > > I
> > > > > > knew
> > > > > > > we
> > > > > > > > > can
> > > > > > > > > > write a Powerbuilder application to read an ASA local
> > database
> > > > but
> > > > > > > again
> > > > > > > > > it's
> > > > > > > > > > not royalty free since we will be deploying that
database
> > off
> > > > the
> > > > > > > Pocket
> > > > > > > > > PC
> > > > > > > > > > 2002. Can we use the SaveAs function to create a text or
> > Excel
> > > > or
> > > > > > DBF
> > > > > > > > file
> > > > > > > > > on
> > > > > > > > > > Pocket PC 2002 then ActiveSync to transfer to local PC
and
> > > then
> > > > > > > > manipulate
> > > > > > > > > or
> > > > > > > > > > use it within Powerbuilder application to update
> > Consolidated
> > > > > Oracle
> > > > > > > > > database?
> > > > > > > > > >
> > > > > > > > > > Your input is greatly appreciated.
> > > > > > > > > >
> > > > > > > > > > Thanks,
> > > > > > > > > > Jun
> > > > > > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-09-25 14:17:43.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub> <3f71b126$1@forums-1-dub> <3f71b4b8@forums-2-dub> <3f71cb3e$1@forums-1-dub> <3f726227@forums-2-dub> <3f72d222$1@forums-2-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 542
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 216.207.144.172
X-Original-NNTP-Posting-Host: 216.207.144.172
Message-ID: <3f72f907@forums-1-dub>
Date: 25 Sep 2003 07:17:43 -0700
X-Trace: forums-1-dub 1064499463 216.207.144.172 (25 Sep 2003 07:17:43 -0700)
X-Original-Trace: 25 Sep 2003 07:17:43 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:583
Article PK: 267119

Chris -

I have asked Sybase to post an answer to this issue. What you have just
posted here is exactly what I have posted twice now. After the facts it
appears you have stated your opinion or interpretation of the facts.

My company sells Sybase and iAnywhere software, and work with Sybase and
iAnywhere to understand how the software must be licensed everyday. Your
interpretations of the license appears incorrect from what I know. I could
be wrong, so I have asked iAnywhere to respond to this to clear it up for
all developers and companies interested in using Adaptive Server Anywhere in
there hand held solution.

This issue will be clarified by Sybase, then developers and corporation will
understand what needs to be licensed to uses these great products.

I do not feel I'm confusing anyone here. Sybase has asked me as a member of
TeamSybase to monitor forums and answer question. How to license the
software is a very important question and it needs to be answered correctly.
It appears we have a different view on how Adaptive Server Anywhere needs to
be licensed and I may be wrong, but all the information I have read and the
calls I have made indicate to me the software needs to be licensed if you
sync data in anyway to the database. IMO using your example if you load
corporate data into the database you need to license it.

--
Dean Jones [TeamSybase]
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 ext 112

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f72d222$1@forums-2-dub...
> Dean;
>
> Ok here is the official scoop from my Sybase contacts:
> First of all here at the RT restrictions for the royalty free ASA
> version.....
> Restriction summary
>
> The major restrictions for the Adaptive Server Anywhere for Windows CE
>
> Royalty-Free Runtime Edition are as follows:
>
> ¨ No transaction log The Adaptive Server Anywhere for Windows CE
>
> Royalty-Free Runtime Edition does not use a transaction log.
>
> Consequently, it cannot take part in a replication environment.
>
> ¨ No data definition You cannot create or alter database objects such as
>
> stored procedures, tables, and indexes.
>
> ¨ No stored procedures, events, or triggers The Adaptive Server
>
> Anywhere for Windows CE Royalty-Free Runtime Edition does not
>
> support the use of stored procedures, events, or triggers. Consequently,
>
> procedure profiling is not available.
>
> ¨ No events or schedules The Adaptive Server Anywhere for Windows
>
> CE Royalty-Free Runtime Edition does not support events or scheduling
>
> of events.
>
> ¨ No defragmentation support You cannot query the database for
>
> fragmentation, nor can you issue defragmentation commands.
>
> ¨ No Java The Java-in-the-database features are not available in the
>
> Adaptive Server Anywhere for Windows CE Royalty-Free Runtime
>
> Edition.
>
> ¨ No remote data access You cannot access data on remote servers
>
> using the Adaptive Server Anywhere for Windows CE Royalty-Free
>
> Runtime Edition.
>
> ¨ No database file encryption The Adaptive Server Anywhere for
>
> Windows CE Royalty-Free Runtime Edition does not support database
>
> file encryption.
>
>
> The Key clause above is "no remote data access". This means from within an
> ASA database to any other! For example, you could use "replication"
> (ASA=>ASA) services or, write an ASA - Trigger, SP, Function, etc that
> updates a "remote" table. The main theme is accessing remote data from
> "WITHIN ASA". This has nothing to do with how you manipulate the data
> outside of ASA (i.e.: SQL script files, VB, PB, Delphi, Java, etc).
>
> So please do not confuse the PPB developers with what you can or can not
do
> with ASA from PB or PPB vs. "within ASA".
>
> Thanks ... Chris
>
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f726227@forums-2-dub...
> > you would load it with your program. If data is sync'ed to the db or
> sync'ed
> > from it you must license the database.
> >
> > If Sybase didn't make users license the database how would they make
> > money??????
> > Come on really!
> >
> > My point is the argument can sounds dumb either direction. MS SQL CE is
> the
> > same way. If the data is used off the device it must be licensed. The
> > runtime engine is a stand-alone database for a stand-alone application.
> >
> > Adaptive Server Anywhere is a great database. Its very inexpensive,
small
> > foot-print, scalable... that's way companies purchase licenses of this
> great
> > DB.
> >
> > My guess is if Sybase create drivers to connect directly to other
> databases
> > they will become part of ASA product. Just my .02.
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > news:3f71cb3e$1@forums-1-dub...
> > > Dean;
> > >
> > > So how do you load the database???????
> > > Come one really!
> > >
> > > Chris
> > >
> > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > message
> > > news:3f71b4b8@forums-2-dub...
> > > > Here is the answer from Sybase.
> > > >
> > > > >>
> > > > Both accessing and sending are prohibited. This is a stipulation of
> the
> > > > licensing for the runtime. No replication by any means.
> > > >
> > > > <<
> > > >
> > > > Here is the ReadMe. This is a list of restrictions. The No remote
> data
> > > > access is the only one that is confussing. Does it mean you cannot
> > access
> > > > data on a remote server or send data to a remote server. I just
talked
> > > with
> > > > iAnywhere and the answer stated above. No replication by any means
or
> > you
> > > > must license the software. Again I'm stating what I'm told from
> > iAnywhere
> > > > and information I'm reading in the ASA runtime engine files.
> > > >
> > > >
> > > >
> > > > The major restrictions for the Desktop Runtime Edition are as
follows:
> > > >
> > > > ¨ No transaction log The Desktop Runtime Edition does not use a
> > > >
> > > > transaction log. Consequently, it cannot take part in a replication
or
> > > >
> > > > synchronization environment.
> > > >
> > > > ¨ No data definition You cannot create or alter database objects
such
> as
> > > >
> > > > stored procedures, tables, and indexes.
> > > >
> > > > ¨ No stored procedures, events, or triggers The Desktop Runtime
> > > >
> > > > Edition does not support the use of stored procedures, events, or
> > > triggers.
> > > >
> > > > Consequently, procedure profiling is not available.
> > > >
> > > > ¨ No events or schedules The Desktop Runtime Edition does not
> > > >
> > > > support events or scheduling of events.
> > > >
> > > > ¨ No defragmentation support You cannot query the database for
> > > >
> > > > fragmentation, nor can you issue defragmentation commands.
> > > >
> > > > ¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition
> > > >
> > > > does not support transactions involved with Distributed Transaction
> > > >
> > > > Coordination.
> > > >
> > > > ¨ No support for SMP-capable machines The Desktop Runtime Edition
> > > >
> > > > does not support multi-processor machines.
> > > >
> > > > No Java The Java-in-the-database features are not available in the
> > > >
> > > > Desktop Runtime Edition.
> > > >
> > > > ¨ No remote data access You cannot access data on remote servers
> > > >
> > > > using the Desktop Runtime Edition.
> > > >
> > > > ¨ No jConnect access You can access the Desktop Runtime Edition
> > > >
> > > > from JDBC using the iAnywhere JDBC driver, but not using the Sybase
> > > >
> > > > jConnect JDBC driver.
> > > >
> > > > ¨ No database file encryption The Desktop Runtime Edition does not
> > > >
> > > > support database file encryption.
> > > >
> > > > ¨ No communication encryption You cannot encrypt client/server
> > > >
> > > > communications using the Desktop Runtime Edition.
> > > >
> > > > ¨ No web services The Desktop Runtime Edition does not support web
> > > >
> > > > services, including HTTP server and SOAP.
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Dean Jones [TeamSybase]
> > > > CEO
> > > > PowerObjects
> > > > http://www.powerobjects.com
> > > > (612) 339-3355 ext 112
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > news:3f71b126$1@forums-1-dub...
> > > > > No, that is for Mobilink. You are free to Export/Import data from
> > where
> > > > > ever. The only run time ASA engine restriction is you can not
> perform
> > > DDL
> > > > > and no SP's!
> > > > >
> > > > >
> > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote
in
> > > > message
> > > > > news:3f719f11$1@forums-1-dub...
> > > > > > I have been on the phone with Sybase on this issue a lot lately.
> The
> > > > > version
> > > > > > of ASA that can be distributed is not license to sync data back
to
> > any
> > > > > > database. If you sync data you must license the database for
each
> > > > install.
> > > > > > About $120 per client. My company is a iAnywhere partner and I
> have
> > > > > research
> > > > > > this. I would not tell developers they can do this without
> approval
> > > from
> > > > > > Sybase/iAnywhere.
> > > > > >
> > > > > > I am referring to the Desktop Runtime Edition. The one that you
> can
> > > > > > distribute with your applications. I will follow up with this
some
> > > more,
> > > > > but
> > > > > > I have been sent several documents and so far they all save the
> data
> > > > from
> > > > > > the desktop runtime edition cannot assess data from remote
> database
> > > and
> > > > > > cannot sync data with a remote database.
> > > > > >
> > > > > > I will get on the phone again and see if I can get someone from
> > Sybase
> > > > to
> > > > > > clarify this issue.
> > > > > >
> > > > > > --
> > > > > > Dean Jones [TeamSybase]
> > > > > > CEO
> > > > > > PowerObjects
> > > > > > http://www.powerobjects.com
> > > > > > (612) 339-3355 ext 112
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > news:3f7177c2$1@forums-2-dub...
> > > > > > > NO, not from PowerBuilder (cradled PC).
> > > > > > >
> > > > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
> wrote
> > in
> > > > > > message
> > > > > > > news:3f70aabd$1@forums-2-dub...
> > > > > > > > If you sync databases you must license ASA. If you only run
> the
> > > > > desktop
> > > > > > > > version you can deploy without licensing. Basically its just
> > like
> > > MS
> > > > > SQL
> > > > > > > CE.
> > > > > > > > If the data is used off of the hand held device in any way
by
> > any
> > > > > means
> > > > > > > you
> > > > > > > > must license the ASA database.
> > > > > > > >
> > > > > > > > --
> > > > > > > > Dean Jones [TeamSybase]
> > > > > > > > CEO
> > > > > > > > PowerObjects
> > > > > > > > http://www.powerobjects.com
> > > > > > > > (612) 339-3355 ext 112
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > > > > news:3f6f4cad$1@forums-1-dub...
> > > > > > > > > I noticed your post on the news groups, I am hoping I can
> > follow
> > > > up
> > > > > > with
> > > > > > > > >
> > > > > > > > > You a bit. We are attempting to move data as follows.
> > > > > > > > >
> > > > > > > > > Case 1:
> > > > > > > > >
> > > > > > > > > ---------------------------------------------
> > > > > > > > >
> > > > > > > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > > > > > > >
> > > > > > > > > We have this working. But we are stuck on the
> > > > > > > > >
> > > > > > > > > Fact an ASA 8 engine has to be running on
> > > > > > > > >
> > > > > > > > > The desktop before the pocket PC will connect
> > > > > > > > >
> > > > > > > > > To it.
> > > > > > > > >
> > > > > > > > > Case 2:
> > > > > > > > >
> > > > > > > > > ---------------------------------------------
> > > > > > > > >
> > > > > > > > > Just to clarify, are you saying that you can
> > > > > > > > >
> > > > > > > > > Use pb9/pipelines to connect between a database
> > > > > > > > >
> > > > > > > > > On a server, and move data between the pocketPC
> > > > > > > > >
> > > > > > > > > Database and the server ? Probably sounds like
> > > > > > > > >
> > > > > > > > > A silly question but...
> > > > > > > > >
> > > > > > > > > Thanks in advance
> > > > > > > > >
> > > > > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > > > > news:3f67246f$1@forums-1-dub...
> > > > > > > > > > Jun;
> > > > > > > > > >
> > > > > > > > > > I developed my own "Sync" utility using PB 9 and
> Pipelines.
> > > It
> > > > > took
> > > > > > > me
> > > > > > > > > > about a day to program and another day to unit test. It
is
> > now
> > > > in
> > > > > > > > > production
> > > > > > > > > > and rock solid. The utility (runs on the PC) connects to
> the
> > > > > > corporate
> > > > > > > > DB
> > > > > > > > > > and PPC ASA simultaneously and pipes data both ways! I
was
> > in
> > > > the
> > > > > > same
> > > > > > > > > > quandary as you currently, as the MobiLink solution was
> > > elegant
> > > > > but
> > > > > > > way
> > > > > > > > > too
> > > > > > > > > > costly to charge to the client to make my application
cost
> > > > > > effective.
> > > > > > > > > >
> > > > > > > > > > So a home grown solution may not be that bad. Anyway ...
> > food
> > > > for
> > > > > > > > thought.
> > > > > > > > > >
> > > > > > > > > > regards ... Chris
> > > > > > > > > > Great White North Technical Evangelist
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > > > > > > news:3f661c53$1@forums-2-dub...
> > > > > > > > > > > I have been trying the Pocket Powerbuilder 1.0
> Evaluation
> > > and
> > > > > has
> > > > > > > > > > successfully
> > > > > > > > > > > created a simple application. Our consolidated
database
> is
> > > > > ORACLE
> > > > > > > and
> > > > > > > > I
> > > > > > > > > > > understand we have to run a SQL to create the ML_*
> tables
> > > for
> > > > > the
> > > > > > > > > Mobilink
> > > > > > > > > > > synchronization process. Moreover, we have to purchase
a
> > > > license
> > > > > > in
> > > > > > > > > > deploying
> > > > > > > > > > > these components of Pocket Powerbuilder i.e. Mobilink
> and
> > > SQL
> > > > > > Remote
> > > > > > > > > > > Synchronization technologies and Sybase Central
> > > Administration
> > > > > > tool.
> > > > > > > > > Now,
> > > > > > > > > > that
> > > > > > > > > > > turns me off (sorry..).
> > > > > > > > > > >
> > > > > > > > > > > My question: Is there any other way to synchronize
with
> > the
> > > > > > > > consolidated
> > > > > > > > > > Oracle
> > > > > > > > > > > database without using the Mobilink synchronization
> > > technique?
> > > > I
> > > > > > > knew
> > > > > > > > we
> > > > > > > > > > can
> > > > > > > > > > > write a Powerbuilder application to read an ASA local
> > > database
> > > > > but
> > > > > > > > again
> > > > > > > > > > it's
> > > > > > > > > > > not royalty free since we will be deploying that
> database
> > > off
> > > > > the
> > > > > > > > Pocket
> > > > > > > > > > PC
> > > > > > > > > > > 2002. Can we use the SaveAs function to create a text
or
> > > Excel
> > > > > or
> > > > > > > DBF
> > > > > > > > > file
> > > > > > > > > > on
> > > > > > > > > > > Pocket PC 2002 then ActiveSync to transfer to local PC
> and
> > > > then
> > > > > > > > > manipulate
> > > > > > > > > > or
> > > > > > > > > > > use it within Powerbuilder application to update
> > > Consolidated
> > > > > > Oracle
> > > > > > > > > > database?
> > > > > > > > > > >
> > > > > > > > > > > Your input is greatly appreciated.
> > > > > > > > > > >
> > > > > > > > > > > Thanks,
> > > > > > > > > > > Jun
> > > > > > > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-25 16:09:07.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub> <3f71b126$1@forums-1-dub> <3f71b4b8@forums-2-dub> <3f71cb3e$1@forums-1-dub> <3f726227@forums-2-dub> <3f72d222$1@forums-2-dub> <3f72f907@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 588
Organization: The Supreme Court of Canada
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 209.47.227.134
X-Original-NNTP-Posting-Host: 209.47.227.134
Message-ID: <3f731323$1@forums-1-dub>
Date: 25 Sep 2003 09:09:07 -0700
X-Trace: forums-1-dub 1064506147 209.47.227.134 (25 Sep 2003 09:09:07 -0700)
X-Original-Trace: 25 Sep 2003 09:09:07 -0700, 209.47.227.134
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:589
Article PK: 267123

I think an answer from Mr. Chen here would be divinely appreciated.

Than again, there are things like "military intelligence" - you know it
exists, but you can never make sense of it!

regards ... Chris

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f72f907@forums-1-dub...
> Chris -
>
> I have asked Sybase to post an answer to this issue. What you have just
> posted here is exactly what I have posted twice now. After the facts it
> appears you have stated your opinion or interpretation of the facts.
>
> My company sells Sybase and iAnywhere software, and work with Sybase and
> iAnywhere to understand how the software must be licensed everyday. Your
> interpretations of the license appears incorrect from what I know. I could
> be wrong, so I have asked iAnywhere to respond to this to clear it up for
> all developers and companies interested in using Adaptive Server Anywhere
in
> there hand held solution.
>
> This issue will be clarified by Sybase, then developers and corporation
will
> understand what needs to be licensed to uses these great products.
>
> I do not feel I'm confusing anyone here. Sybase has asked me as a member
of
> TeamSybase to monitor forums and answer question. How to license the
> software is a very important question and it needs to be answered
correctly.
> It appears we have a different view on how Adaptive Server Anywhere needs
to
> be licensed and I may be wrong, but all the information I have read and
the
> calls I have made indicate to me the software needs to be licensed if you
> sync data in anyway to the database. IMO using your example if you load
> corporate data into the database you need to license it.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f72d222$1@forums-2-dub...
> > Dean;
> >
> > Ok here is the official scoop from my Sybase contacts:
> > First of all here at the RT restrictions for the royalty free ASA
> > version.....
> > Restriction summary
> >
> > The major restrictions for the Adaptive Server Anywhere for Windows CE
> >
> > Royalty-Free Runtime Edition are as follows:
> >
> > ¨ No transaction log The Adaptive Server Anywhere for Windows CE
> >
> > Royalty-Free Runtime Edition does not use a transaction log.
> >
> > Consequently, it cannot take part in a replication environment.
> >
> > ¨ No data definition You cannot create or alter database objects such as
> >
> > stored procedures, tables, and indexes.
> >
> > ¨ No stored procedures, events, or triggers The Adaptive Server
> >
> > Anywhere for Windows CE Royalty-Free Runtime Edition does not
> >
> > support the use of stored procedures, events, or triggers. Consequently,
> >
> > procedure profiling is not available.
> >
> > ¨ No events or schedules The Adaptive Server Anywhere for Windows
> >
> > CE Royalty-Free Runtime Edition does not support events or scheduling
> >
> > of events.
> >
> > ¨ No defragmentation support You cannot query the database for
> >
> > fragmentation, nor can you issue defragmentation commands.
> >
> > ¨ No Java The Java-in-the-database features are not available in the
> >
> > Adaptive Server Anywhere for Windows CE Royalty-Free Runtime
> >
> > Edition.
> >
> > ¨ No remote data access You cannot access data on remote servers
> >
> > using the Adaptive Server Anywhere for Windows CE Royalty-Free
> >
> > Runtime Edition.
> >
> > ¨ No database file encryption The Adaptive Server Anywhere for
> >
> > Windows CE Royalty-Free Runtime Edition does not support database
> >
> > file encryption.
> >
> >
> > The Key clause above is "no remote data access". This means from within
an
> > ASA database to any other! For example, you could use "replication"
> > (ASA=>ASA) services or, write an ASA - Trigger, SP, Function, etc that
> > updates a "remote" table. The main theme is accessing remote data from
> > "WITHIN ASA". This has nothing to do with how you manipulate the data
> > outside of ASA (i.e.: SQL script files, VB, PB, Delphi, Java, etc).
> >
> > So please do not confuse the PPB developers with what you can or can not
> do
> > with ASA from PB or PPB vs. "within ASA".
> >
> > Thanks ... Chris
> >
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f726227@forums-2-dub...
> > > you would load it with your program. If data is sync'ed to the db or
> > sync'ed
> > > from it you must license the database.
> > >
> > > If Sybase didn't make users license the database how would they make
> > > money??????
> > > Come on really!
> > >
> > > My point is the argument can sounds dumb either direction. MS SQL CE
is
> > the
> > > same way. If the data is used off the device it must be licensed. The
> > > runtime engine is a stand-alone database for a stand-alone
application.
> > >
> > > Adaptive Server Anywhere is a great database. Its very inexpensive,
> small
> > > foot-print, scalable... that's way companies purchase licenses of this
> > great
> > > DB.
> > >
> > > My guess is if Sybase create drivers to connect directly to other
> > databases
> > > they will become part of ASA product. Just my .02.
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > news:3f71cb3e$1@forums-1-dub...
> > > > Dean;
> > > >
> > > > So how do you load the database???????
> > > > Come one really!
> > > >
> > > > Chris
> > > >
> > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > > message
> > > > news:3f71b4b8@forums-2-dub...
> > > > > Here is the answer from Sybase.
> > > > >
> > > > > >>
> > > > > Both accessing and sending are prohibited. This is a stipulation
of
> > the
> > > > > licensing for the runtime. No replication by any means.
> > > > >
> > > > > <<
> > > > >
> > > > > Here is the ReadMe. This is a list of restrictions. The No remote
> > data
> > > > > access is the only one that is confussing. Does it mean you cannot
> > > access
> > > > > data on a remote server or send data to a remote server. I just
> talked
> > > > with
> > > > > iAnywhere and the answer stated above. No replication by any means
> or
> > > you
> > > > > must license the software. Again I'm stating what I'm told from
> > > iAnywhere
> > > > > and information I'm reading in the ASA runtime engine files.
> > > > >
> > > > >
> > > > >
> > > > > The major restrictions for the Desktop Runtime Edition are as
> follows:
> > > > >
> > > > > ¨ No transaction log The Desktop Runtime Edition does not use a
> > > > >
> > > > > transaction log. Consequently, it cannot take part in a
replication
> or
> > > > >
> > > > > synchronization environment.
> > > > >
> > > > > ¨ No data definition You cannot create or alter database objects
> such
> > as
> > > > >
> > > > > stored procedures, tables, and indexes.
> > > > >
> > > > > ¨ No stored procedures, events, or triggers The Desktop Runtime
> > > > >
> > > > > Edition does not support the use of stored procedures, events, or
> > > > triggers.
> > > > >
> > > > > Consequently, procedure profiling is not available.
> > > > >
> > > > > ¨ No events or schedules The Desktop Runtime Edition does not
> > > > >
> > > > > support events or scheduling of events.
> > > > >
> > > > > ¨ No defragmentation support You cannot query the database for
> > > > >
> > > > > fragmentation, nor can you issue defragmentation commands.
> > > > >
> > > > > ¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition
> > > > >
> > > > > does not support transactions involved with Distributed
Transaction
> > > > >
> > > > > Coordination.
> > > > >
> > > > > ¨ No support for SMP-capable machines The Desktop Runtime Edition
> > > > >
> > > > > does not support multi-processor machines.
> > > > >
> > > > > No Java The Java-in-the-database features are not available in the
> > > > >
> > > > > Desktop Runtime Edition.
> > > > >
> > > > > ¨ No remote data access You cannot access data on remote servers
> > > > >
> > > > > using the Desktop Runtime Edition.
> > > > >
> > > > > ¨ No jConnect access You can access the Desktop Runtime Edition
> > > > >
> > > > > from JDBC using the iAnywhere JDBC driver, but not using the
Sybase
> > > > >
> > > > > jConnect JDBC driver.
> > > > >
> > > > > ¨ No database file encryption The Desktop Runtime Edition does not
> > > > >
> > > > > support database file encryption.
> > > > >
> > > > > ¨ No communication encryption You cannot encrypt client/server
> > > > >
> > > > > communications using the Desktop Runtime Edition.
> > > > >
> > > > > ¨ No web services The Desktop Runtime Edition does not support web
> > > > >
> > > > > services, including HTTP server and SOAP.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Dean Jones [TeamSybase]
> > > > > CEO
> > > > > PowerObjects
> > > > > http://www.powerobjects.com
> > > > > (612) 339-3355 ext 112
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > news:3f71b126$1@forums-1-dub...
> > > > > > No, that is for Mobilink. You are free to Export/Import data
from
> > > where
> > > > > > ever. The only run time ASA engine restriction is you can not
> > perform
> > > > DDL
> > > > > > and no SP's!
> > > > > >
> > > > > >
> > > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
wrote
> in
> > > > > message
> > > > > > news:3f719f11$1@forums-1-dub...
> > > > > > > I have been on the phone with Sybase on this issue a lot
lately.
> > The
> > > > > > version
> > > > > > > of ASA that can be distributed is not license to sync data
back
> to
> > > any
> > > > > > > database. If you sync data you must license the database for
> each
> > > > > install.
> > > > > > > About $120 per client. My company is a iAnywhere partner and I
> > have
> > > > > > research
> > > > > > > this. I would not tell developers they can do this without
> > approval
> > > > from
> > > > > > > Sybase/iAnywhere.
> > > > > > >
> > > > > > > I am referring to the Desktop Runtime Edition. The one that
you
> > can
> > > > > > > distribute with your applications. I will follow up with this
> some
> > > > more,
> > > > > > but
> > > > > > > I have been sent several documents and so far they all save
the
> > data
> > > > > from
> > > > > > > the desktop runtime edition cannot assess data from remote
> > database
> > > > and
> > > > > > > cannot sync data with a remote database.
> > > > > > >
> > > > > > > I will get on the phone again and see if I can get someone
from
> > > Sybase
> > > > > to
> > > > > > > clarify this issue.
> > > > > > >
> > > > > > > --
> > > > > > > Dean Jones [TeamSybase]
> > > > > > > CEO
> > > > > > > PowerObjects
> > > > > > > http://www.powerobjects.com
> > > > > > > (612) 339-3355 ext 112
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > > news:3f7177c2$1@forums-2-dub...
> > > > > > > > NO, not from PowerBuilder (cradled PC).
> > > > > > > >
> > > > > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
> > wrote
> > > in
> > > > > > > message
> > > > > > > > news:3f70aabd$1@forums-2-dub...
> > > > > > > > > If you sync databases you must license ASA. If you only
run
> > the
> > > > > > desktop
> > > > > > > > > version you can deploy without licensing. Basically its
just
> > > like
> > > > MS
> > > > > > SQL
> > > > > > > > CE.
> > > > > > > > > If the data is used off of the hand held device in any way
> by
> > > any
> > > > > > means
> > > > > > > > you
> > > > > > > > > must license the ASA database.
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > Dean Jones [TeamSybase]
> > > > > > > > > CEO
> > > > > > > > > PowerObjects
> > > > > > > > > http://www.powerobjects.com
> > > > > > > > > (612) 339-3355 ext 112
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > > > > > news:3f6f4cad$1@forums-1-dub...
> > > > > > > > > > I noticed your post on the news groups, I am hoping I
can
> > > follow
> > > > > up
> > > > > > > with
> > > > > > > > > >
> > > > > > > > > > You a bit. We are attempting to move data as follows.
> > > > > > > > > >
> > > > > > > > > > Case 1:
> > > > > > > > > >
> > > > > > > > > > ---------------------------------------------
> > > > > > > > > >
> > > > > > > > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > > > > > > > >
> > > > > > > > > > We have this working. But we are stuck on the
> > > > > > > > > >
> > > > > > > > > > Fact an ASA 8 engine has to be running on
> > > > > > > > > >
> > > > > > > > > > The desktop before the pocket PC will connect
> > > > > > > > > >
> > > > > > > > > > To it.
> > > > > > > > > >
> > > > > > > > > > Case 2:
> > > > > > > > > >
> > > > > > > > > > ---------------------------------------------
> > > > > > > > > >
> > > > > > > > > > Just to clarify, are you saying that you can
> > > > > > > > > >
> > > > > > > > > > Use pb9/pipelines to connect between a database
> > > > > > > > > >
> > > > > > > > > > On a server, and move data between the pocketPC
> > > > > > > > > >
> > > > > > > > > > Database and the server ? Probably sounds like
> > > > > > > > > >
> > > > > > > > > > A silly question but...
> > > > > > > > > >
> > > > > > > > > > Thanks in advance
> > > > > > > > > >
> > > > > > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in
message
> > > > > > > > > > news:3f67246f$1@forums-1-dub...
> > > > > > > > > > > Jun;
> > > > > > > > > > >
> > > > > > > > > > > I developed my own "Sync" utility using PB 9 and
> > Pipelines.
> > > > It
> > > > > > took
> > > > > > > > me
> > > > > > > > > > > about a day to program and another day to unit test.
It
> is
> > > now
> > > > > in
> > > > > > > > > > production
> > > > > > > > > > > and rock solid. The utility (runs on the PC) connects
to
> > the
> > > > > > > corporate
> > > > > > > > > DB
> > > > > > > > > > > and PPC ASA simultaneously and pipes data both ways! I
> was
> > > in
> > > > > the
> > > > > > > same
> > > > > > > > > > > quandary as you currently, as the MobiLink solution
was
> > > > elegant
> > > > > > but
> > > > > > > > way
> > > > > > > > > > too
> > > > > > > > > > > costly to charge to the client to make my application
> cost
> > > > > > > effective.
> > > > > > > > > > >
> > > > > > > > > > > So a home grown solution may not be that bad. Anyway
...
> > > food
> > > > > for
> > > > > > > > > thought.
> > > > > > > > > > >
> > > > > > > > > > > regards ... Chris
> > > > > > > > > > > Great White North Technical Evangelist
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > > > > > > > news:3f661c53$1@forums-2-dub...
> > > > > > > > > > > > I have been trying the Pocket Powerbuilder 1.0
> > Evaluation
> > > > and
> > > > > > has
> > > > > > > > > > > successfully
> > > > > > > > > > > > created a simple application. Our consolidated
> database
> > is
> > > > > > ORACLE
> > > > > > > > and
> > > > > > > > > I
> > > > > > > > > > > > understand we have to run a SQL to create the ML_*
> > tables
> > > > for
> > > > > > the
> > > > > > > > > > Mobilink
> > > > > > > > > > > > synchronization process. Moreover, we have to
purchase
> a
> > > > > license
> > > > > > > in
> > > > > > > > > > > deploying
> > > > > > > > > > > > these components of Pocket Powerbuilder i.e.
Mobilink
> > and
> > > > SQL
> > > > > > > Remote
> > > > > > > > > > > > Synchronization technologies and Sybase Central
> > > > Administration
> > > > > > > tool.
> > > > > > > > > > Now,
> > > > > > > > > > > that
> > > > > > > > > > > > turns me off (sorry..).
> > > > > > > > > > > >
> > > > > > > > > > > > My question: Is there any other way to synchronize
> with
> > > the
> > > > > > > > > consolidated
> > > > > > > > > > > Oracle
> > > > > > > > > > > > database without using the Mobilink synchronization
> > > > technique?
> > > > > I
> > > > > > > > knew
> > > > > > > > > we
> > > > > > > > > > > can
> > > > > > > > > > > > write a Powerbuilder application to read an ASA
local
> > > > database
> > > > > > but
> > > > > > > > > again
> > > > > > > > > > > it's
> > > > > > > > > > > > not royalty free since we will be deploying that
> > database
> > > > off
> > > > > > the
> > > > > > > > > Pocket
> > > > > > > > > > > PC
> > > > > > > > > > > > 2002. Can we use the SaveAs function to create a
text
> or
> > > > Excel
> > > > > > or
> > > > > > > > DBF
> > > > > > > > > > file
> > > > > > > > > > > on
> > > > > > > > > > > > Pocket PC 2002 then ActiveSync to transfer to local
PC
> > and
> > > > > then
> > > > > > > > > > manipulate
> > > > > > > > > > > or
> > > > > > > > > > > > use it within Powerbuilder application to update
> > > > Consolidated
> > > > > > > Oracle
> > > > > > > > > > > database?
> > > > > > > > > > > >
> > > > > > > > > > > > Your input is greatly appreciated.
> > > > > > > > > > > >
> > > > > > > > > > > > Thanks,
> > > > > > > > > > > > Jun
> > > > > > > > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > > > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Martyn Mallick Posted on 2003-09-29 22:00:21.0Z
From: "Martyn Mallick" <mmallick.removethis@ianywhere.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f661c53$1@forums-2-dub> <3f67246f$1@forums-1-dub> <3f6f4cad$1@forums-1-dub> <3f70aabd$1@forums-2-dub> <3f7177c2$1@forums-2-dub> <3f719f11$1@forums-1-dub> <3f71b126$1@forums-1-dub> <3f71b4b8@forums-2-dub> <3f71cb3e$1@forums-1-dub> <3f726227@forums-2-dub> <3f72d222$1@forums-2-dub> <3f72f907@forums-1-dub>
Subject: Re: Alternative for Mobilink Synchronization
Lines: 612
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: mmallick-pc.sybase.com
X-Original-NNTP-Posting-Host: mmallick-pc.sybase.com
Message-ID: <3f78ab75$1@forums-1-dub>
Date: 29 Sep 2003 15:00:21 -0700
X-Trace: forums-1-dub 1064872821 172.31.141.129 (29 Sep 2003 15:00:21 -0700)
X-Original-Trace: 29 Sep 2003 15:00:21 -0700, mmallick-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:630
Article PK: 267165

Sorry I haven't responded to this sooner - I was on vacation. As to the
discussion regarding licensing of ASA, Dean Jones is correct in his posts.
The intent of the license is to not permit use of the runtime edition where
it is being "synced" whether they are using our sync or their own or a 3rd
parties. This includes one-way and two-way data transfer.

This is addressed in the product's licensing. The Pocket PowerBuilder
Product Specific License Terms include the following statement:

"You may reproduce, use, and distribute the ASA Runtime Edition
Redistributable Components (the "Redistributable Components", or
"Distributable Components" for purposes of the License Agreement) that are
specified in the accompanying Documentation in conjunction with and as part
of your standalone database application that you have written using this
Program."

This statement limits use of the ASA Runtime to a "standalone database
application". If the data is being synced in any fashion, the application is
no longer standalone.

In addition, the sentence reading "No remote data access - You cannot access
data on remote servers" in the Runtime Readme precludes the application from
communicating with data on any remote server.

We appreciate the feedback provided in these various posts. We will be
clarifying this matter in a future revision of the product license.

Thanks

-Marty

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f72f907@forums-1-dub...
> Chris -
>
> I have asked Sybase to post an answer to this issue. What you have just
> posted here is exactly what I have posted twice now. After the facts it
> appears you have stated your opinion or interpretation of the facts.
>
> My company sells Sybase and iAnywhere software, and work with Sybase and
> iAnywhere to understand how the software must be licensed everyday. Your
> interpretations of the license appears incorrect from what I know. I could
> be wrong, so I have asked iAnywhere to respond to this to clear it up for
> all developers and companies interested in using Adaptive Server Anywhere
in
> there hand held solution.
>
> This issue will be clarified by Sybase, then developers and corporation
will
> understand what needs to be licensed to uses these great products.
>
> I do not feel I'm confusing anyone here. Sybase has asked me as a member
of
> TeamSybase to monitor forums and answer question. How to license the
> software is a very important question and it needs to be answered
correctly.
> It appears we have a different view on how Adaptive Server Anywhere needs
to
> be licensed and I may be wrong, but all the information I have read and
the
> calls I have made indicate to me the software needs to be licensed if you
> sync data in anyway to the database. IMO using your example if you load
> corporate data into the database you need to license it.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> news:3f72d222$1@forums-2-dub...
> > Dean;
> >
> > Ok here is the official scoop from my Sybase contacts:
> > First of all here at the RT restrictions for the royalty free ASA
> > version.....
> > Restriction summary
> >
> > The major restrictions for the Adaptive Server Anywhere for Windows CE
> >
> > Royalty-Free Runtime Edition are as follows:
> >
> > ¨ No transaction log The Adaptive Server Anywhere for Windows CE
> >
> > Royalty-Free Runtime Edition does not use a transaction log.
> >
> > Consequently, it cannot take part in a replication environment.
> >
> > ¨ No data definition You cannot create or alter database objects such as
> >
> > stored procedures, tables, and indexes.
> >
> > ¨ No stored procedures, events, or triggers The Adaptive Server
> >
> > Anywhere for Windows CE Royalty-Free Runtime Edition does not
> >
> > support the use of stored procedures, events, or triggers. Consequently,
> >
> > procedure profiling is not available.
> >
> > ¨ No events or schedules The Adaptive Server Anywhere for Windows
> >
> > CE Royalty-Free Runtime Edition does not support events or scheduling
> >
> > of events.
> >
> > ¨ No defragmentation support You cannot query the database for
> >
> > fragmentation, nor can you issue defragmentation commands.
> >
> > ¨ No Java The Java-in-the-database features are not available in the
> >
> > Adaptive Server Anywhere for Windows CE Royalty-Free Runtime
> >
> > Edition.
> >
> > ¨ No remote data access You cannot access data on remote servers
> >
> > using the Adaptive Server Anywhere for Windows CE Royalty-Free
> >
> > Runtime Edition.
> >
> > ¨ No database file encryption The Adaptive Server Anywhere for
> >
> > Windows CE Royalty-Free Runtime Edition does not support database
> >
> > file encryption.
> >
> >
> > The Key clause above is "no remote data access". This means from within
an
> > ASA database to any other! For example, you could use "replication"
> > (ASA=>ASA) services or, write an ASA - Trigger, SP, Function, etc that
> > updates a "remote" table. The main theme is accessing remote data from
> > "WITHIN ASA". This has nothing to do with how you manipulate the data
> > outside of ASA (i.e.: SQL script files, VB, PB, Delphi, Java, etc).
> >
> > So please do not confuse the PPB developers with what you can or can not
> do
> > with ASA from PB or PPB vs. "within ASA".
> >
> > Thanks ... Chris
> >
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f726227@forums-2-dub...
> > > you would load it with your program. If data is sync'ed to the db or
> > sync'ed
> > > from it you must license the database.
> > >
> > > If Sybase didn't make users license the database how would they make
> > > money??????
> > > Come on really!
> > >
> > > My point is the argument can sounds dumb either direction. MS SQL CE
is
> > the
> > > same way. If the data is used off the device it must be licensed. The
> > > runtime engine is a stand-alone database for a stand-alone
application.
> > >
> > > Adaptive Server Anywhere is a great database. Its very inexpensive,
> small
> > > foot-print, scalable... that's way companies purchase licenses of this
> > great
> > > DB.
> > >
> > > My guess is if Sybase create drivers to connect directly to other
> > databases
> > > they will become part of ASA product. Just my .02.
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > news:3f71cb3e$1@forums-1-dub...
> > > > Dean;
> > > >
> > > > So how do you load the database???????
> > > > Come one really!
> > > >
> > > > Chris
> > > >
> > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > > message
> > > > news:3f71b4b8@forums-2-dub...
> > > > > Here is the answer from Sybase.
> > > > >
> > > > > >>
> > > > > Both accessing and sending are prohibited. This is a stipulation
of
> > the
> > > > > licensing for the runtime. No replication by any means.
> > > > >
> > > > > <<
> > > > >
> > > > > Here is the ReadMe. This is a list of restrictions. The No remote
> > data
> > > > > access is the only one that is confussing. Does it mean you cannot
> > > access
> > > > > data on a remote server or send data to a remote server. I just
> talked
> > > > with
> > > > > iAnywhere and the answer stated above. No replication by any means
> or
> > > you
> > > > > must license the software. Again I'm stating what I'm told from
> > > iAnywhere
> > > > > and information I'm reading in the ASA runtime engine files.
> > > > >
> > > > >
> > > > >
> > > > > The major restrictions for the Desktop Runtime Edition are as
> follows:
> > > > >
> > > > > ¨ No transaction log The Desktop Runtime Edition does not use a
> > > > >
> > > > > transaction log. Consequently, it cannot take part in a
replication
> or
> > > > >
> > > > > synchronization environment.
> > > > >
> > > > > ¨ No data definition You cannot create or alter database objects
> such
> > as
> > > > >
> > > > > stored procedures, tables, and indexes.
> > > > >
> > > > > ¨ No stored procedures, events, or triggers The Desktop Runtime
> > > > >
> > > > > Edition does not support the use of stored procedures, events, or
> > > > triggers.
> > > > >
> > > > > Consequently, procedure profiling is not available.
> > > > >
> > > > > ¨ No events or schedules The Desktop Runtime Edition does not
> > > > >
> > > > > support events or scheduling of events.
> > > > >
> > > > > ¨ No defragmentation support You cannot query the database for
> > > > >
> > > > > fragmentation, nor can you issue defragmentation commands.
> > > > >
> > > > > ¨ No Microsoft/EAServer DTC support The Desktop Runtime Edition
> > > > >
> > > > > does not support transactions involved with Distributed
Transaction
> > > > >
> > > > > Coordination.
> > > > >
> > > > > ¨ No support for SMP-capable machines The Desktop Runtime Edition
> > > > >
> > > > > does not support multi-processor machines.
> > > > >
> > > > > No Java The Java-in-the-database features are not available in the
> > > > >
> > > > > Desktop Runtime Edition.
> > > > >
> > > > > ¨ No remote data access You cannot access data on remote servers
> > > > >
> > > > > using the Desktop Runtime Edition.
> > > > >
> > > > > ¨ No jConnect access You can access the Desktop Runtime Edition
> > > > >
> > > > > from JDBC using the iAnywhere JDBC driver, but not using the
Sybase
> > > > >
> > > > > jConnect JDBC driver.
> > > > >
> > > > > ¨ No database file encryption The Desktop Runtime Edition does not
> > > > >
> > > > > support database file encryption.
> > > > >
> > > > > ¨ No communication encryption You cannot encrypt client/server
> > > > >
> > > > > communications using the Desktop Runtime Edition.
> > > > >
> > > > > ¨ No web services The Desktop Runtime Edition does not support web
> > > > >
> > > > > services, including HTTP server and SOAP.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Dean Jones [TeamSybase]
> > > > > CEO
> > > > > PowerObjects
> > > > > http://www.powerobjects.com
> > > > > (612) 339-3355 ext 112
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > news:3f71b126$1@forums-1-dub...
> > > > > > No, that is for Mobilink. You are free to Export/Import data
from
> > > where
> > > > > > ever. The only run time ASA engine restriction is you can not
> > perform
> > > > DDL
> > > > > > and no SP's!
> > > > > >
> > > > > >
> > > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
wrote
> in
> > > > > message
> > > > > > news:3f719f11$1@forums-1-dub...
> > > > > > > I have been on the phone with Sybase on this issue a lot
lately.
> > The
> > > > > > version
> > > > > > > of ASA that can be distributed is not license to sync data
back
> to
> > > any
> > > > > > > database. If you sync data you must license the database for
> each
> > > > > install.
> > > > > > > About $120 per client. My company is a iAnywhere partner and I
> > have
> > > > > > research
> > > > > > > this. I would not tell developers they can do this without
> > approval
> > > > from
> > > > > > > Sybase/iAnywhere.
> > > > > > >
> > > > > > > I am referring to the Desktop Runtime Edition. The one that
you
> > can
> > > > > > > distribute with your applications. I will follow up with this
> some
> > > > more,
> > > > > > but
> > > > > > > I have been sent several documents and so far they all save
the
> > data
> > > > > from
> > > > > > > the desktop runtime edition cannot assess data from remote
> > database
> > > > and
> > > > > > > cannot sync data with a remote database.
> > > > > > >
> > > > > > > I will get on the phone again and see if I can get someone
from
> > > Sybase
> > > > > to
> > > > > > > clarify this issue.
> > > > > > >
> > > > > > > --
> > > > > > > Dean Jones [TeamSybase]
> > > > > > > CEO
> > > > > > > PowerObjects
> > > > > > > http://www.powerobjects.com
> > > > > > > (612) 339-3355 ext 112
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
> > > > > > > news:3f7177c2$1@forums-2-dub...
> > > > > > > > NO, not from PowerBuilder (cradled PC).
> > > > > > > >
> > > > > > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
> > wrote
> > > in
> > > > > > > message
> > > > > > > > news:3f70aabd$1@forums-2-dub...
> > > > > > > > > If you sync databases you must license ASA. If you only
run
> > the
> > > > > > desktop
> > > > > > > > > version you can deploy without licensing. Basically its
just
> > > like
> > > > MS
> > > > > > SQL
> > > > > > > > CE.
> > > > > > > > > If the data is used off of the hand held device in any way
> by
> > > any
> > > > > > means
> > > > > > > > you
> > > > > > > > > must license the ASA database.
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > Dean Jones [TeamSybase]
> > > > > > > > > CEO
> > > > > > > > > PowerObjects
> > > > > > > > > http://www.powerobjects.com
> > > > > > > > > (612) 339-3355 ext 112
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > > > > > news:3f6f4cad$1@forums-1-dub...
> > > > > > > > > > I noticed your post on the news groups, I am hoping I
can
> > > follow
> > > > > up
> > > > > > > with
> > > > > > > > > >
> > > > > > > > > > You a bit. We are attempting to move data as follows.
> > > > > > > > > >
> > > > > > > > > > Case 1:
> > > > > > > > > >
> > > > > > > > > > ---------------------------------------------
> > > > > > > > > >
> > > > > > > > > > PocketPC device (asa8) -> DesktopPC (asa 8)
> > > > > > > > > >
> > > > > > > > > > We have this working. But we are stuck on the
> > > > > > > > > >
> > > > > > > > > > Fact an ASA 8 engine has to be running on
> > > > > > > > > >
> > > > > > > > > > The desktop before the pocket PC will connect
> > > > > > > > > >
> > > > > > > > > > To it.
> > > > > > > > > >
> > > > > > > > > > Case 2:
> > > > > > > > > >
> > > > > > > > > > ---------------------------------------------
> > > > > > > > > >
> > > > > > > > > > Just to clarify, are you saying that you can
> > > > > > > > > >
> > > > > > > > > > Use pb9/pipelines to connect between a database
> > > > > > > > > >
> > > > > > > > > > On a server, and move data between the pocketPC
> > > > > > > > > >
> > > > > > > > > > Database and the server ? Probably sounds like
> > > > > > > > > >
> > > > > > > > > > A silly question but...
> > > > > > > > > >
> > > > > > > > > > Thanks in advance
> > > > > > > > > >
> > > > > > > > > > "Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in
message
> > > > > > > > > > news:3f67246f$1@forums-1-dub...
> > > > > > > > > > > Jun;
> > > > > > > > > > >
> > > > > > > > > > > I developed my own "Sync" utility using PB 9 and
> > Pipelines.
> > > > It
> > > > > > took
> > > > > > > > me
> > > > > > > > > > > about a day to program and another day to unit test.
It
> is
> > > now
> > > > > in
> > > > > > > > > > production
> > > > > > > > > > > and rock solid. The utility (runs on the PC) connects
to
> > the
> > > > > > > corporate
> > > > > > > > > DB
> > > > > > > > > > > and PPC ASA simultaneously and pipes data both ways! I
> was
> > > in
> > > > > the
> > > > > > > same
> > > > > > > > > > > quandary as you currently, as the MobiLink solution
was
> > > > elegant
> > > > > > but
> > > > > > > > way
> > > > > > > > > > too
> > > > > > > > > > > costly to charge to the client to make my application
> cost
> > > > > > > effective.
> > > > > > > > > > >
> > > > > > > > > > > So a home grown solution may not be that bad. Anyway
...
> > > food
> > > > > for
> > > > > > > > > thought.
> > > > > > > > > > >
> > > > > > > > > > > regards ... Chris
> > > > > > > > > > > Great White North Technical Evangelist
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > "Jun " <junredillas@wvdhhr.org> wrote in message
> > > > > > > > > > > news:3f661c53$1@forums-2-dub...
> > > > > > > > > > > > I have been trying the Pocket Powerbuilder 1.0
> > Evaluation
> > > > and
> > > > > > has
> > > > > > > > > > > successfully
> > > > > > > > > > > > created a simple application. Our consolidated
> database
> > is
> > > > > > ORACLE
> > > > > > > > and
> > > > > > > > > I
> > > > > > > > > > > > understand we have to run a SQL to create the ML_*
> > tables
> > > > for
> > > > > > the
> > > > > > > > > > Mobilink
> > > > > > > > > > > > synchronization process. Moreover, we have to
purchase
> a
> > > > > license
> > > > > > > in
> > > > > > > > > > > deploying
> > > > > > > > > > > > these components of Pocket Powerbuilder i.e.
Mobilink
> > and
> > > > SQL
> > > > > > > Remote
> > > > > > > > > > > > Synchronization technologies and Sybase Central
> > > > Administration
> > > > > > > tool.
> > > > > > > > > > Now,
> > > > > > > > > > > that
> > > > > > > > > > > > turns me off (sorry..).
> > > > > > > > > > > >
> > > > > > > > > > > > My question: Is there any other way to synchronize
> with
> > > the
> > > > > > > > > consolidated
> > > > > > > > > > > Oracle
> > > > > > > > > > > > database without using the Mobilink synchronization
> > > > technique?
> > > > > I
> > > > > > > > knew
> > > > > > > > > we
> > > > > > > > > > > can
> > > > > > > > > > > > write a Powerbuilder application to read an ASA
local
> > > > database
> > > > > > but
> > > > > > > > > again
> > > > > > > > > > > it's
> > > > > > > > > > > > not royalty free since we will be deploying that
> > database
> > > > off
> > > > > > the
> > > > > > > > > Pocket
> > > > > > > > > > > PC
> > > > > > > > > > > > 2002. Can we use the SaveAs function to create a
text
> or
> > > > Excel
> > > > > > or
> > > > > > > > DBF
> > > > > > > > > > file
> > > > > > > > > > > on
> > > > > > > > > > > > Pocket PC 2002 then ActiveSync to transfer to local
PC
> > and
> > > > > then
> > > > > > > > > > manipulate
> > > > > > > > > > > or
> > > > > > > > > > > > use it within Powerbuilder application to update
> > > > Consolidated
> > > > > > > Oracle
> > > > > > > > > > > database?
> > > > > > > > > > > >
> > > > > > > > > > > > Your input is greatly appreciated.
> > > > > > > > > > > >
> > > > > > > > > > > > Thanks,
> > > > > > > > > > > > Jun
> > > > > > > > > > > > ---== Posted via the PFCGuide Web Newsreader ==---
> > > > > > > > > > > > http://www.pfcguide.com/_newsgroups/group_list.asp
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>