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

Groups > comp.lang.java.programmer > #28884 > unrolled thread

Accessing Access database files

Back to article view | Back to comp.lang.java.programmer

Contents

  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

Page 2 of 2 — ← Prev page 1 [2]

#28919

On Wed, 02 Jul 2014 09:40:30 -0700, Roedy Green wrote:

> On Tue, 1 Jul 2014 16:28:25 +0000 (UTC), Martin Gregorie
> <martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
> someone who said :
> 
>>Is there a JDBC driver or non-JDBC class library that would give a Java
>>program read/write access to the tables and schema in a MS Access
>>database?
> 
> have a look at http://mindprod.com/jgloss/jdbc.html
> 
> under the ODBC bridge.  I that is how you can get at them, not wildly
> efficient, but I doubt you need it.
>
There appear to be better solutions than the ODBC bridge.

I haven't tried using it yet, but UCanAccess + Jackcess + HSQLDB together 
make up a JDBC driver, it says, that can read and write Access databases 
without a byte of Windows code being involved. It appears that the whole 
thing fits together like this:
 - Jackcess 2.0 understands the Access file structure at the 
   schema/table/locking(I think) level
 - HSQLDB 2.25 contributes the SQL engine 
 - UCanAccess 2.x.x binds it all together and turns it into a functional 
   JDBC driver.

I like JDBC: I've been using it for a while now to access a PostgreSQL 
database. Performnance is better than I initially expected and it pretty 
much 'just works' and keeps on doing so despite software, hardware and OS 
upgrades.

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

[toc] | [prev] | [next] | [standalone]

#28924

On 7/2/2014 5:28 PM, Martin Gregorie wrote:
> On Wed, 02 Jul 2014 09:40:30 -0700, Roedy Green wrote:
>
>> On Tue, 1 Jul 2014 16:28:25 +0000 (UTC), Martin Gregorie
>> <martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
>> someone who said :
>>
>>> Is there a JDBC driver or non-JDBC class library that would give a Java
>>> program read/write access to the tables and schema in a MS Access
>>> database?
>>
>> have a look at http://mindprod.com/jgloss/jdbc.html
>>
>> under the ODBC bridge.  I that is how you can get at them, not wildly
>> efficient, but I doubt you need it.
>>
> There appear to be better solutions than the ODBC bridge.
>
> I haven't tried using it yet, but UCanAccess + Jackcess + HSQLDB together
> make up a JDBC driver, it says, that can read and write Access databases
> without a byte of Windows code being involved. It appears that the whole
> thing fits together like this:
>   - Jackcess 2.0 understands the Access file structure at the
>     schema/table/locking(I think) level
>   - HSQLDB 2.25 contributes the SQL engine
>   - UCanAccess 2.x.x binds it all together and turns it into a functional
>     JDBC driver.

I would be reluctant to consider some reverse engineered code
better in general than what Oracle and MS support.

But you have a requirement to run on Linux and the Oracle & MS
solution only runs on Windows so in that context it is definitely better.

Arne

[toc] | [prev] | [next] | [standalone]

#28918

On 07/01/2014 12:28 PM, Martin Gregorie wrote:
> Is there a JDBC driver or non-JDBC class library that would give a Java
> program read/write access to the tables and schema in a MS Access
> database?
>
> I don't need to update the database, just examine the schema and table
> contents. I don't have a copy od the Access software and nowhere to run
> it because all my computers run Linux.
>
>
I'm pretty sure Open Office will open Access databases?

[toc] | [prev] | [next] | [standalone]

#28922

On Wed, 02 Jul 2014 17:08:56 -0400, Jeff Higgins wrote:

> On 07/01/2014 12:28 PM, Martin Gregorie wrote:
>> Is there a JDBC driver or non-JDBC class library that would give a Java
>> program read/write access to the tables and schema in a MS Access
>> database?
>>
>> I don't need to update the database, just examine the schema and table
>> contents. I don't have a copy od the Access software and nowhere to run
>> it because all my computers run Linux.
>>
>>
> I'm pretty sure Open Office will open Access databases?
>
Yes, its known to do that, but the usual run of ODBC/JDBC drivers almost 
certainly expect the JET database server to be involved. I don't have JET 
or an OS it would run on, hence my interest in using UCanAccess.

UCanAccess is a JDBC driver written in Java that incorporates Java class 
libraries to give it direct access to the Access database files and an 
SQL engine. Because if this it has been shown to let Libre Office and 
Open Office, running under Linux, read and write Access database files 
installed locally on the same Linux box. This is exactly what I need.


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

[toc] | [prev] | [next] | [standalone]

#28955

On Tue, 1 Jul 2014 16:28:25 +0000 (UTC), Martin Gregorie
<martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
someone who said :

>Is there a JDBC driver or non-JDBC class library that would give a Java 
>program read/write access to the tables and schema in a MS Access 
>database? 

Would a solution of this form be feasible?

1. Persuade Access to export its data in some simple form, e.g. CSV
2. import into some more tractable database like PostGre.
-- 
Roedy Green Canadian Mind Products http://mindprod.com
A program is only as good as its worst piece of code.
~ Joshua Cramer

[toc] | [prev] | [next] | [standalone]

#28957

On Sat, 05 Jul 2014 16:28:02 -0700, Roedy Green wrote:

> On Tue, 1 Jul 2014 16:28:25 +0000 (UTC), Martin Gregorie
> <martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
> someone who said :
> 
>>Is there a JDBC driver or non-JDBC class library that would give a Java
>>program read/write access to the tables and schema in a MS Access
>>database?
> 
> Would a solution of this form be feasible?
> 
> 1. Persuade Access to export its data in some simple form, e.g. CSV 2.
> import into some more tractable database like PostGre.

Thats not needed: just install the UCanAccess JDBC driver.

There can be major problems with moving data from one RDBMS to another. 
While its relatively simple to do if the source schema was fully 
normalised, i.e. all tables are in 3NF, there are still potential 
problems that arise from differences between SQL dialects since very few 
RDBMSs implement fully standards-compliant SQL: PostgreSQL is one of the 
better ones. Common problem areas include migrating schemas between RDBMSs 
that implement auto-incrementing data types and those that use sequences 
and there can be problems with BLOBs and CLOBs.

A big issue with Access databases is that they have often been cobbled 
together by a non-specialist who have never heard of normalisation, 
referential integrity or prime keys and who think that tables containing 
arrays and lots of derived values are the bee's knees. Don't ask me how I 
know.....
   

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

[toc] | [prev] | [next] | [standalone]

#28958

Martin Gregorie <martin@address-in-sig.invalid> wrote:

>On Sat, 05 Jul 2014 16:28:02 -0700, Roedy Green wrote:
>
>> On Tue, 1 Jul 2014 16:28:25 +0000 (UTC), Martin Gregorie
>> <martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
>> someone who said :
>> 
>>>Is there a JDBC driver or non-JDBC class library that would give a Java
>>>program read/write access to the tables and schema in a MS Access
>>>database?
>> 
>> Would a solution of this form be feasible?
>> 
>> 1. Persuade Access to export its data in some simple form, e.g. CSV 2.
>> import into some more tractable database like PostGre.
>
>Thats not needed: just install the UCanAccess JDBC driver.

Did it all work as expected? My application needs a major upgrade and
it would be a good time to throw out the JDBC-ODBC bridge.

[snip]

[toc] | [prev] | [next] | [standalone]

#28975

On Sun, 06 Jul 2014 19:01:18 +1000, Gordon Levi wrote:

> Martin Gregorie <martin@address-in-sig.invalid> wrote:
> 
>>On Sat, 05 Jul 2014 16:28:02 -0700, Roedy Green wrote:
>>
>>> On Tue, 1 Jul 2014 16:28:25 +0000 (UTC), Martin Gregorie
>>> <martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
>>> someone who said :
>>> 
>>>>Is there a JDBC driver or non-JDBC class library that would give a
>>>>Java program read/write access to the tables and schema in a MS Access
>>>>database?
>>> 
>>> Would a solution of this form be feasible?
>>> 
>>> 1. Persuade Access to export its data in some simple form, e.g. CSV 2.
>>> import into some more tractable database like PostGre.
>>
>>Thats not needed: just install the UCanAccess JDBC driver.
> 
> Did it all work as expected? My application needs a major upgrade and it
> would be a good time to throw out the JDBC-ODBC bridge.
>
I haven't got around to trying it yet: sorry. I'm still in the process of 
getting my head round the system I'm taking over as superuser/webmaster. 
Its written in ASP.net running under IIS and using an Access database 
(obviously) which is 'soon' to be replaced by an equivalent level SQL 
Server[1]. As I wouldn't know ASP.net from S/360 BAL and anyway there 
seems to be no schema definition or ERD. Since I don't have anything that 
can run Access code but do have copies of the .mdf files, I'm hoping to 
use UCanAccess plus a client such as SQLeo to extract a schema diagram I 
can make sense of and, as a bonus, use that or write a simple Java app 
that can extract one or two lists that I'd find useful as webmaster.

Hopefully I'll find time over the next week or two to install UCanAccess 
and try some of this stuff out. 

When I do, I'll post my findings here.

However, I believe MS is in the process of dumping Access in favour of 
supporting just SQL Server, which is why we're due to migrate our system 
to SQL Server Compact which seems to be a free version of the DBMS. You 
might want to consider that too. And before you ask, no, I haven't even 
begun to look for stand-alone JDBC drivers for it. 

[1] SQL Server Compact. Literally all I know about it at this point is 
that it stores data in .sdf files just as Access stores data in .mdb 
files, so its no use at all to ask me anything more about it.


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

[toc] | [prev] | [next] | [standalone]

#28976

On 7/6/2014 1:11 PM, Martin Gregorie wrote:
> On Sun, 06 Jul 2014 19:01:18 +1000, Gordon Levi wrote:
>
>> Martin Gregorie <martin@address-in-sig.invalid> wrote:
>>
>>> On Sat, 05 Jul 2014 16:28:02 -0700, Roedy Green wrote:
>>>
>>>> On Tue, 1 Jul 2014 16:28:25 +0000 (UTC), Martin Gregorie
>>>> <martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
>>>> someone who said :
>>>>
>>>>> Is there a JDBC driver or non-JDBC class library that would give a
>>>>> Java program read/write access to the tables and schema in a MS Access
>>>>> database?
>>>>
>>>> Would a solution of this form be feasible?
>>>>
>>>> 1. Persuade Access to export its data in some simple form, e.g. CSV 2.
>>>> import into some more tractable database like PostGre.
>>>
>>> Thats not needed: just install the UCanAccess JDBC driver.
>>
>> Did it all work as expected? My application needs a major upgrade and it
>> would be a good time to throw out the JDBC-ODBC bridge.
>>
> I haven't got around to trying it yet: sorry. I'm still in the process of
> getting my head round the system I'm taking over as superuser/webmaster.
> Its written in ASP.net running under IIS and using an Access database
> (obviously) which is 'soon' to be replaced by an equivalent level SQL
> Server[1]. As I wouldn't know ASP.net from S/360 BAL and anyway there
> seems to be no schema definition or ERD. Since I don't have anything that
> can run Access code but do have copies of the .mdf files, I'm hoping to
                                                 ^^^^
> use UCanAccess plus a client such as SQLeo to extract a schema diagram I
> can make sense of and, as a bonus, use that or write a simple Java app
> that can extract one or two lists that I'd find useful as webmaster.

Pull the break!

Is is a MDB file or a MDF file?

MDB => Access

MDF => SQLServer

Arne

[toc] | [prev] | [next] | [standalone]

#28978

On Sun, 06 Jul 2014 15:17:10 -0400, Arne Vajhøj wrote:

> 
> Is is a MDB file or a MDF file?
>
MDB (unspotted finger trouble). 

I haven't had anything to do with Sybase since version 11. That was just 
before MS bought a license for version 12, applied their own tweaks and 
started to sell it as SQL Server. I imagine its diverged quite a bit 
since then. For starters, Sybase 11 used raw disk partitions as its data 
store, rather than files.  

I haven't knowingly used SQL Server at all.


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

[toc] | [prev] | [next] | [standalone]

#28983

On 7/6/2014 3:30 PM, Martin Gregorie wrote:
> On Sun, 06 Jul 2014 15:17:10 -0400, Arne Vajhøj wrote:
>> Is is a MDB file or a MDF file?
>>
> MDB (unspotted finger trouble).

It happens.

> I haven't had anything to do with Sybase since version 11. That was just
> before MS bought a license for version 12, applied their own tweaks and
> started to sell it as SQL Server.

????

The last Sybase version MS got from Sybase was 4.x in 1992. They did
not get 10.x from 1993 / 11.x from 1995 / 12.x from 1999.

Arne

[toc] | [prev] | [next] | [standalone]

#28988

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

> On 7/6/2014 3:30 PM, Martin Gregorie wrote:
>> On Sun, 06 Jul 2014 15:17:10 -0400, Arne Vajhøj wrote:
>>> Is is a MDB file or a MDF file?
>>>
>> MDB (unspotted finger trouble).
> 
> It happens.
> 
>> I haven't had anything to do with Sybase since version 11. That was
>> just before MS bought a license for version 12, applied their own
>> tweaks and started to sell it as SQL Server.
> 
> ????
> 
> The last Sybase version MS got from Sybase was 4.x in 1992. They did not
> get 10.x from 1993 / 11.x from 1995 / 12.x from 1999.
>
OK, if you say so. Are you sure they didn't get an initial license in '92 
and then re-licensed for a later version on '96 or therabouts? 

My recollection is that I was working with Sybase 11 in 95/96 on NCR UNIX 
boxes and that was when MS announced that it had bought a license for 
Sybase. Back in '92 I'd been involved in briefly looking at Sybase for a 
project we'd been designing as an alternative for using ICL mainframe 
kit: I'd didn't do any serious work with Sybase databases before the mid 
1990s and so the news that MS had bought a license in '92 would likely 
have gone straight over my head: most of the database stuff I did back 
then was with IDMS rather than relational databases.
  

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

[toc] | [prev] | [next] | [standalone]

#28977

On 7/6/2014 1:11 PM, Martin Gregorie wrote:
> However, I believe MS is in the process of dumping Access in favour of
> supporting just SQL Server, which is why we're due to migrate our system

That process has been ongoing for the past 15+ years and I suspect that
it will be ongoing for the next 15 years as well.

With the widely usage of MS Office, the large number of MS Access
databases out there and the support for MS Access databases by
third party tools then it is like getting rid of COBOL.

> to SQL Server Compact which seems to be a free version of the DBMS. You
> might want to consider that too. And before you ask, no, I haven't even
> begun to look for stand-alone JDBC drivers for it.
>
> [1] SQL Server Compact. Literally all I know about it at this point is
> that it stores data in .sdf files just as Access stores data in .mdb
> files, so its no use at all to ask me anything more about it.

Contrary to the name SQLServer CE is not an edition of SQLServer.

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.

Unfortunately no JBDC driver.

MS do supply a JDBC driver for the real SQLServer.

Arne

[toc] | [prev] | [next] | [standalone]

#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       |

[toc] | [prev] | [next] | [standalone]

#28982

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

Arne

[toc] | [prev] | [next] | [standalone]

#28989

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       |

[toc] | [prev] | [next] | [standalone]

#28991

On 7/7/2014 7:45 AM, Martin Gregorie wrote:
> 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:
>>>> 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.

> So, it looks as though SQL Server Compact is intended to be pretty much a
> drop-in replacement[*] for Access,

It is.

>                                   particularly for systems that use ODBC
> or JDBC as their DBMS interface.

Not so.

SQLServer CE does not come with ODBC or JDBC at all.

It only comes with OLE DB (ADO) and ADO.NET providers.

>                              I'd wondered, too, if it might suffer
> from the general MS filesize limitation of 4GB. It does.

The general MS file size limitation is 16 TB for older Windows
and 256 TB for newer Windows.

(well it was 2/4 GB if we go back to Win9x in the 1990's)

But yes - SQLServer CE is limited to 4 GB.

I don't think it is that bad. If you need more space, then you
should probably go SQLServer anyway.

Arne

[toc] | [prev] | [next] | [standalone]

#28994

 The general MS file size limitation is 16 TB for older Windows and 256
> TB for newer Windows.
> 
> (well it was 2/4 GB if we go back to Win9x in the 1990's)
>
Yep - FAT32 limitation.
 
> But yes - SQLServer CE is limited to 4 GB.
> 
> I don't think it is that bad. If you need more space, then you should
> probably go SQLServer anyway.
>
True enough. 

I get the impression that FAT-32 is still alive and kicking as the 
default FS on a lot of small/medium flash drives, so they just might have 
retained the 4GB limit to make it easier to backup or transfer database 
files on these media.


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

[toc] | [prev] | [next] | [standalone]

#28995

On 7/7/2014 6:34 PM, Martin Gregorie wrote:
>> But yes - SQLServer CE is limited to 4 GB.
>>
>> I don't think it is that bad. If you need more space, then you should
>> probably go SQLServer anyway.
>>
> True enough.
>
> I get the impression that FAT-32 is still alive and kicking as the
> default FS on a lot of small/medium flash drives, so they just might have
> retained the 4GB limit to make it easier to backup or transfer database
> files on these media.

http://blogs.msdn.com/b/stevelasker/archive/2006/11/13/doc-storage-in-sqlce-and-the-4gb-limit.aspx

indicates that it is the device ancestry that is the main cause.

Arne

[toc] | [prev] | [next] | [standalone]

#28961

On 7/5/2014 7:28 PM, Roedy Green wrote:
> On Tue, 1 Jul 2014 16:28:25 +0000 (UTC), Martin Gregorie
> <martin@address-in-sig.invalid> wrote, quoted or indirectly quoted
> someone who said :
>
>> Is there a JDBC driver or non-JDBC class library that would give a Java
>> program read/write access to the tables and schema in a MS Access
>> database?
>
> Would a solution of this form be feasible?
>
> 1. Persuade Access to export its data in some simple form, e.g. CSV
> 2. import into some more tractable database like PostGre.

If he had had a Windows system: yes. But apparently he do not.

Anyway he has found a library that can read the MDB file, so
he should be good.

Arne

[toc] | [prev] | [standalone]

Page 2 of 2 — ← Prev page 1 [2]

Back to top | Article view | comp.lang.java.programmer

csiph-web