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.

SQL Server CE Database?

2 posts in General Discussion Last posting was on 2005-02-01 16:28:21.0Z
Vivian Sharma Posted on 2005-02-01 15:29:10.0Z
Sender: 4f15.41ff9f8b.1804289383@sybase.com
From: Vivian Sharma
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: SQL Server CE Database?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41ffa043.4f1a.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 1 Feb 2005 07:29:07 -0800, 10.22.241.42
Lines: 2
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 1 Feb 2005 07:29:08 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 1 Feb 2005 07:29:10 -0800
X-Trace: forums-1-dub 1107271750 10.22.108.75 (1 Feb 2005 07:29:10 -0800)
X-Original-Trace: 1 Feb 2005 07:29:10 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:243
Article PK: 17626

Does M-Business solution work with SQL Server CE Database?


Greg Fenton Posted on 2005-02-01 16:28:21.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: SQL Server CE Database?
References: <41ffa043.4f1a.1681692777@sybase.com>
In-Reply-To: <41ffa043.4f1a.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <41ffae21$1@forums-2-dub>
X-Original-Trace: 1 Feb 2005 08:28:17 -0800, gfenton-t30.sybase.com
Lines: 32
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 1 Feb 2005 08:28:20 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 1 Feb 2005 08:28:21 -0800
X-Trace: forums-1-dub 1107275301 10.22.108.75 (1 Feb 2005 08:28:21 -0800)
X-Original-Trace: 1 Feb 2005 08:28:21 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:244
Article PK: 17625


Vivian Sharma wrote:
> Does M-Business solution work with SQL Server CE Database?

My first reaction is to answer "no", but what in particular do you wish
to do with SQL Server CE?

mBusiness Anywhere has at least two different data-store technologies
that it directly supports:
- the XML Database & Conduit
- UltraLite (ULPod) (part of SQLAnywhere Studio)

With mBA there is the PODS interface, so you could develop your own POD
to communicate natively with just about anything you want.

iAnywhere/AvantGo Professional Services have developed POD integrations
with various native objects (e.g. address book & calendar). But I don't
believe there is currently a POD for interacting with a generic data
source (e.g. via ODBC or ADO).

BTW: both the XML and UltraLite technologies can interact with different
consolidated (master) databases. UltraLite when synchronizing with the
MobiLink server supports synchs to MS SQL Server, Oracle, DB2, Sybase
ASE and ASA (SQLAnywhere).

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