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 Newsgroups: comp.lang.java.programmer Subject: Re: Accessing Access database files Date: Thu, 3 Jul 2014 22:03:27 +0000 (UTC) Organization: A noiseless patient Spider Lines: 36 Message-ID: References: <53b4ac9e$0$298$14726298@news.sunsite.dk> <53b5bda7$0$294$14726298@news.sunsite.dk> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Thu, 3 Jul 2014 22:03:27 +0000 (UTC) Injection-Info: mx05.eternal-september.org; posting-host="e5160e2be48f1ea550cf61512446f525"; logging-data="24490"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/NMDirtNoGozkasAArca/NaIGqPTE4ezo=" User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) Cancel-Lock: sha1:TFp4QMvc61ZvnegAgIggQpTOC1E= Xref: csiph.com comp.lang.java.programmer:28940 On Thu, 03 Jul 2014 16:31:33 -0400, Arne Vajhøj wrote: > On 7/3/2014 5:48 AM, Martin Gregorie wrote: > >> What about the JET server? > > Never heard about it. > > Google seems to indicate that it is a Solaris admin tool of some kind. > > What is it? > I think a number of products from different sources share the JET moniker but AFAIK only MS use it for a database engine. Its the database server part of MS Access. Add a graphical package to it and there's your desktop Access app. It can use ODBC to connect to other databases or to accept ODBC connections from clients. And, of course, wherever ODBC goes, JDBC can go too. More than yo ever wanted to know can be found here: https://en.wikipedia.org/wiki/Microsoft_Access I've known the name for years (it stands for Joint Engine Technology) and that it was the guts of Access but never more than that. Now you know why I was surprised and gratified to find that there is a JDBC driver that can access .MDB files without talking to the MS Jet database engine. There is also an ODBC equivalent, written in C++, to the JDBC UCanAccess driver but it can only read .mdb files. -- martin@ | Martin Gregorie gregorie. | Essex, UK org |