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.

Cradle database connection w/o RF or Sync

10 posts in Pocket PowerBuilder Last posting was on 2003-10-15 15:51:39.0Z
John Owens Posted on 2003-10-06 14:58:37.0Z
Reply-To: "John Owens" <j.owens@stanelyassociates.com>
From: "John Owens" <j.owens@stanleyassociates.com>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Cradle database connection w/o RF or Sync
Lines: 15
Organization: Stanley Associates
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: 12.172.51.130
X-Original-NNTP-Posting-Host: 12.172.51.130
Message-ID: <3f81831d$2@forums-1-dub>
Date: 6 Oct 2003 07:58:37 -0700
X-Trace: forums-1-dub 1065452317 12.172.51.130 (6 Oct 2003 07:58:37 -0700)
X-Original-Trace: 6 Oct 2003 07:58:37 -0700, 12.172.51.130
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:714
Article PK: 267247

Is there a way to connect to a remote database via the cradle without using
RF or synchronization?

I am developing an application which will be deployed in some areas with RF
and some areas without. Thus, batch data storage is used to store barcode
data until either RF is available or until the PDT is placed in the cradle.
So, I need to be able to transfer data from my PDA local database to the
database running on the laptop the cradle is connected to.

If synchonization is the only way, I need to know that as well.

John Owens
Stanley Associates


Dean Jones [TeamSybase] Posted on 2003-10-06 16:09:06.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f81831d$2@forums-1-dub>
Subject: Re: Cradle database connection w/o RF or Sync
Lines: 46
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: <3f8193a2$1@forums-1-dub>
Date: 6 Oct 2003 09:09:06 -0700
X-Trace: forums-1-dub 1065456546 216.207.144.172 (6 Oct 2003 09:09:06 -0700)
X-Original-Trace: 6 Oct 2003 09:09:06 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:716
Article PK: 267249

You can connect directly to a ASA database. You can then use linked tables
to update other non-ASA databases.

I think it would be much easier and much faster to use MobiLink to sync the
data to a backend database.

If you move data from the PDA to backend database you must license the ASA
database on the PDA. So you have either options available at the same cost.
If you use a MobiLink option it will be the same process for all users,
store and forward. Sync when you are connected.

HTH

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

"John Owens" <j.owens@stanleyassociates.com> wrote in message
news:3f81831d$2@forums-1-dub...
> Is there a way to connect to a remote database via the cradle without
using
> RF or synchronization?
>
> I am developing an application which will be deployed in some areas with
RF
> and some areas without. Thus, batch data storage is used to store barcode
> data until either RF is available or until the PDT is placed in the
cradle.
> So, I need to be able to transfer data from my PDA local database to the
> database running on the laptop the cradle is connected to.
>
> If synchonization is the only way, I need to know that as well.
>
> John Owens
> Stanley Associates
>
>


John Owens Posted on 2003-10-08 04:39:15.0Z
Sender: bda.3f83956d.1804289383@sybase.com
From: John Owens
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Re: Cradle database connection w/o RF or Sync
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f8395bb.bdc.846930886@sybase.com>
References: <3f81831d$2@forums-1-dub><3f8193a2$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 7 Oct 2003 21:42:35 -0700, 10.22.241.42
Lines: 68
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 7 Oct 2003 21:33:44 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 7 Oct 2003 21:39:15 -0700
X-Trace: forums-1-dub 1065587955 10.22.108.75 (7 Oct 2003 21:39:15 -0700)
X-Original-Trace: 7 Oct 2003 21:39:15 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:789
Article PK: 268091

I'll get to the sync later, i'm curious on standard
user-selected data transfers at a specific point of time.

Ok say I am connected via cradle and I have a database
running locally (dbeng8.exe) on the laptop it is connected
to. How can I....

1) Grab table X from the laptop database and put it in the
PDA ASA database table Y.

2) Send table Z's data from the PDA to the locally running
database on the laptop.

This also stems into another seperate question:
I can easily connect to a server database running
(dbsrv8.exe) on the network via RF, but can I connect to a
"local" database (dbeng8.exe) running on a laptop if that
laptop is running a RF card or must is run in server mode?

John Owens

> You can connect directly to a ASA database. You can then
> use linked tables to update other non-ASA databases.
>
> I think it would be much easier and much faster to use
> MobiLink to sync the data to a backend database.
>
> If you move data from the PDA to backend database you must
> license the ASA database on the PDA. So you have either
> options available at the same cost. If you use a MobiLink
> option it will be the same process for all users, store
> and forward. Sync when you are connected.
>
> HTH
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "John Owens" <j.owens@stanleyassociates.com> wrote in
> message news:3f81831d$2@forums-1-dub...
> > Is there a way to connect to a remote database via the
> cradle without using
> > RF or synchronization?
> >
> > I am developing an application which will be deployed in
> some areas with RF
> > and some areas without. Thus, batch data storage is
> > used to store barcode data until either RF is available
> or until the PDT is placed in the cradle.
> > So, I need to be able to transfer data from my PDA local
> > database to the database running on the laptop the
> cradle is connected to. >
> > If synchonization is the only way, I need to know that
> as well. >
> > John Owens
> > Stanley Associates
> >
> >
>
>


Dean Jones [TeamSybase] Posted on 2003-10-08 13:30:37.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f81831d$2@forums-1-dub><3f8193a2$1@forums-1-dub> <3f8395bb.bdc.846930886@sybase.com>
Subject: Re: Cradle database connection w/o RF or Sync
Lines: 101
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: <3f84117d$1@forums-1-dub>
Date: 8 Oct 2003 06:30:37 -0700
X-Trace: forums-1-dub 1065619837 216.207.144.172 (8 Oct 2003 06:30:37 -0700)
X-Original-Trace: 8 Oct 2003 06:30:37 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:795
Article PK: 268097

See below.

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

<John Owens> wrote in message news:3f8395bb.bdc.846930886@sybase.com...
> I'll get to the sync later, i'm curious on standard
> user-selected data transfers at a specific point of time.
>
> Ok say I am connected via cradle and I have a database
> running locally (dbeng8.exe) on the laptop it is connected
> to. How can I....
>
> 1) Grab table X from the laptop database and put it in the
> PDA ASA database table Y.

You can use MobiLink or SQL Remote or manully code it. I can create a
connection to the notebook database retrieve data into a data store, move
data into a new datastore and insert it into the new table in the PDA
database.



> 2) Send table Z's data from the PDA to the locally running
> database on the laptop.

Same thing as answer 1.



> This also stems into another seperate question:
> I can easily connect to a server database running
> (dbsrv8.exe) on the network via RF, but can I connect to a
> "local" database (dbeng8.exe) running on a laptop if that
> laptop is running a RF card or must is run in server mode?

I would have to try it. We have always used the server engine. for the
consolidated database.

HTH


> John Owens
>
> > You can connect directly to a ASA database. You can then
> > use linked tables to update other non-ASA databases.
> >
> > I think it would be much easier and much faster to use
> > MobiLink to sync the data to a backend database.
> >
> > If you move data from the PDA to backend database you must
> > license the ASA database on the PDA. So you have either
> > options available at the same cost. If you use a MobiLink
> > option it will be the same process for all users, store
> > and forward. Sync when you are connected.
> >
> > HTH
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > "John Owens" <j.owens@stanleyassociates.com> wrote in
> > message news:3f81831d$2@forums-1-dub...
> > > Is there a way to connect to a remote database via the
> > cradle without using
> > > RF or synchronization?
> > >
> > > I am developing an application which will be deployed in
> > some areas with RF
> > > and some areas without. Thus, batch data storage is
> > > used to store barcode data until either RF is available
> > or until the PDT is placed in the cradle.
> > > So, I need to be able to transfer data from my PDA local
> > > database to the database running on the laptop the
> > cradle is connected to. >
> > > If synchonization is the only way, I need to know that
> > as well. >
> > > John Owens
> > > Stanley Associates
> > >
> > >
> >
> >


John Owens Posted on 2003-10-08 19:58:13.0Z
Reply-To: "John Owens" <j.owens@stanelyassociates.com>
From: "John Owens" <j.owens@stanleyassociates.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f81831d$2@forums-1-dub><3f8193a2$1@forums-1-dub> <3f8395bb.bdc.846930886@sybase.com> <3f84117d$1@forums-1-dub>
Subject: Re: Cradle database connection w/o RF or Sync
Lines: 120
Organization: Stanley Associates
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: 12.172.51.130
X-Original-NNTP-Posting-Host: 12.172.51.130
Message-ID: <3f846c55$1@forums-1-dub>
Date: 8 Oct 2003 12:58:13 -0700
X-Trace: forums-1-dub 1065643093 12.172.51.130 (8 Oct 2003 12:58:13 -0700)
X-Original-Trace: 8 Oct 2003 12:58:13 -0700, 12.172.51.130
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:806
Article PK: 268105


> This also stems into another seperate question:
> I can easily connect to a server database running
> (dbsrv8.exe) on the network via RF, but can I connect to a
> "local" database (dbeng8.exe) running on a laptop if that
> laptop is running a RF card or must is run in server mode?

>I would have to try it. We have always used the server engine. for the
>consolidated database.

Let me know if you find out anything about this.

Thanks,
John Owens


"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f84117d$1@forums-1-dub...
> See below.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> <John Owens> wrote in message news:3f8395bb.bdc.846930886@sybase.com...
> > I'll get to the sync later, i'm curious on standard
> > user-selected data transfers at a specific point of time.
> >
> > Ok say I am connected via cradle and I have a database
> > running locally (dbeng8.exe) on the laptop it is connected
> > to. How can I....
> >
> > 1) Grab table X from the laptop database and put it in the
> > PDA ASA database table Y.
>
> You can use MobiLink or SQL Remote or manully code it. I can create a
> connection to the notebook database retrieve data into a data store, move
> data into a new datastore and insert it into the new table in the PDA
> database.
>
>
>
> > 2) Send table Z's data from the PDA to the locally running
> > database on the laptop.
>
> Same thing as answer 1.
>
>
>
> > This also stems into another seperate question:
> > I can easily connect to a server database running
> > (dbsrv8.exe) on the network via RF, but can I connect to a
> > "local" database (dbeng8.exe) running on a laptop if that
> > laptop is running a RF card or must is run in server mode?
>
> I would have to try it. We have always used the server engine. for the
> consolidated database.
>
> HTH
>
>
> > John Owens
> >
> > > You can connect directly to a ASA database. You can then
> > > use linked tables to update other non-ASA databases.
> > >
> > > I think it would be much easier and much faster to use
> > > MobiLink to sync the data to a backend database.
> > >
> > > If you move data from the PDA to backend database you must
> > > license the ASA database on the PDA. So you have either
> > > options available at the same cost. If you use a MobiLink
> > > option it will be the same process for all users, store
> > > and forward. Sync when you are connected.
> > >
> > > HTH
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > "John Owens" <j.owens@stanleyassociates.com> wrote in
> > > message news:3f81831d$2@forums-1-dub...
> > > > Is there a way to connect to a remote database via the
> > > cradle without using
> > > > RF or synchronization?
> > > >
> > > > I am developing an application which will be deployed in
> > > some areas with RF
> > > > and some areas without. Thus, batch data storage is
> > > > used to store barcode data until either RF is available
> > > or until the PDT is placed in the cradle.
> > > > So, I need to be able to transfer data from my PDA local
> > > > database to the database running on the laptop the
> > > cradle is connected to. >
> > > > If synchonization is the only way, I need to know that
> > > as well. >
> > > > John Owens
> > > > Stanley Associates
> > > >
> > > >
> > >
> > >
>
>


John Owens Posted on 2003-10-08 19:56:26.0Z
Reply-To: "John Owens" <j.owens@stanelyassociates.com>
From: "John Owens" <j.owens@stanleyassociates.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f81831d$2@forums-1-dub><3f8193a2$1@forums-1-dub> <3f8395bb.bdc.846930886@sybase.com> <3f84117d$1@forums-1-dub>
Subject: Re: Cradle database connection w/o RF or Sync
Lines: 110
Organization: Stanley Associates
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: 12.172.51.130
X-Original-NNTP-Posting-Host: 12.172.51.130
Message-ID: <3f846bea$1@forums-1-dub>
Date: 8 Oct 2003 12:56:26 -0700
X-Trace: forums-1-dub 1065642986 12.172.51.130 (8 Oct 2003 12:56:26 -0700)
X-Original-Trace: 8 Oct 2003 12:56:26 -0700, 12.172.51.130
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:805
Article PK: 268107

How would you make a DSN connection to a database thorough the cradle
manually?

I will look into MobilLink and SQL Remote

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f84117d$1@forums-1-dub...
> See below.
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> <John Owens> wrote in message news:3f8395bb.bdc.846930886@sybase.com...
> > I'll get to the sync later, i'm curious on standard
> > user-selected data transfers at a specific point of time.
> >
> > Ok say I am connected via cradle and I have a database
> > running locally (dbeng8.exe) on the laptop it is connected
> > to. How can I....
> >
> > 1) Grab table X from the laptop database and put it in the
> > PDA ASA database table Y.
>
> You can use MobiLink or SQL Remote or manully code it. I can create a
> connection to the notebook database retrieve data into a data store, move
> data into a new datastore and insert it into the new table in the PDA
> database.
>
>
>
> > 2) Send table Z's data from the PDA to the locally running
> > database on the laptop.
>
> Same thing as answer 1.
>
>
>
> > This also stems into another seperate question:
> > I can easily connect to a server database running
> > (dbsrv8.exe) on the network via RF, but can I connect to a
> > "local" database (dbeng8.exe) running on a laptop if that
> > laptop is running a RF card or must is run in server mode?
>
> I would have to try it. We have always used the server engine. for the
> consolidated database.
>
> HTH
>
>
> > John Owens
> >
> > > You can connect directly to a ASA database. You can then
> > > use linked tables to update other non-ASA databases.
> > >
> > > I think it would be much easier and much faster to use
> > > MobiLink to sync the data to a backend database.
> > >
> > > If you move data from the PDA to backend database you must
> > > license the ASA database on the PDA. So you have either
> > > options available at the same cost. If you use a MobiLink
> > > option it will be the same process for all users, store
> > > and forward. Sync when you are connected.
> > >
> > > HTH
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > "John Owens" <j.owens@stanleyassociates.com> wrote in
> > > message news:3f81831d$2@forums-1-dub...
> > > > Is there a way to connect to a remote database via the
> > > cradle without using
> > > > RF or synchronization?
> > > >
> > > > I am developing an application which will be deployed in
> > > some areas with RF
> > > > and some areas without. Thus, batch data storage is
> > > > used to store barcode data until either RF is available
> > > or until the PDT is placed in the cradle.
> > > > So, I need to be able to transfer data from my PDA local
> > > > database to the database running on the laptop the
> > > cradle is connected to. >
> > > > If synchonization is the only way, I need to know that
> > > as well. >
> > > > John Owens
> > > > Stanley Associates
> > > >
> > > >
> > >
> > >
>
>


Dean Jones [TeamSybase] Posted on 2003-10-09 13:41:43.0Z
From: "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f81831d$2@forums-1-dub><3f8193a2$1@forums-1-dub> <3f8395bb.bdc.846930886@sybase.com> <3f84117d$1@forums-1-dub> <3f846bea$1@forums-1-dub>
Subject: Re: Cradle database connection w/o RF or Sync
Lines: 136
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: <3f856597$1@forums-1-dub>
Date: 9 Oct 2003 06:41:43 -0700
X-Trace: forums-1-dub 1065706903 216.207.144.172 (9 Oct 2003 06:41:43 -0700)
X-Original-Trace: 9 Oct 2003 06:41:43 -0700, 216.207.144.172
X-Authenticated-User: teamps
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:816
Article PK: 268118

Does this help?

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

"John Owens" <j.owens@stanleyassociates.com> wrote in message
news:3f846bea$1@forums-1-dub...
> How would you make a DSN connection to a database thorough the cradle
> manually?
>
> I will look into MobilLink and SQL Remote
>
> "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
message
> news:3f84117d$1@forums-1-dub...
> > See below.
> >
> > --
> > Dean Jones [TeamSybase]
> > CEO
> > PowerObjects
> > http://www.powerobjects.com
> > (612) 339-3355 ext 112
> >
> >
> >
> >
> >
> > <John Owens> wrote in message news:3f8395bb.bdc.846930886@sybase.com...
> > > I'll get to the sync later, i'm curious on standard
> > > user-selected data transfers at a specific point of time.
> > >
> > > Ok say I am connected via cradle and I have a database
> > > running locally (dbeng8.exe) on the laptop it is connected
> > > to. How can I....
> > >
> > > 1) Grab table X from the laptop database and put it in the
> > > PDA ASA database table Y.
> >
> > You can use MobiLink or SQL Remote or manully code it. I can create a
> > connection to the notebook database retrieve data into a data store,
move
> > data into a new datastore and insert it into the new table in the PDA
> > database.
> >
> >
> >
> > > 2) Send table Z's data from the PDA to the locally running
> > > database on the laptop.
> >
> > Same thing as answer 1.
> >
> >
> >
> > > This also stems into another seperate question:
> > > I can easily connect to a server database running
> > > (dbsrv8.exe) on the network via RF, but can I connect to a
> > > "local" database (dbeng8.exe) running on a laptop if that
> > > laptop is running a RF card or must is run in server mode?
> >
> > I would have to try it. We have always used the server engine. for the
> > consolidated database.
> >
> > HTH
> >
> >
> > > John Owens
> > >
> > > > You can connect directly to a ASA database. You can then
> > > > use linked tables to update other non-ASA databases.
> > > >
> > > > I think it would be much easier and much faster to use
> > > > MobiLink to sync the data to a backend database.
> > > >
> > > > If you move data from the PDA to backend database you must
> > > > license the ASA database on the PDA. So you have either
> > > > options available at the same cost. If you use a MobiLink
> > > > option it will be the same process for all users, store
> > > > and forward. Sync when you are connected.
> > > >
> > > > HTH
> > > >
> > > > --
> > > > Dean Jones [TeamSybase]
> > > > CEO
> > > > PowerObjects
> > > > http://www.powerobjects.com
> > > > (612) 339-3355 ext 112
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "John Owens" <j.owens@stanleyassociates.com> wrote in
> > > > message news:3f81831d$2@forums-1-dub...
> > > > > Is there a way to connect to a remote database via the
> > > > cradle without using
> > > > > RF or synchronization?
> > > > >
> > > > > I am developing an application which will be deployed in
> > > > some areas with RF
> > > > > and some areas without. Thus, batch data storage is
> > > > > used to store barcode data until either RF is available
> > > > or until the PDT is placed in the cradle.
> > > > > So, I need to be able to transfer data from my PDA local
> > > > > database to the database running on the laptop the
> > > > cradle is connected to. >
> > > > > If synchonization is the only way, I need to know that
> > > > as well. >
> > > > > John Owens
> > > > > Stanley Associates
> > > > >
> > > > >
> > > >
> > > >
> >
> >
>
>


John Owens Posted on 2003-10-15 15:51:39.0Z
Reply-To: "John Owens" <j.owens@stanelyassociates.com>
From: "John Owens" <j.owens@stanleyassociates.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f81831d$2@forums-1-dub><3f8193a2$1@forums-1-dub> <3f8395bb.bdc.846930886@sybase.com> <3f84117d$1@forums-1-dub> <3f846bea$1@forums-1-dub> <3f856597$1@forums-1-dub>
Subject: Re: Cradle database connection w/o RF or Sync
Lines: 154
Organization: Stanley Associates
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: 12.172.51.130
Message-ID: <3f8d6de9$1@forums-2-dub>
X-Original-Trace: 15 Oct 2003 08:55:21 -0700, 12.172.51.130
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Oct 2003 08:45:19 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Oct 2003 08:51:39 -0700
X-Trace: forums-1-dub 1066233099 10.22.108.75 (15 Oct 2003 08:51:39 -0700)
X-Original-Trace: 15 Oct 2003 08:51:39 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:900
Article PK: 268202

I'm using

[ODBC]
uid=dba
pwd=sql
enginename=LOGAIS70
CommLinks=TCPIP(dobroadcast=DIRECT;host=LOGAIS70;port=2638)
autostop=Yes

the database server is running on my laptop, as LOGAIS70. I have an
activesync connection and cannot connect to the database on that laptop.
Also, when I have an RF connection available on the PDT and on the network,
I cannot connect that way either.

I have no problems connecting to the network database using that same ODBC
paramater on the laptop with sybase central.

John

"Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in message
news:3f856597$1@forums-1-dub...
> Does this help?
>
> --
> Dean Jones [TeamSybase]
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 ext 112
>
>
>
>
>
> "John Owens" <j.owens@stanleyassociates.com> wrote in message
> news:3f846bea$1@forums-1-dub...
> > How would you make a DSN connection to a database thorough the cradle
> > manually?
> >
> > I will look into MobilLink and SQL Remote
> >
> > "Dean Jones [TeamSybase]" <dean__remove__@powerobjects.com> wrote in
> message
> > news:3f84117d$1@forums-1-dub...
> > > See below.
> > >
> > > --
> > > Dean Jones [TeamSybase]
> > > CEO
> > > PowerObjects
> > > http://www.powerobjects.com
> > > (612) 339-3355 ext 112
> > >
> > >
> > >
> > >
> > >
> > > <John Owens> wrote in message
news:3f8395bb.bdc.846930886@sybase.com...
> > > > I'll get to the sync later, i'm curious on standard
> > > > user-selected data transfers at a specific point of time.
> > > >
> > > > Ok say I am connected via cradle and I have a database
> > > > running locally (dbeng8.exe) on the laptop it is connected
> > > > to. How can I....
> > > >
> > > > 1) Grab table X from the laptop database and put it in the
> > > > PDA ASA database table Y.
> > >
> > > You can use MobiLink or SQL Remote or manully code it. I can create a
> > > connection to the notebook database retrieve data into a data store,
> move
> > > data into a new datastore and insert it into the new table in the PDA
> > > database.
> > >
> > >
> > >
> > > > 2) Send table Z's data from the PDA to the locally running
> > > > database on the laptop.
> > >
> > > Same thing as answer 1.
> > >
> > >
> > >
> > > > This also stems into another seperate question:
> > > > I can easily connect to a server database running
> > > > (dbsrv8.exe) on the network via RF, but can I connect to a
> > > > "local" database (dbeng8.exe) running on a laptop if that
> > > > laptop is running a RF card or must is run in server mode?
> > >
> > > I would have to try it. We have always used the server engine. for the
> > > consolidated database.
> > >
> > > HTH
> > >
> > >
> > > > John Owens
> > > >
> > > > > You can connect directly to a ASA database. You can then
> > > > > use linked tables to update other non-ASA databases.
> > > > >
> > > > > I think it would be much easier and much faster to use
> > > > > MobiLink to sync the data to a backend database.
> > > > >
> > > > > If you move data from the PDA to backend database you must
> > > > > license the ASA database on the PDA. So you have either
> > > > > options available at the same cost. If you use a MobiLink
> > > > > option it will be the same process for all users, store
> > > > > and forward. Sync when you are connected.
> > > > >
> > > > > HTH
> > > > >
> > > > > --
> > > > > Dean Jones [TeamSybase]
> > > > > CEO
> > > > > PowerObjects
> > > > > http://www.powerobjects.com
> > > > > (612) 339-3355 ext 112
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "John Owens" <j.owens@stanleyassociates.com> wrote in
> > > > > message news:3f81831d$2@forums-1-dub...
> > > > > > Is there a way to connect to a remote database via the
> > > > > cradle without using
> > > > > > RF or synchronization?
> > > > > >
> > > > > > I am developing an application which will be deployed in
> > > > > some areas with RF
> > > > > > and some areas without. Thus, batch data storage is
> > > > > > used to store barcode data until either RF is available
> > > > > or until the PDT is placed in the cradle.
> > > > > > So, I need to be able to transfer data from my PDA local
> > > > > > database to the database running on the laptop the
> > > > > cradle is connected to. >
> > > > > > If synchonization is the only way, I need to know that
> > > > > as well. >
> > > > > > John Owens
> > > > > > Stanley Associates
> > > > > >
> > > > > >
> > > > >
> > > > >
> > >
> > >
> >
> >
>
>
>


Chris Pollach Posted on 2003-10-06 17:26:35.0Z
From: "Chris Pollach" <PollachC@SCC-CSC.gc.ca>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f81831d$2@forums-1-dub>
Subject: Re: Cradle database connection w/o RF or Sync
Lines: 33
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: <3f81a5cb$1@forums-1-dub>
Date: 6 Oct 2003 10:26:35 -0700
X-Trace: forums-1-dub 1065461195 209.47.227.131 (6 Oct 2003 10:26:35 -0700)
X-Original-Trace: 6 Oct 2003 10:26:35 -0700, listserv.scc-csc.gc.ca
X-Authenticated-User: PPBBeta11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:718
Article PK: 267251

John;

You can access the PDA ASA database from a PB application on the PC
where the PDA is docked. What I have done is to just use a "pipeline" to
transfer the data back and forth. Since the PL is running inside of a PB
application, connectivity to the central DBMS can be of any flavour that PB
supports (i.e.: DB/2, SQLServer, Oracle, etc).

regards ... Chris

"John Owens" <j.owens@stanleyassociates.com> wrote in message
news:3f81831d$2@forums-1-dub...
> Is there a way to connect to a remote database via the cradle without
using
> RF or synchronization?
>
> I am developing an application which will be deployed in some areas with
RF
> and some areas without. Thus, batch data storage is used to store barcode
> data until either RF is available or until the PDT is placed in the
cradle.
> So, I need to be able to transfer data from my PDA local database to the
> database running on the laptop the cradle is connected to.
>
> If synchonization is the only way, I need to know that as well.
>
> John Owens
> Stanley Associates
>
>


John Owens Posted on 2003-10-06 21:00:11.0Z
Reply-To: "John Owens" <j.owens@stanelyassociates.com>
From: "John Owens" <j.owens@stanleyassociates.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f81831d$2@forums-1-dub> <3f81a5cb$1@forums-1-dub>
Subject: Re: Cradle database connection w/o RF or Sync
Lines: 41
Organization: Stanley Associates
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: 12.172.51.130
X-Original-NNTP-Posting-Host: 12.172.51.130
Message-ID: <3f81d7db@forums-1-dub>
Date: 6 Oct 2003 14:00:11 -0700
X-Trace: forums-1-dub 1065474011 12.172.51.130 (6 Oct 2003 14:00:11 -0700)
X-Original-Trace: 6 Oct 2003 14:00:11 -0700, 12.172.51.130
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:733
Article PK: 268036

Thank you this is very helpful.

"Chris Pollach" <PollachC@SCC-CSC.gc.ca> wrote in message
news:3f81a5cb$1@forums-1-dub...
> John;
>
> You can access the PDA ASA database from a PB application on the PC
> where the PDA is docked. What I have done is to just use a "pipeline" to
> transfer the data back and forth. Since the PL is running inside of a PB
> application, connectivity to the central DBMS can be of any flavour that
PB
> supports (i.e.: DB/2, SQLServer, Oracle, etc).
>
> regards ... Chris
>
>
> "John Owens" <j.owens@stanleyassociates.com> wrote in message
> news:3f81831d$2@forums-1-dub...
> > Is there a way to connect to a remote database via the cradle without
> using
> > RF or synchronization?
> >
> > I am developing an application which will be deployed in some areas with
> RF
> > and some areas without. Thus, batch data storage is used to store
barcode
> > data until either RF is available or until the PDT is placed in the
> cradle.
> > So, I need to be able to transfer data from my PDA local database to the
> > database running on the laptop the cradle is connected to.
> >
> > If synchonization is the only way, I need to know that as well.
> >
> > John Owens
> > Stanley Associates
> >
> >
>
>