Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #28989

Re: Accessing Access database files

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!us.feeder.erje.net!newsfeed.fsmpi.rwth-aachen.de!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 Mon, 7 Jul 2014 11:45:24 +0000 (UTC)
Organization A noiseless patient Spider
Lines 50
Message-ID <lpe18k$jqe$2@dont-email.me> (permalink)
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> <lpcj3t$26o$1@dont-email.me> <53b9d677$0$295$14726298@news.sunsite.dk>
Mime-Version 1.0
Content-Type text/plain; charset=UTF-8
Content-Transfer-Encoding 8bit
Injection-Date Mon, 7 Jul 2014 11:45:24 +0000 (UTC)
Injection-Info mx05.eternal-september.org; posting-host="e5160e2be48f1ea550cf61512446f525"; logging-data="20302"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18CJo3oMwSoK3dAEopKvf0FJXi9Sct+xKE="
User-Agent Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
Cancel-Lock sha1:u1aE1T1dUfYASb7qgIkFMtnK370=
Xref csiph.com comp.lang.java.programmer:28989

Show key headers only | View raw

On Sun, 06 Jul 2014 19:06:30 -0400, Arne Vajhøj wrote:

> On 7/6/2014 6:37 PM, Martin Gregorie wrote:
>> 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?
> 
> SQLServer Compact is often abbreviated SQLServer CE.
> 
> I think:
>    CE = Compact Edition.
> 
> http://en.wikipedia.org/wiki/SQL_Server_Compact
>
Thanks for that: it clarifies things a lot. 

I use the LK8000 gliding navigation app, which runs on Win CE based 
Personal Navigation Assistants (PNAs), so I was reading the CE 
abbreviation and references to mobile devices as equating CE with Windows 
CE 5/6 and applications that run on it. Pardon my confusion.

So, it looks as though SQL Server Compact is intended to be pretty much a 
drop-in replacement[*] for Access, particularly for systems that use ODBC 
or JDBC as their DBMS interface. I'd wondered, too, if it might suffer 
from the general MS filesize limitation of 4GB. It does.
   
[*] if you ignore the differences between SQL dialects and, possibly, 
differences in the way commit works.
 

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

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-01 16:28 +0000
  Re: Accessing Access database files markspace <markspace@nospam.nospam> - 2014-07-01 09:55 -0700
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-01 17:29 +0000
    Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-01 22:49 -0400
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 10:03 +0000
      Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:06 -0400
        Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-03 09:48 +0000
          Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-03 16:31 -0400
            Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-03 22:03 +0000
              Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:01 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 16:42 +0000
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:45 -0400
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 12:47 -0400
  Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-01 22:47 -0400
    Re: Accessing Access database files markspace <markspace@nospam.nospam> - 2014-07-01 20:11 -0700
      Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:05 -0400
  Re: Accessing Access database files Gordon Levi <gordon@address.invalid> - 2014-07-02 16:57 +1000
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 10:20 +0000
      Re: Accessing Access database files Robert Klemme <shortcutter@googlemail.com> - 2014-07-02 20:22 +0200
  Re: Accessing Access database files Roedy Green <see_website@mindprod.com.invalid> - 2014-07-02 09:40 -0700
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 21:28 +0000
      Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-02 21:09 -0400
  Re: Accessing Access database files Jeff Higgins <jeff@invalid.invalid> - 2014-07-02 17:08 -0400
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-02 22:39 +0000
  Re: Accessing Access database files Roedy Green <see_website@mindprod.com.invalid> - 2014-07-05 16:28 -0700
    Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 08:51 +0000
      Re: Accessing Access database files Gordon Levi <gordon@address.invalid> - 2014-07-06 19:01 +1000
        Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 17:11 +0000
          Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 15:17 -0400
            Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 19:30 +0000
              Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 19:10 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 11:26 +0000
          Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 15:27 -0400
            Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-06 22:37 +0000
              Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 19:06 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 11:45 +0000
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-07 17:50 -0400
                Re: Accessing Access database files Martin Gregorie <martin@address-in-sig.invalid> - 2014-07-07 22:34 +0000
                Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-07 19:24 -0400
    Re: Accessing Access database files Arne Vajhøj <arne@vajhoej.dk> - 2014-07-06 11:55 -0400

csiph-web