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.

Creating a database on the mobile device

2 posts in General Discussion Last posting was on 2004-06-30 14:17:51.0Z
Arunasree Swapna Posted on 2004-06-29 22:04:47.0Z
From: "Arunasree Swapna" <arunasree.swapna@mobiledataforce.com>
Newsgroups: ianywhere.public.general
Subject: Creating a database on the mobile device
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 208.187.119.18
X-Original-NNTP-Posting-Host: 208.187.119.18
Message-ID: <40e1e77f@forums-1-dub>
Date: 29 Jun 2004 15:04:47 -0700
X-Trace: forums-1-dub 1088546687 208.187.119.18 (29 Jun 2004 15:04:47 -0700)
X-Original-Trace: 29 Jun 2004 15:04:47 -0700, 208.187.119.18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3224
Article PK: 6679

We are planning to use iAnywhere to solve data synchronization issue in our
forms development application.

I would like to know in what different ways can we create the ASA version of
the database on the mobile device.
From my understanding of the software, mobilink offers synchronization
between the consolidted and the remote database. the consolidated database
is the ASA database, the remote Db can be anyone of the Dbs that iAnywhere
offers compatibility with. My question is that what should be the database
type on the mobile device ?(I believe it is ASA mobile version or
Ultralite -- i would be glad if someone comments if this is right.)

Now if this is the case...how do I first create the database on the mobile
device ?---if using ASA .... how...can it be embedded in the
mobileapplication that is deployed on the mobile device ?

Any clue to the above problem will be highly appreciated.

~Aruna


Greg Fenton Posted on 2004-06-30 14:17:51.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040608 MultiZilla/1.6.3.2f
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Creating a database on the mobile device
References: <40e1e77f@forums-1-dub>
In-Reply-To: <40e1e77f@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <40e2cb8f$1@forums-1-dub>
Date: 30 Jun 2004 07:17:51 -0700
X-Trace: forums-1-dub 1088605071 10.25.100.188 (30 Jun 2004 07:17:51 -0700)
X-Original-Trace: 30 Jun 2004 07:17:51 -0700, gfenton-xp.sybase.com
Lines: 50
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3227
Article PK: 6682


Arunasree Swapna wrote:
> From my understanding of the software, mobilink offers synchronization
> between the consolidted and the remote database. the consolidated database
> is the ASA database, the remote Db can be anyone of the Dbs that iAnywhere
> offers compatibility with.

Actually, it is the other way around. The remote can be ASA or
UltraLite. The consolidated can be any of the 5 RDBMS's supported by
MobiLink (ASA, ASE, MSSQL, Oracle, DB2).

> My question is that what should be the database
> type on the mobile device ?(I believe it is ASA mobile version or
> Ultralite -- i would be glad if someone comments if this is right.)

Yes, the remote can be ASA or UltraLite (UL). For Palm, there is no ASA
so your only choice is UL. For WinCE, there is both ASA on CE and
UltraLite. The one you choose will depend on the requirements of your
application.

UL has much better performance than does ASA, but ASA has a much richer
set of features. For example, UL does not have triggers or stored
procedures. UL also has some limitations (e.g. maximum of 65565 rows
per table) that you can read about in the ASA online docs:

UltraLite Database User's Guide
UltraLite Databases
- UltraLite database limitations


> Now if this is the case...how do I first create the database on the mobile
> device ?---if using ASA .... how...can it be embedded in the
> mobileapplication that is deployed on the mobile device ?

The database is typically created during your development cycle (though
this is not a requirement) on Win32 or Unix/Linux/OSX/Netware and the
.db file is installed along with the rest of the application.

For UltraLite, if the database file does not already exist it is created
automatically when you run the application. So for UL, it is simply a
matter of installing your application.

Hope this answers your questions,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/