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.

PPB connection to database other than ASA

13 posts in Pocket PowerBuilder Last posting was on 2003-09-30 03:51:48.0Z
Dave Pylatuk Posted on 2003-09-23 19:46:02.0Z
From: "Dave Pylatuk" <davep@centurysystems.net>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: PPB connection to database other than ASA
Lines: 21
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
X-Original-NNTP-Posting-Host: 216.209.35.102
Message-ID: <3f70a390@forums-2-dub>
X-Original-Trace: 23 Sep 2003 12:48:32 -0700, 216.209.35.102
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Sep 2003 12:41:56 -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 12:46:02 -0700
X-Trace: forums-1-dub 1064346362 10.22.108.75 (23 Sep 2003 12:46:02 -0700)
X-Original-Trace: 23 Sep 2003 12:46:02 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:538
Article PK: 267074

Hello.

I have seen a number of posts regarding synchronization etc,
to a corporate database. Can anyone provide an overall
summary of what PocketPB can and can not connect to ?

We ultimately need our PPC application to connect to a
number of different databases without using ASA8 as an
intermediate step. For example we need our PPC applications
to connect to a SQL Server corporate database and be
able to read and write to it. There is absolutely now way we
can add X number of dollars to the price of a product
(that only costs $100) and expect customers to pay for it.

We will quickly be throwing PPB in the garbage if this is
going to be a long term limitation.

Any info would be appreciated.
Thanks.


Dean Jones [TeamSybase] Posted on 2003-09-23 20:14:18.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 47
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: <3f70aa2f$1@forums-2-dub>
X-Original-Trace: 23 Sep 2003 13:16:47 -0700, dsl130.outtech.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Sep 2003 13:10:11 -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:14:18 -0700
X-Trace: forums-1-dub 1064348058 10.22.108.75 (23 Sep 2003 13:14:18 -0700)
X-Original-Trace: 23 Sep 2003 13:14:18 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:539
Article PK: 267072

What other solutions are you looking at and what db do they connect to?

Currently PPB connects to ASA as a remote database. Do any of these
corporate databases you want to connect to have drivers that run on the
PocketPC?

I believe you can hand code everything using J2ME. But this is slow and
takes time, but if its a commercial product it might be needed.

can you give us more info on what you want to do?

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

"Dave Pylatuk" <davep@centurysystems.net> wrote in message
news:3f70a390@forums-2-dub...
> Hello.
>
> I have seen a number of posts regarding synchronization etc,
> to a corporate database. Can anyone provide an overall
> summary of what PocketPB can and can not connect to ?
>
> We ultimately need our PPC application to connect to a
> number of different databases without using ASA8 as an
> intermediate step. For example we need our PPC applications
> to connect to a SQL Server corporate database and be
> able to read and write to it. There is absolutely now way we
> can add X number of dollars to the price of a product
> (that only costs $100) and expect customers to pay for it.
>
> We will quickly be throwing PPB in the garbage if this is
> going to be a long term limitation.
>
> Any info would be appreciated.
> Thanks.
>
>


Dave Pylatuk Posted on 2003-09-23 20:41:24.0Z
From: "Dave Pylatuk" <davep@centurysystems.net>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub> <3f70aa2f$1@forums-2-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 97
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: <3f70aff4$1@forums-1-dub>
Date: 23 Sep 2003 13:41:24 -0700
X-Trace: forums-1-dub 1064349684 216.209.35.102 (23 Sep 2003 13:41:24 -0700)
X-Original-Trace: 23 Sep 2003 13:41:24 -0700, 216.209.35.102
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:541
Article PK: 267075

Sure, I can clarify. Thanks for replying.

We build data collection software for a number of industries, primarily
the mining industry. Many of these clients collect data in very harsh
environments. Deserts and Jungles in Africa, Underground mines all
over the world, South America, Northern Canada...

Up until now our PB applications have run on the Win32 platform and
are written in PB65, recently migrated to PB8 this year. Most of the data
collection has been done on Pen computers with harsh cases etc for the
harsh environments. Our basic arcitecthure is as follows:

PB App, on Desktop or Pen computer ----data moves to--> SQL Server or
Oracle
(SQL Anywhere, ASA)
(Central corporate DB)

We have built many Palm on which the users have a 'skeleton' version of our
data collection software. They come back to the office, click hotsync and
the
data goes to the same SQL Server or Oracle central DB. These Palm apps
are simple but work well. Our clients (plus us) want to move to the PocketPC
environment. We have a lot company experience with PB and want to make use
of it, hence PocketPB.

When our desktop PB apps need to move data from ASA to any other odbc
database, we make one single call to a DLL file (written internally) that
moves
data from a table in any source DB to a table in any destination DB. It is
fantastic.
With one call 'DataMove(source_dsn, source_table, dest_dsn, dest_table) the
data is moved and it is fast. There are other parameters for this call to
control
how data is moved, by default it matches column names in source_table and
dest_table to move data.

(Sorry for the long explaination)

But basically we need to retain this architecture:
HandHeld_Device ---data---> Central database (Typically SQL Server or
Oracle)

and were hoping to do it with PB.

Thanks for your time.

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f70aa2f$1@forums-2-dub...
> What other solutions are you looking at and what db do they connect to?
>
> Currently PPB connects to ASA as a remote database. Do any of these
> corporate databases you want to connect to have drivers that run on the
> PocketPC?
>
> I believe you can hand code everything using J2ME. But this is slow and
> takes time, but if its a commercial product it might be needed.
>
> can you give us more info on what you want to do?
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> news:3f70a390@forums-2-dub...
> > Hello.
> >
> > I have seen a number of posts regarding synchronization etc,
> > to a corporate database. Can anyone provide an overall
> > summary of what PocketPB can and can not connect to ?
> >
> > We ultimately need our PPC application to connect to a
> > number of different databases without using ASA8 as an
> > intermediate step. For example we need our PPC applications
> > to connect to a SQL Server corporate database and be
> > able to read and write to it. There is absolutely now way we
> > can add X number of dollars to the price of a product
> > (that only costs $100) and expect customers to pay for it.
> >
> > We will quickly be throwing PPB in the garbage if this is
> > going to be a long term limitation.
> >
> > Any info would be appreciated.
> > Thanks.
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-09-24 13:32:38.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub> <3f70aa2f$1@forums-2-dub> <3f70aff4$1@forums-1-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 130
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: <3f719cf6$1@forums-1-dub>
Date: 24 Sep 2003 06:32:38 -0700
X-Trace: forums-1-dub 1064410358 216.207.144.172 (24 Sep 2003 06:32:38 -0700)
X-Original-Trace: 24 Sep 2003 06:32:38 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:548
Article PK: 267082

This seems like a perfect fit with ASA Mobilink.

What database did you use on the Palm?

If you are syncing data from the Pen computer to the consolidated database
you must already be licensing ASA for the pen computer so you have use of
Mobilink. You need to get an ASA license for each device and its fast and
easy to setup Mobilink.

Where do you purchase your hardware? Are you planning on using Symbol
devices? My company is a Symbol partner as well as a iAnywhere partner and
we can give you very aggressive pricing if you are purchasing hardware and
software from us. Contact me off line if you want to learn more.

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

"Dave Pylatuk" <davep@centurysystems.net> wrote in message
news:3f70aff4$1@forums-1-dub...
> Sure, I can clarify. Thanks for replying.
>
> We build data collection software for a number of industries, primarily
> the mining industry. Many of these clients collect data in very harsh
> environments. Deserts and Jungles in Africa, Underground mines all
> over the world, South America, Northern Canada...
>
> Up until now our PB applications have run on the Win32 platform and
> are written in PB65, recently migrated to PB8 this year. Most of the data
> collection has been done on Pen computers with harsh cases etc for the
> harsh environments. Our basic arcitecthure is as follows:
>
> PB App, on Desktop or Pen computer ----data moves to--> SQL Server or
> Oracle
> (SQL Anywhere, ASA)
> (Central corporate DB)
>
> We have built many Palm on which the users have a 'skeleton' version of
our
> data collection software. They come back to the office, click hotsync and
> the
> data goes to the same SQL Server or Oracle central DB. These Palm apps
> are simple but work well. Our clients (plus us) want to move to the
PocketPC
> environment. We have a lot company experience with PB and want to make use
> of it, hence PocketPB.
>
> When our desktop PB apps need to move data from ASA to any other odbc
> database, we make one single call to a DLL file (written internally) that
> moves
> data from a table in any source DB to a table in any destination DB. It is
> fantastic.
> With one call 'DataMove(source_dsn, source_table, dest_dsn, dest_table)
the
> data is moved and it is fast. There are other parameters for this call to
> control
> how data is moved, by default it matches column names in source_table and
> dest_table to move data.
>
> (Sorry for the long explaination)
>
> But basically we need to retain this architecture:
> HandHeld_Device ---data---> Central database (Typically SQL Server or
> Oracle)
>
> and were hoping to do it with PB.
>
> Thanks for your time.
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f70aa2f$1@forums-2-dub...
> > What other solutions are you looking at and what db do they connect to?
> >
> > Currently PPB connects to ASA as a remote database. Do any of these
> > corporate databases you want to connect to have drivers that run on the
> > PocketPC?
> >
> > I believe you can hand code everything using J2ME. But this is slow and
> > takes time, but if its a commercial product it might be needed.
> >
> > can you give us more info on what you want to do?
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > news:3f70a390@forums-2-dub...
> > > Hello.
> > >
> > > I have seen a number of posts regarding synchronization etc,
> > > to a corporate database. Can anyone provide an overall
> > > summary of what PocketPB can and can not connect to ?
> > >
> > > We ultimately need our PPC application to connect to a
> > > number of different databases without using ASA8 as an
> > > intermediate step. For example we need our PPC applications
> > > to connect to a SQL Server corporate database and be
> > > able to read and write to it. There is absolutely now way we
> > > can add X number of dollars to the price of a product
> > > (that only costs $100) and expect customers to pay for it.
> > >
> > > We will quickly be throwing PPB in the garbage if this is
> > > going to be a long term limitation.
> > >
> > > Any info would be appreciated.
> > > Thanks.
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-24 10:56:33.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 41
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: <3f7178f7$1@forums-2-dub>
X-Original-Trace: 24 Sep 2003 03:59:03 -0700, www.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Sep 2003 03:52:21 -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:56:33 -0700
X-Trace: forums-1-dub 1064400993 10.22.108.75 (24 Sep 2003 03:56:33 -0700)
X-Original-Trace: 24 Sep 2003 03:56:33 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:545
Article PK: 267078

Dave;

I have created my own data synchronization utility using PowerBuilder
Enterprise version 9. It uses DataWindow and Pipeline objects to move data
both ways to and from an ASA database. The corporate (target) database can
be anything that PB 9 connects to (i.e.: Oracle, SQLServer, MS-SQLServer,
DB/2, Informix, Ingress, ASA, MySQL, etc).

The only limitation with this utility is that the PDA must have an
active WIFI "Active-Sync" session or, be cradled.

Regards ... Chris
Great White North Technical Evangelist

"Dave Pylatuk" <davep@centurysystems.net> wrote in message
news:3f70a390@forums-2-dub...
> Hello.
>
> I have seen a number of posts regarding synchronization etc,
> to a corporate database. Can anyone provide an overall
> summary of what PocketPB can and can not connect to ?
>
> We ultimately need our PPC application to connect to a
> number of different databases without using ASA8 as an
> intermediate step. For example we need our PPC applications
> to connect to a SQL Server corporate database and be
> able to read and write to it. There is absolutely now way we
> can add X number of dollars to the price of a product
> (that only costs $100) and expect customers to pay for it.
>
> We will quickly be throwing PPB in the garbage if this is
> going to be a long term limitation.
>
> Any info would be appreciated.
> Thanks.
>
>


Dean Jones [TeamSybase] Posted on 2003-09-24 14:03:33.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub> <3f7178f7$1@forums-2-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 60
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: <3f71a435$1@forums-1-dub>
Date: 24 Sep 2003 07:03:33 -0700
X-Trace: forums-1-dub 1064412213 216.207.144.172 (24 Sep 2003 07:03:33 -0700)
X-Original-Trace: 24 Sep 2003 07:03:33 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:552
Article PK: 267086

Have you done this? It would work from a desktop client because the desktop
has drivers for the other databases. The PPC does not have drivers for the
other databases. So I have no idea how you can make this work.

--
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:3f7178f7$1@forums-2-dub...
> Dave;
>
> I have created my own data synchronization utility using PowerBuilder
> Enterprise version 9. It uses DataWindow and Pipeline objects to move data
> both ways to and from an ASA database. The corporate (target) database can
> be anything that PB 9 connects to (i.e.: Oracle, SQLServer, MS-SQLServer,
> DB/2, Informix, Ingress, ASA, MySQL, etc).
>
> The only limitation with this utility is that the PDA must have an
> active WIFI "Active-Sync" session or, be cradled.
>
> Regards ... Chris
> Great White North Technical Evangelist
>
>
>
> "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> news:3f70a390@forums-2-dub...
> > Hello.
> >
> > I have seen a number of posts regarding synchronization etc,
> > to a corporate database. Can anyone provide an overall
> > summary of what PocketPB can and can not connect to ?
> >
> > We ultimately need our PPC application to connect to a
> > number of different databases without using ASA8 as an
> > intermediate step. For example we need our PPC applications
> > to connect to a SQL Server corporate database and be
> > able to read and write to it. There is absolutely now way we
> > can add X number of dollars to the price of a product
> > (that only costs $100) and expect customers to pay for it.
> >
> > We will quickly be throwing PPB in the garbage if this is
> > going to be a long term limitation.
> >
> > Any info would be appreciated.
> > Thanks.
> >
> >
>
>


Chris Pollach Posted on 2003-09-24 14:19:22.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub> <3f7178f7$1@forums-2-dub> <3f71a435$1@forums-1-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 72
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: listserv.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: listserv.scc-csc.gc.ca
Message-ID: <3f71a7ea@forums-1-dub>
Date: 24 Sep 2003 07:19:22 -0700
X-Trace: forums-1-dub 1064413162 209.47.227.131 (24 Sep 2003 07:19:22 -0700)
X-Original-Trace: 24 Sep 2003 07:19:22 -0700, listserv.scc-csc.gc.ca
X-Authenticated-User: PPBBeta11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:553
Article PK: 267087

Yes ... it has been in production since August 12th!

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f71a435$1@forums-1-dub...
> Have you done this? It would work from a desktop client because the
desktop
> has drivers for the other databases. The PPC does not have drivers for the
> other databases. So I have no idea how you can make this work.
>
> --
> 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:3f7178f7$1@forums-2-dub...
> > Dave;
> >
> > I have created my own data synchronization utility using
PowerBuilder
> > Enterprise version 9. It uses DataWindow and Pipeline objects to move
data
> > both ways to and from an ASA database. The corporate (target) database
can
> > be anything that PB 9 connects to (i.e.: Oracle, SQLServer,
MS-SQLServer,
> > DB/2, Informix, Ingress, ASA, MySQL, etc).
> >
> > The only limitation with this utility is that the PDA must have an
> > active WIFI "Active-Sync" session or, be cradled.
> >
> > Regards ... Chris
> > Great White North Technical Evangelist
> >
> >
> >
> > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > news:3f70a390@forums-2-dub...
> > > Hello.
> > >
> > > I have seen a number of posts regarding synchronization etc,
> > > to a corporate database. Can anyone provide an overall
> > > summary of what PocketPB can and can not connect to ?
> > >
> > > We ultimately need our PPC application to connect to a
> > > number of different databases without using ASA8 as an
> > > intermediate step. For example we need our PPC applications
> > > to connect to a SQL Server corporate database and be
> > > able to read and write to it. There is absolutely now way we
> > > can add X number of dollars to the price of a product
> > > (that only costs $100) and expect customers to pay for it.
> > >
> > > We will quickly be throwing PPB in the garbage if this is
> > > going to be a long term limitation.
> > >
> > > Any info would be appreciated.
> > > Thanks.
> > >
> > >
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-09-24 15:04:51.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub> <3f7178f7$1@forums-2-dub> <3f71a435$1@forums-1-dub> <3f71a7ea@forums-1-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 92
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: <3f71b32a$1@forums-2-dub>
X-Original-Trace: 24 Sep 2003 08:07:22 -0700, 216.207.144.172
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Sep 2003 08:00:38 -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:04:51 -0700
X-Trace: forums-1-dub 1064415891 10.22.108.75 (24 Sep 2003 08:04:51 -0700)
X-Original-Trace: 24 Sep 2003 08:04:51 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:559
Article PK: 267092

A PocketPC device running Pocket PowerBuilder connecting to Oracle? Where
did you get Oracle drivers for the PocketPC device?

--
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:3f71a7ea@forums-1-dub...
> Yes ... it has been in production since August 12th!
>
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f71a435$1@forums-1-dub...
> > Have you done this? It would work from a desktop client because the
> desktop
> > has drivers for the other databases. The PPC does not have drivers for
the
> > other databases. So I have no idea how you can make this work.
> >
> > --
> > 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:3f7178f7$1@forums-2-dub...
> > > Dave;
> > >
> > > I have created my own data synchronization utility using
> PowerBuilder
> > > Enterprise version 9. It uses DataWindow and Pipeline objects to move
> data
> > > both ways to and from an ASA database. The corporate (target) database
> can
> > > be anything that PB 9 connects to (i.e.: Oracle, SQLServer,
> MS-SQLServer,
> > > DB/2, Informix, Ingress, ASA, MySQL, etc).
> > >
> > > The only limitation with this utility is that the PDA must have an
> > > active WIFI "Active-Sync" session or, be cradled.
> > >
> > > Regards ... Chris
> > > Great White North Technical Evangelist
> > >
> > >
> > >
> > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > news:3f70a390@forums-2-dub...
> > > > Hello.
> > > >
> > > > I have seen a number of posts regarding synchronization etc,
> > > > to a corporate database. Can anyone provide an overall
> > > > summary of what PocketPB can and can not connect to ?
> > > >
> > > > We ultimately need our PPC application to connect to a
> > > > number of different databases without using ASA8 as an
> > > > intermediate step. For example we need our PPC applications
> > > > to connect to a SQL Server corporate database and be
> > > > able to read and write to it. There is absolutely now way we
> > > > can add X number of dollars to the price of a product
> > > > (that only costs $100) and expect customers to pay for it.
> > > >
> > > > We will quickly be throwing PPB in the garbage if this is
> > > > going to be a long term limitation.
> > > >
> > > > Any info would be appreciated.
> > > > Thanks.
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-24 15:07:22.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub> <3f7178f7$1@forums-2-dub> <3f71a435$1@forums-1-dub> <3f71a7ea@forums-1-dub> <3f71b32a$1@forums-2-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 105
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: <3f71b32a$1@forums-1-dub>
Date: 24 Sep 2003 08:07:22 -0700
X-Trace: forums-1-dub 1064416042 209.47.227.130 (24 Sep 2003 08:07:22 -0700)
X-Original-Trace: 24 Sep 2003 08:07:22 -0700, firewall.scc-csc.gc.ca
X-Authenticated-User: PPBBeta11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:560
Article PK: 267093

Dean ... get Pocket PB out of the equation!
I am using PowerBuilder Enterprise version 9.0.1

regards ... Chris

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f71b32a$1@forums-2-dub...
> A PocketPC device running Pocket PowerBuilder connecting to Oracle? Where
> did you get Oracle drivers for the PocketPC device?
>
> --
> 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:3f71a7ea@forums-1-dub...
> > Yes ... it has been in production since August 12th!
> >
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f71a435$1@forums-1-dub...
> > > Have you done this? It would work from a desktop client because the
> > desktop
> > > has drivers for the other databases. The PPC does not have drivers for
> the
> > > other databases. So I have no idea how you can make this work.
> > >
> > > --
> > > 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:3f7178f7$1@forums-2-dub...
> > > > Dave;
> > > >
> > > > I have created my own data synchronization utility using
> > PowerBuilder
> > > > Enterprise version 9. It uses DataWindow and Pipeline objects to
move
> > data
> > > > both ways to and from an ASA database. The corporate (target)
database
> > can
> > > > be anything that PB 9 connects to (i.e.: Oracle, SQLServer,
> > MS-SQLServer,
> > > > DB/2, Informix, Ingress, ASA, MySQL, etc).
> > > >
> > > > The only limitation with this utility is that the PDA must have
an
> > > > active WIFI "Active-Sync" session or, be cradled.
> > > >
> > > > Regards ... Chris
> > > > Great White North Technical Evangelist
> > > >
> > > >
> > > >
> > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > news:3f70a390@forums-2-dub...
> > > > > Hello.
> > > > >
> > > > > I have seen a number of posts regarding synchronization etc,
> > > > > to a corporate database. Can anyone provide an overall
> > > > > summary of what PocketPB can and can not connect to ?
> > > > >
> > > > > We ultimately need our PPC application to connect to a
> > > > > number of different databases without using ASA8 as an
> > > > > intermediate step. For example we need our PPC applications
> > > > > to connect to a SQL Server corporate database and be
> > > > > able to read and write to it. There is absolutely now way we
> > > > > can add X number of dollars to the price of a product
> > > > > (that only costs $100) and expect customers to pay for it.
> > > > >
> > > > > We will quickly be throwing PPB in the garbage if this is
> > > > > going to be a long term limitation.
> > > > >
> > > > > Any info would be appreciated.
> > > > > Thanks.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-09-24 15:16:34.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub> <3f7178f7$1@forums-2-dub> <3f71a435$1@forums-1-dub> <3f71a7ea@forums-1-dub> <3f71b32a$1@forums-2-dub> <3f71b32a$1@forums-1-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 134
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: <3f71b5e7$1@forums-2-dub>
X-Original-Trace: 24 Sep 2003 08:19:03 -0700, 216.207.144.172
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Sep 2003 08:12:21 -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:16:34 -0700
X-Trace: forums-1-dub 1064416594 10.22.108.75 (24 Sep 2003 08:16:34 -0700)
X-Original-Trace: 24 Sep 2003 08:16:34 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:562
Article PK: 267102

Oh... that makes sense. But your post stated:

>>
The only limitation with this utility is that the PDA must have an active
WIFI "Active-Sync" session or, be cradled.
<<

When you stated PDA and Active-Sync I assumed it was a PocketPC device.
Sorry.

--
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:3f71b32a$1@forums-1-dub...
> Dean ... get Pocket PB out of the equation!
> I am using PowerBuilder Enterprise version 9.0.1
>
> regards ... Chris
>
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f71b32a$1@forums-2-dub...
> > A PocketPC device running Pocket PowerBuilder connecting to Oracle?
Where
> > did you get Oracle drivers for the PocketPC device?
> >
> > --
> > 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:3f71a7ea@forums-1-dub...
> > > Yes ... it has been in production since August 12th!
> > >
> > >
> > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > message
> > > news:3f71a435$1@forums-1-dub...
> > > > Have you done this? It would work from a desktop client because the
> > > desktop
> > > > has drivers for the other databases. The PPC does not have drivers
for
> > the
> > > > other databases. So I have no idea how you can make this work.
> > > >
> > > > --
> > > > 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:3f7178f7$1@forums-2-dub...
> > > > > Dave;
> > > > >
> > > > > I have created my own data synchronization utility using
> > > PowerBuilder
> > > > > Enterprise version 9. It uses DataWindow and Pipeline objects to
> move
> > > data
> > > > > both ways to and from an ASA database. The corporate (target)
> database
> > > can
> > > > > be anything that PB 9 connects to (i.e.: Oracle, SQLServer,
> > > MS-SQLServer,
> > > > > DB/2, Informix, Ingress, ASA, MySQL, etc).
> > > > >
> > > > > The only limitation with this utility is that the PDA must
have
> an
> > > > > active WIFI "Active-Sync" session or, be cradled.
> > > > >
> > > > > Regards ... Chris
> > > > > Great White North Technical Evangelist
> > > > >
> > > > >
> > > > >
> > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > news:3f70a390@forums-2-dub...
> > > > > > Hello.
> > > > > >
> > > > > > I have seen a number of posts regarding synchronization etc,
> > > > > > to a corporate database. Can anyone provide an overall
> > > > > > summary of what PocketPB can and can not connect to ?
> > > > > >
> > > > > > We ultimately need our PPC application to connect to a
> > > > > > number of different databases without using ASA8 as an
> > > > > > intermediate step. For example we need our PPC applications
> > > > > > to connect to a SQL Server corporate database and be
> > > > > > able to read and write to it. There is absolutely now way we
> > > > > > can add X number of dollars to the price of a product
> > > > > > (that only costs $100) and expect customers to pay for it.
> > > > > >
> > > > > > We will quickly be throwing PPB in the garbage if this is
> > > > > > going to be a long term limitation.
> > > > > >
> > > > > > Any info would be appreciated.
> > > > > > Thanks.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Chris Pollach Posted on 2003-09-24 16:52:10.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub> <3f7178f7$1@forums-2-dub> <3f71a435$1@forums-1-dub> <3f71a7ea@forums-1-dub> <3f71b32a$1@forums-2-dub> <3f71b32a$1@forums-1-dub> <3f71b5e7$1@forums-2-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 142
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: <3f71cc51$1@forums-2-dub>
X-Original-Trace: 24 Sep 2003 09:54:41 -0700, www.scc-csc.gc.ca
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Sep 2003 09:47:57 -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 09:52:10 -0700
X-Trace: forums-1-dub 1064422330 10.22.108.75 (24 Sep 2003 09:52:10 -0700)
X-Original-Trace: 24 Sep 2003 09:52:10 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:565
Article PK: 267098

Sorry .. That is why I had to emphasize the PPB vs. PB in my last statement
because I thought you might be thinking PDA not the PC level.

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f71b5e7$1@forums-2-dub...
> Oh... that makes sense. But your post stated:
>
> >>
> The only limitation with this utility is that the PDA must have an active
> WIFI "Active-Sync" session or, be cradled.
> <<
>
> When you stated PDA and Active-Sync I assumed it was a PocketPC device.
> Sorry.
>
> --
> 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:3f71b32a$1@forums-1-dub...
> > Dean ... get Pocket PB out of the equation!
> > I am using PowerBuilder Enterprise version 9.0.1
> >
> > regards ... Chris
> >
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f71b32a$1@forums-2-dub...
> > > A PocketPC device running Pocket PowerBuilder connecting to Oracle?
> Where
> > > did you get Oracle drivers for the PocketPC device?
> > >
> > > --
> > > 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:3f71a7ea@forums-1-dub...
> > > > Yes ... it has been in production since August 12th!
> > > >
> > > >
> > > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> > > message
> > > > news:3f71a435$1@forums-1-dub...
> > > > > Have you done this? It would work from a desktop client because
the
> > > > desktop
> > > > > has drivers for the other databases. The PPC does not have drivers
> for
> > > the
> > > > > other databases. So I have no idea how you can make this work.
> > > > >
> > > > > --
> > > > > 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:3f7178f7$1@forums-2-dub...
> > > > > > Dave;
> > > > > >
> > > > > > I have created my own data synchronization utility using
> > > > PowerBuilder
> > > > > > Enterprise version 9. It uses DataWindow and Pipeline objects to
> > move
> > > > data
> > > > > > both ways to and from an ASA database. The corporate (target)
> > database
> > > > can
> > > > > > be anything that PB 9 connects to (i.e.: Oracle, SQLServer,
> > > > MS-SQLServer,
> > > > > > DB/2, Informix, Ingress, ASA, MySQL, etc).
> > > > > >
> > > > > > The only limitation with this utility is that the PDA must
> have
> > an
> > > > > > active WIFI "Active-Sync" session or, be cradled.
> > > > > >
> > > > > > Regards ... Chris
> > > > > > Great White North Technical Evangelist
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
> > > > > > news:3f70a390@forums-2-dub...
> > > > > > > Hello.
> > > > > > >
> > > > > > > I have seen a number of posts regarding synchronization etc,
> > > > > > > to a corporate database. Can anyone provide an overall
> > > > > > > summary of what PocketPB can and can not connect to ?
> > > > > > >
> > > > > > > We ultimately need our PPC application to connect to a
> > > > > > > number of different databases without using ASA8 as an
> > > > > > > intermediate step. For example we need our PPC applications
> > > > > > > to connect to a SQL Server corporate database and be
> > > > > > > able to read and write to it. There is absolutely now way we
> > > > > > > can add X number of dollars to the price of a product
> > > > > > > (that only costs $100) and expect customers to pay for it.
> > > > > > >
> > > > > > > We will quickly be throwing PPB in the garbage if this is
> > > > > > > going to be a long term limitation.
> > > > > > >
> > > > > > > Any info would be appreciated.
> > > > > > > Thanks.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Jun Posted on 2003-09-24 19:29:18.0Z
From: "Jun" <nospam@pocketpbdeveloper.com>
Newsgroups: sybase.public.pocketpowerbuilder
Organization: 129.71.238.253
References: <3f70a390@forums-2-dub> <3f7178f7$1@forums-2-dub> <3f71a435$1@forums-1-dub> <3f71a7ea@forums-1-dub> <3f71b32a$1@forums-2-dub> <3f71b32a$1@forums-1-dub> <3f71b5e7$1@forums-2-dub>
X-Newsreader: AspNNTP 1.50 (Tri Hoang)
Subject: Re: PPB connection to database other than ASA
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: <3f71f125$1@forums-2-dub>
X-Original-Trace: 24 Sep 2003 12:31:49 -0700, transinc-win02.netoptex.com
Lines: 163
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Sep 2003 12:25:04 -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 12:29:18 -0700
X-Trace: forums-1-dub 1064431758 10.22.108.75 (24 Sep 2003 12:29:18 -0700)
X-Original-Trace: 24 Sep 2003 12:29:18 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:567
Article PK: 267099

Let me get straight in understanding the technique used by Chris Pollack. Chris,
you can correct me if I am wrong. This is just what I can possibly think of how
you are doing it.

The PPC device has the runtime files of both the Pocket PB and the restricted
version of royalty free ASA database i.e. no SP, no Trigger, no logging and so
on.

Now, Chris has created a Sync utility as alternative way of using the Mobilink
technology being offered by Sybase for 2 way direct update between a
consolidated corporate database and the remote ASA database residing in PPC
device. The Sync utiity was developed using PowerBuilder 9, can be an Enterprise
or Desktop edition of Powerbuilder.

The PB 9's Sync utility is using the Datawindow and Pipelines technique to sync
the consolidated corporate database and the remote ASA database in PPC. The
utility is smart enough that it can connect to the remote ASA database in PPC
when the PPC device is on the cradle where ActiveSync is to be used or when PPC
device gets a WIFI connection over the network where the consolidated database
connection is also present.

I guess the question is the big 'HOW TO CONNECT TO REMOTE ASA DATABASE in PPC'
from a Powerbuilder application.

My .02 cents.

On 24 Sep 2003 08:16:34 -0700,
in sybase.public.pocketpowerbuilder

Dean Jones [TeamSybase] <dean__remove__@powerobjects.com> wrote:
>Oh... that makes sense. But your post stated:
>
>>>
>The only limitation with this utility is that the PDA must have an active
>WIFI "Active-Sync" session or, be cradled.
><<
>
>When you stated PDA and Active-Sync I assumed it was a PocketPC device.
>Sorry.
>
>--
>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:3f71b32a$1@forums-1-dub...
>> Dean ... get Pocket PB out of the equation!
>> I am using PowerBuilder Enterprise version 9.0.1
>>
>> regards ... Chris
>>
>>
>> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
>message
>> news:3f71b32a$1@forums-2-dub...
>> > A PocketPC device running Pocket PowerBuilder connecting to Oracle?
>Where
>> > did you get Oracle drivers for the PocketPC device?
>> >
>> > --
>> > 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:3f71a7ea@forums-1-dub...
>> > > Yes ... it has been in production since August 12th!
>> > >
>> > >
>> > > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
>> > message
>> > > news:3f71a435$1@forums-1-dub...
>> > > > Have you done this? It would work from a desktop client because the
>> > > desktop
>> > > > has drivers for the other databases. The PPC does not have drivers
>for
>> > the
>> > > > other databases. So I have no idea how you can make this work.
>> > > >
>> > > > --
>> > > > 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:3f7178f7$1@forums-2-dub...
>> > > > > Dave;
>> > > > >
>> > > > > I have created my own data synchronization utility using
>> > > PowerBuilder
>> > > > > Enterprise version 9. It uses DataWindow and Pipeline objects to
>> move
>> > > data
>> > > > > both ways to and from an ASA database. The corporate (target)
>> database
>> > > can
>> > > > > be anything that PB 9 connects to (i.e.: Oracle, SQLServer,
>> > > MS-SQLServer,
>> > > > > DB/2, Informix, Ingress, ASA, MySQL, etc).
>> > > > >
>> > > > > The only limitation with this utility is that the PDA must
>have
>> an
>> > > > > active WIFI "Active-Sync" session or, be cradled.
>> > > > >
>> > > > > Regards ... Chris
>> > > > > Great White North Technical Evangelist
>> > > > >
>> > > > >
>> > > > >
>> > > > > "Dave Pylatuk" <davep@centurysystems.net> wrote in message
>> > > > > news:3f70a390@forums-2-dub...
>> > > > > > Hello.
>> > > > > >
>> > > > > > I have seen a number of posts regarding synchronization etc,
>> > > > > > to a corporate database. Can anyone provide an overall
>> > > > > > summary of what PocketPB can and can not connect to ?
>> > > > > >
>> > > > > > We ultimately need our PPC application to connect to a
>> > > > > > number of different databases without using ASA8 as an
>> > > > > > intermediate step. For example we need our PPC applications
>> > > > > > to connect to a SQL Server corporate database and be
>> > > > > > able to read and write to it. There is absolutely now way we
>> > > > > > can add X number of dollars to the price of a product
>> > > > > > (that only costs $100) and expect customers to pay for it.
>> > > > > >
>> > > > > > We will quickly be throwing PPB in the garbage if this is
>> > > > > > going to be a long term limitation.
>> > > > > >
>> > > > > > Any info would be appreciated.
>> > > > > > Thanks.
>> > > > > >
>> > > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>>
>
>


Martyn Mallick Posted on 2003-09-30 03:51:48.0Z
From: "Martyn Mallick" <mmallick.removethis@ianywhere.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f70a390@forums-2-dub>
Subject: Re: PPB connection to database other than ASA
Lines: 35
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: cpe00045a2682bc-cm.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe00045a2682bc-cm.cpe.net.cable.rogers.com
Message-ID: <3f78fdd4@forums-1-dub>
Date: 29 Sep 2003 20:51:48 -0700
X-Trace: forums-1-dub 1064893908 65.50.167.196 (29 Sep 2003 20:51:48 -0700)
X-Original-Trace: 29 Sep 2003 20:51:48 -0700, cpe00045a2682bc-cm.cpe.net.cable.rogers.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:637
Article PK: 267171

Dave,

I want to reiterate what Dean has stated: The abililty to connect directly
to databases on a server requires an ODBC driver that supports the Pocket PC
environment. This is not a limitation of PPB, or anything that we have
control of. As far as I know, only the ASA ODBC driver currently has this
support...

-Marty

"Dave Pylatuk" <davep@centurysystems.net> wrote in message
news:3f70a390@forums-2-dub...
> Hello.
>
> I have seen a number of posts regarding synchronization etc,
> to a corporate database. Can anyone provide an overall
> summary of what PocketPB can and can not connect to ?
>
> We ultimately need our PPC application to connect to a
> number of different databases without using ASA8 as an
> intermediate step. For example we need our PPC applications
> to connect to a SQL Server corporate database and be
> able to read and write to it. There is absolutely now way we
> can add X number of dollars to the price of a product
> (that only costs $100) and expect customers to pay for it.
>
> We will quickly be throwing PPB in the garbage if this is
> going to be a long term limitation.
>
> Any info would be appreciated.
> Thanks.
>
>