Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Martin Gregorie <martin@address-in-sig.invalid>
Newsgroups: comp.lang.java.programmer
Subject: Re: Accessing Access database files
Date: Sun, 6 Jul 2014 22:37:49 +0000 (UTC)
Organization: A noiseless patient Spider
Lines: 34
Message-ID: <lpcj3t$26o$1@dont-email.me>
References: <lounj9$a4g$2@dont-email.me> <6d2hr9pqv6rsreb625hdirnlvvuh3t8cpl@4ax.com> <lpb2ln$j4$2@dont-email.me> <qu3ir9d6nisogj6q4oq67sgjll59hsqts3@4ax.com> <lpbvvc$ivp$2@dont-email.me> <53b9a333$0$303$14726298@news.sunsite.dk>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 6 Jul 2014 22:37:49 +0000 (UTC)
Injection-Info: mx05.eternal-september.org; posting-host="e5160e2be48f1ea550cf61512446f525"; logging-data="2264"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX193hgEZkEip7j7YHthSILM3BeRGzkaZuXM="
User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
Cancel-Lock: sha1:p+EC7kk/9r8KVn78MGamG7LPEqU=
Xref: csiph.com comp.lang.java.programmer:28981

On Sun, 06 Jul 2014 15:27:47 -0400, Arne Vajhøj wrote:

> Contrary to the name SQLServer CE is not an edition of SQLServer.
>
Yes, I know that: I've read the summary. Presumably SQL Server CE is now 
as dead as WinCE.

I don't know what exactly  SQL Server Compact is, but it isn't SQL Server 
CE. Maybe MS has (slightly) reused a name, but SQL Server Compact seems 
to be a free-to-download replacement for Access - it certainly uses the 
same paradigm of having mapping both metadata (schema) and data into a 
single file with an .sdf extension.

> SQLServer CE is an embedded database that are not very widely known, but
> it is actually quite nice. If I had to use an embedded database in .NET
> environment, then it would be my pick too.
> 
Maybe SQL Server Compact is SQL Server CE recompiled to run on Windows 
Server boxes?
 
> MS do supply a JDBC driver for the real SQLServer.
>
Good, and if SQL Server is a true server family, as opposed to IBM-style 
product naming kludge[*], it will work with all members of the family? 
That would be a really good thing to have.
  
[*] I'm thinking of SNA, where any commonality between SNA/LU2 (aka 3270 
Bisync) and SNA/LU6 is a figment of a salesdroid#s imagination. 


-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |