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.

Create an Online Application !!

5 posts in Pocket PowerBuilder Last posting was on 2003-07-28 19:09:35.0Z
Mohit Chanana Posted on 2003-07-28 17:18:19.0Z
From: "Mohit Chanana" <NOSPAM_sas@sasintl.com>
Newsgroups: sybase.public.pocketpowerbuilder
Subject: Create an Online Application !!
Lines: 49
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C35501.CB6AD3D0"
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: 209.8.120.210
X-Original-NNTP-Posting-Host: 209.8.120.210
Message-ID: <3f255adb$1@forums-1-dub>
Date: 28 Jul 2003 10:18:19 -0700
X-Trace: forums-1-dub 1059412699 209.8.120.210 (28 Jul 2003 10:18:19 -0700)
X-Original-Trace: 28 Jul 2003 10:18:19 -0700, 209.8.120.210
X-Authenticated-User: ppb
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:41
Article PK: 265917

Hello All,
 
Is it possible to create an online application using PPB which maintains a active connection to a database on the network (Using 802.11b) or is it mandatory for PPB to a have a local DSN and do a synchonization everytime.
 
Thanks!

Mohit Chanana
Service Automation, Inc.


Martyn Mallick Posted on 2003-07-28 17:33:27.0Z
From: "Martyn Mallick" <mmallick.removethis@ianywhere.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f255adb$1@forums-1-dub>
Subject: Re: Create an Online Application !!
Lines: 87
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0025_01C3550C.49F30E20"
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: <3f255e67@forums-1-dub>
Date: 28 Jul 2003 10:33:27 -0700
X-Trace: forums-1-dub 1059413607 172.31.141.129 (28 Jul 2003 10:33:27 -0700)
X-Original-Trace: 28 Jul 2003 10:33:27 -0700, mmallick-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:42
Article PK: 265995

Mohit,
 
The ASA ODBC drivers allows you to access an ASA database running on a server, so you can connect over a wireless network to the server database in realtime. 
 
This is not typically our recommended approach as even with 802.11b, there are often areas without wireless coverage, in which case the application wouldn't work.
 
-Marty
"Mohit Chanana" <NOSPAM_sas@sasintl.com> wrote in message news:3f255adb$1@forums-1-dub...
Hello All,
 
Is it possible to create an online application using PPB which maintains a active connection to a database on the network (Using 802.11b) or is it mandatory for PPB to a have a local DSN and do a synchonization everytime.
 
Thanks!

Mohit Chanana
Service Automation, Inc.


Mohit Chanana Posted on 2003-07-28 17:47:48.0Z
From: "Mohit Chanana" <NOSPAM_sas@sasintl.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f255adb$1@forums-1-dub> <3f255e67@forums-1-dub>
Subject: Re: Create an Online Application !!
Lines: 143
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_000E_01C35505.E947A550"
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: 209.8.120.210
X-Original-NNTP-Posting-Host: 209.8.120.210
Message-ID: <3f2561c4@forums-1-dub>
Date: 28 Jul 2003 10:47:48 -0700
X-Trace: forums-1-dub 1059414468 209.8.120.210 (28 Jul 2003 10:47:48 -0700)
X-Original-Trace: 28 Jul 2003 10:47:48 -0700, 209.8.120.210
X-Authenticated-User: ppb
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:43
Article PK: 265998

Thanks for your prompt reply Marty, could you please suggest what would be the right approach for creating an application which deals with a big chunk of data for example an Inventory Transfer Application which needs all part information in the handheld and that could be hundreds of thousands of rows of data. In that case an offline application would be restricted in a lot of ways.
 
We can suggest our customers to either use 802.11b or a wireless internet access which have their flaws but its better than restricting user to how much information can be accessed.
 
Any Thoughts ??
 
Thanks Again
 
-Mohit
 
 
"Martyn Mallick" <mmallick.removethis@ianywhere.com> wrote in message news:3f255e67@forums-1-dub...
Mohit,
 
The ASA ODBC drivers allows you to access an ASA database running on a server, so you can connect over a wireless network to the server database in realtime. 
 
This is not typically our recommended approach as even with 802.11b, there are often areas without wireless coverage, in which case the application wouldn't work.
 
-Marty
"Mohit Chanana" <NOSPAM_sas@sasintl.com> wrote in message news:3f255adb$1@forums-1-dub...
Hello All,
 
Is it possible to create an online application using PPB which maintains a active connection to a database on the network (Using 802.11b) or is it mandatory for PPB to a have a local DSN and do a synchonization everytime.
 
Thanks!

Mohit Chanana
Service Automation, Inc.


Roland Smith Posted on 2003-07-28 18:46:12.0Z
From: "Roland Smith" <rsmith@cvps.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f255adb$1@forums-1-dub> <3f255e67@forums-1-dub> <3f2561c4@forums-1-dub>
Subject: Re: Create an Online Application !!
Lines: 199
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0013_01C35516.73627660"
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: 170.46.129.120
X-Original-NNTP-Posting-Host: 170.46.129.120
Message-ID: <3f256f74@forums-1-dub>
Date: 28 Jul 2003 11:46:12 -0700
X-Trace: forums-1-dub 1059417972 170.46.129.120 (28 Jul 2003 11:46:12 -0700)
X-Original-Trace: 28 Jul 2003 11:46:12 -0700, 170.46.129.120
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:44
Article PK: 265997

Mohit,
 
You could have a database on the device that had a small amount of data about each part.  The app could be always connected to the local database and connected to the server when possible.  If the user requests information about a part that is on the server, it would display a message if the server is currently unavailable.
 
Another idea:  I posted an example on CodeExchange of using ZLib for compression.  You could keep some of the data in compressed blob columns to save space.
 
Roland
--
Topwiz Software - Home of PBSearch
http://www.topwizprogramming.com/
"Mohit Chanana" <NOSPAM_sas@sasintl.com> wrote in message news:3f2561c4@forums-1-dub...
Thanks for your prompt reply Marty, could you please suggest what would be the right approach for creating an application which deals with a big chunk of data for example an Inventory Transfer Application which needs all part information in the handheld and that could be hundreds of thousands of rows of data. In that case an offline application would be restricted in a lot of ways.
 
We can suggest our customers to either use 802.11b or a wireless internet access which have their flaws but its better than restricting user to how much information can be accessed.
 
Any Thoughts ??
 
Thanks Again
 
-Mohit
 
 
"Martyn Mallick" <mmallick.removethis@ianywhere.com> wrote in message news:3f255e67@forums-1-dub...
Mohit,
 
The ASA ODBC drivers allows you to access an ASA database running on a server, so you can connect over a wireless network to the server database in realtime. 
 
This is not typically our recommended approach as even with 802.11b, there are often areas without wireless coverage, in which case the application wouldn't work.
 
-Marty
"Mohit Chanana" <NOSPAM_sas@sasintl.com> wrote in message news:3f255adb$1@forums-1-dub...
Hello All,
 
Is it possible to create an online application using PPB which maintains a active connection to a database on the network (Using 802.11b) or is it mandatory for PPB to a have a local DSN and do a synchonization everytime.
 
Thanks!

Mohit Chanana
Service Automation, Inc.


Mohit Chanana Posted on 2003-07-28 19:09:35.0Z
From: "Mohit Chanana" <NOSPAM_sas@sasintl.com>
Newsgroups: sybase.public.pocketpowerbuilder
References: <3f255adb$1@forums-1-dub> <3f255e67@forums-1-dub> <3f2561c4@forums-1-dub> <3f256f74@forums-1-dub>
Subject: Re: Create an Online Application !!
Lines: 238
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0011_01C35511.561AAE60"
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: 209.8.120.210
X-Original-NNTP-Posting-Host: 209.8.120.210
Message-ID: <3f2574ef$1@forums-1-dub>
Date: 28 Jul 2003 12:09:35 -0700
X-Trace: forums-1-dub 1059419375 209.8.120.210 (28 Jul 2003 12:09:35 -0700)
X-Original-Trace: 28 Jul 2003 12:09:35 -0700, 209.8.120.210
X-Authenticated-User: ppb
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.pocketpowerbuilder:46
Article PK: 265999

Thanks Roland, So its clear that developing a true online application for handheld devices would have to wait.. atleast for now, we have also tried creating a handheld application with .Net but same limitations exist; I believe the new ASA 9 has some inbuilt functionality to check remote database liveliness before initiating a new transaction, which is very refreshing to know.
 
But thanks for the input..
 
-Mohit
"Roland Smith" <rsmith@cvps.com> wrote in message news:3f256f74@forums-1-dub...
Mohit,
 
You could have a database on the device that had a small amount of data about each part.  The app could be always connected to the local database and connected to the server when possible.  If the user requests information about a part that is on the server, it would display a message if the server is currently unavailable.
 
Another idea:  I posted an example on CodeExchange of using ZLib for compression.  You could keep some of the data in compressed blob columns to save space.
 
Roland
--
Topwiz Software - Home of PBSearch
http://www.topwizprogramming.com/
"Mohit Chanana" <NOSPAM_sas@sasintl.com> wrote in message news:3f2561c4@forums-1-dub...
Thanks for your prompt reply Marty, could you please suggest what would be the right approach for creating an application which deals with a big chunk of data for example an Inventory Transfer Application which needs all part information in the handheld and that could be hundreds of thousands of rows of data. In that case an offline application would be restricted in a lot of ways.
 
We can suggest our customers to either use 802.11b or a wireless internet access which have their flaws but its better than restricting user to how much information can be accessed.
 
Any Thoughts ??
 
Thanks Again
 
-Mohit
 
 
"Martyn Mallick" <mmallick.removethis@ianywhere.com> wrote in message news:3f255e67@forums-1-dub...
Mohit,
 
The ASA ODBC drivers allows you to access an ASA database running on a server, so you can connect over a wireless network to the server database in realtime. 
 
This is not typically our recommended approach as even with 802.11b, there are often areas without wireless coverage, in which case the application wouldn't work.
 
-Marty
"Mohit Chanana" <NOSPAM_sas@sasintl.com> wrote in message news:3f255adb$1@forums-1-dub...
Hello All,
 
Is it possible to create an online application using PPB which maintains a active connection to a database on the network (Using 802.11b) or is it mandatory for PPB to a have a local DSN and do a synchonization everytime.
 
Thanks!

Mohit Chanana
Service Automation, Inc.