mdbtools-dev

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[<AR...@gm...>]

Brian Bruns wrote:
> I've noticed that sourceforge has munged the project home page too.  I
> opened a ticket with them, so hopefully they'll fix it in the next day
> or two.

Btw. SourceForge has started blocking users from "evil countries" (as if there was such a thing) in anticipatory obedience to comply with US export control.

Not such a good thing for open source. It has been discussed in many projects to look at alternatives to SF, in less restrictive countries, to not block out contributors/users.

But that's just a side note, since you are already short on time :)

Best Regards,


  Lars

PS: sorry, this was meant to go to the list anyways - I accidentally replied to you directly the first time around
-- 
GMX DSL: Internet-, Telefon- und Handy-Flat ab 19,99 EUR/mtl.  
Bis zu 150 EUR Startguthaben inklusive! http://portal.gmx.net/de/go/dsl

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[Alex H. <ba...@gm...>]

On Wed, Jun 16, 2010 at 21:08, Brian Bruns <br...@br...> wrote:
> Hi,
>
> Both reviewed and applied to the tree on github.

Awesome, Thanks!

>  I will not be updating the CVS tree anymore.  Next!

Yay! :)

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[James M. <jjm...@ea...>]

Brian Bruns wrote:
> I have repository on github that is rsync'ed from the sourceforge tree
>
> gi...@gi...:brianb/mdbtools.git
>
> I may abandon ship on the cvs and just go to that.
>
>   
Please do.  It is much easier to work with git than it is to work with CVS.

James McKenzie

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[Brian B. <br...@br...>]

Hi,

Both reviewed and applied to the tree on github.  I will not be
updating the CVS tree anymore.  Next!

I've noticed that sourceforge has munged the project home page too.  I
opened a ticket with them, so hopefully they'll fix it in the next day
or two.

Brian

2010/6/16 Alex Hunsaker <ba...@gm...>:
> On Wed, Jun 16, 2010 at 05:03, Nirgal Vourgère
> <con...@ni...> wrote:
>> Hi
>>
>> I've been trying to improve mdbtools and found it quite frustrating seeing no response at all on that mailing list... Last commit was 3 years ago.
>
> Sweet, Here are the two patches I use.  Perhaps you could add them to your list?
>
> This one fixes a segfault with long memo fields (and plain text fields for me):
> http://thread.gmane.org/gmane.comp.db.mdb-tools.devel/1193/focus=1201
>
> This one fixes (some) long ints being null:
> http://thread.gmane.org/gmane.comp.db.mdb-tools.devel/941
>
> Ive been running the later for over 5 years and the former for ~2.
>

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[Alex H. <ba...@gm...>]

On Wed, Jun 16, 2010 at 05:03, Nirgal Vourgère
<con...@ni...> wrote:
> Hi
>
> I've been trying to improve mdbtools and found it quite frustrating seeing no response at all on that mailing list... Last commit was 3 years ago.

Sweet, Here are the two patches I use.  Perhaps you could add them to your list?

This one fixes a segfault with long memo fields (and plain text fields for me):
http://thread.gmane.org/gmane.comp.db.mdb-tools.devel/1193/focus=1201

This one fixes (some) long ints being null:
http://thread.gmane.org/gmane.comp.db.mdb-tools.devel/941

Ive been running the later for over 5 years and the former for ~2.

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[Brian B. <br...@br...>]

Hi Thomas,

Let me know when you have a patch or two ready and we'll figure out
the process from there.

Brian

2010/6/16 Thomas Adam <tho...@gm...>:
> On Wed, Jun 16, 2010 at 11:29:18AM -0400, Brian Bruns wrote:
>> Hi Thomas,
>
> Hi --
>
>> Help with getting patches applied is greatly appreciated.  I'm hoping
>> to be more active in the near term.  I've had some other projects
>> taking precedence over the past year.  Like I mentioned in the last
>> email, I have a github repo, let me know if want to clone or whatever
>> and I can merge back from you or whatever you think works best.
>
> Yes -- and I've already cloned that:
>
> http://github.com/ThomasAdam/mdbtools
>
> I will do the following over time then:
>
> * Review the list of pending patches and apply them to my forked repository.
> * Implement my own patches (most of them are cleanups to be honest).
>
> I don't know how proficient you, or anyone else reading this exchange is
> with git, but I use a combination of guilt and topic-branches to manage
> these sort of work-flows --- I'll let you know what topic-branches are what
> as and when I get to publishing them -- but hopefully the names of them
> should be explanation enough.  :)
>
> -- Thomas Adam
>
> --
> "It was the cruelest game I've ever played and it's played inside my head."
> -- "Hush The Warmth", Gorky's Zygotic Mynci.
>

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[Brian B. <br...@br...>]

Hi Thomas,

Help with getting patches applied is greatly appreciated.  I'm hoping
to be more active in the near term.  I've had some other projects
taking precedence over the past year.  Like I mentioned in the last
email, I have a github repo, let me know if want to clone or whatever
and I can merge back from you or whatever you think works best.

Somebody mentioned write support.  Where I last left it was I was
working on the mdb-import utility which will allow a CSV file to be
imported into an existing table.  There is a gap in my understanding
of the allocation map which allowed me to add rows to an existing
page, but rows on newly allocated pages didn't appear when read with
Access.  I just need to find a few hours of uninterrupted time to play
and figure out what's going on there and things should start moving.


Brian

2010/6/16 Thomas Adam <th...@xt...>:
> On Wed, Jun 16, 2010 at 02:06:26PM +0100, Tim Retout wrote:
>> On 16 June 2010 13:10, Brian Bruns <br...@br...> wrote:
>> > The project has been kind of dead.  I'm hoping to find some time to
>> > get back to it real soon now.  In particular I'd be happy to look at
>> > the patches and apply them to the tree.  Actually, I'd love to get out
>> > of CVS and into something a little more modern such as git, truth be
>> > told.
>>
>> [Adding Thomas Adam to CC.]
>>
>> Just last week, I've been talking to Thomas about exactly this issue.
>> We'd like to set up a git repository and start to fix some of the more
>> obvious bugs.  Give it another week and we probably will. :)  mdbtools
>> is still a popular package (depended upon by openoffice.org-base).
>
> Yes -- I took a look at the repo on collab-maint, which is what the mdbtools
> debian package is derived from, although I would suggest that we take the
> latest CVS code from sourceforge and put it on github.
>
> I've already done this on my workstation, actually.  I suppose I could just
> go ahead and publish that to my github account [0] this evening -- probably
> makes life a bit easier, rather than vying for different repositories others
> have created.  :)
>
> I spent a couple of hours this week looking over the BTS for mdbtools as
> well as the code in general.  I am happy to say that most of the bugs, and
> perhaps more importantly, my own observations initially lend themselves well
> to quite a simple clean-up process of the code -- I've already identified, I
> think, about four or five areas where segfaults are likely to happen.  :)
>
> So... I'd be more than happy to do two things:
>
> 1. Shove the repository on github.
> 2. Push a bunch of patches out to fix segfaults.
> 3. Review patches.
>
> Although point 3, is something I'd like others to also do -- especially
> those on the PTS for mdbtools.
>
> I hope that's not sounding too push -- if it is, tell me to back off.  :)
>
> Brian -- I appreciate this might be treading on your toes somewhat, but how
> active do you think you'll be to maintain mdbtools from this point onwards?
>
> Kindly,
>
> -- Thomas Adam
>
> [0] http://www.github.com/ThomasAdam
>

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[Brian B. <br...@br...>]

I have repository on github that is rsync'ed from the sourceforge tree

gi...@gi...:brianb/mdbtools.git

I may abandon ship on the cvs and just go to that.

Brian

2010/6/16 Tim Retout <ti...@re...>:
> On 16 June 2010 13:10, Brian Bruns <br...@br...> wrote:
>> The project has been kind of dead.  I'm hoping to find some time to
>> get back to it real soon now.  In particular I'd be happy to look at
>> the patches and apply them to the tree.  Actually, I'd love to get out
>> of CVS and into something a little more modern such as git, truth be
>> told.
>
> [Adding Thomas Adam to CC.]
>
> Just last week, I've been talking to Thomas about exactly this issue.
> We'd like to set up a git repository and start to fix some of the more
> obvious bugs.  Give it another week and we probably will. :)  mdbtools
> is still a popular package (depended upon by openoffice.org-base).
>
> From the point of view of Debian, I've reached the limits of how many
> patches I can reasonably maintain on top of the latest upstream
> release.
>
> So, I guess it just needs someone to make the first move.
>
> --
> Tim Retout <ti...@re...>
>

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[Brian B. <br...@br...>]

Hi,

The project has been kind of dead.  I'm hoping to find some time to
get back to it real soon now.  In particular I'd be happy to look at
the patches and apply them to the tree.  Actually, I'd love to get out
of CVS and into something a little more modern such as git, truth be
told.

Brian

2010/6/16 Nirgal Vourgère <con...@ni...>:
> Hi
>
> I've been trying to improve mdbtools and found it quite frustrating seeing no response at all on that mailing list... Last commit was 3 years ago.
>
> This is my last message before setting up a new public repository.
>
> I now have quite a lot of patches over svn trunk, mostly from Debian:
> patches/015-allsyms
>        Add the necessary sql and odbc library dependencies.
> patches/038-removals
>        Factorisation of code for macro/module/query/report
> patches/041-eggiconlist
>        Icons, gtk
> patches/045-aboutdialog
>        Use of gtk_show_about_dialog rather than custom widget
> patches/055-iconv-config
>        Do not #include <config.h> in public headers.
> patches/056-libmdb-data
>        Prevent infinite recursion when database contains infinite floats.
> patches/070-unixodbc-api
>        Fix 64-bit issues with the ODBC support.
> patches/090-mdb-hexdump-argc
>        Get mdb-hexdump usage statement to print.
> patches/092-odbc-close-connections
>        Make odbc_close actually disconnect from the database.
> patches/094-add-man-pages
>        Add man pages for several binaries.
> patches/096-use-system-txt2man
>        Use system txt2man.
> patches/100-postgres-types
>        Fix postgres backend types (UUID, TEXT, BYTEA)
> patches/110-export-csv-null
>        Don't output "" when exporting null values.
> patches/120-decrypt
>        Support for encrypted files.
> patches/130-export-smallfloat
>        Fix for small flats
> patches/140-mdb-tables
>        Fixes in mdb-table command line tool
> patches/150-backend-quote
>        Use backend/dialect specific quotation when generating SQL, for support of spaces in tables names and other problematic characters.
> patches/155-blob
>        Support of Blobs
> patches/160-foreign-keys
>        Support for postgres foreign keys and ON UPDATE / ON DELETE.
> patches/170-sequences
>        Support for autonum as postgres sequences.
>
>
> Is there an commiter left around? Or are they all gone?
> What is their opinion of the above patches?
> Any chance to get an read/write access?
>
> I'm putting all this on http://www.nirgal.com/mdbtools/
>

Re: [mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[Walter v. H. <wal...@xs...>]

On 6/16/10 1:03 PM, Nirgal Vourgère wrote:
> Hi
>
> I've been trying to improve mdbtools and found it quite frustrating seeing no response at all on that mailing list... Last commit was 3 years ago.
>
> This is my last message before setting up a new public repository.

I would say: go for it!

Regards,

  Walter

[mdb-dev] [mdbtools-dev] Many patches, is that project dead? Fork?

[Nirgal V. <con...@ni...>]

Hi

I've been trying to improve mdbtools and found it quite frustrating seeing no response at all on that mailing list... Last commit was 3 years ago.

This is my last message before setting up a new public repository.

I now have quite a lot of patches over svn trunk, mostly from Debian:
patches/015-allsyms
	Add the necessary sql and odbc library dependencies.
patches/038-removals
	Factorisation of code for macro/module/query/report
patches/041-eggiconlist
	Icons, gtk
patches/045-aboutdialog
	Use of gtk_show_about_dialog rather than custom widget
patches/055-iconv-config
	Do not #include <config.h> in public headers.
patches/056-libmdb-data
	Prevent infinite recursion when database contains infinite floats.
patches/070-unixodbc-api
	Fix 64-bit issues with the ODBC support.
patches/090-mdb-hexdump-argc
	Get mdb-hexdump usage statement to print.
patches/092-odbc-close-connections
	Make odbc_close actually disconnect from the database.
patches/094-add-man-pages
	Add man pages for several binaries.
patches/096-use-system-txt2man
	Use system txt2man.
patches/100-postgres-types
	Fix postgres backend types (UUID, TEXT, BYTEA)
patches/110-export-csv-null
	Don't output "" when exporting null values.
patches/120-decrypt
	Support for encrypted files.
patches/130-export-smallfloat
	Fix for small flats
patches/140-mdb-tables
	Fixes in mdb-table command line tool
patches/150-backend-quote
	Use backend/dialect specific quotation when generating SQL, for support of spaces in tables names and other problematic characters.
patches/155-blob
	Support of Blobs
patches/160-foreign-keys
	Support for postgres foreign keys and ON UPDATE / ON DELETE.
patches/170-sequences
	Support for autonum as postgres sequences.


Is there an commiter left around? Or are they all gone?
What is their opinion of the above patches?
Any chance to get an read/write access?

I'm putting all this on http://www.nirgal.com/mdbtools/

Re: [mdb-dev] mdbtools compiled from source does not work where debian package does

[Levin A. <ma...@le...>]

On Fri, Apr 23, 2010 at 19:51, Kurt Schwehr <ku...@cc...> wrote:
> Hi Levin,
>
> I've got mdbtools compiling in fink on 10.6.  I'm using a version I checked out
> from sourceforge back in 2008.

I ended up making a git mirror from the CVS repository (didn't want to
deal with CVS) and built that. That worked.

$ sudo port install libtool automake autoconf bison flex
$ git clone http://github.com/levinalex/mdbtools.git
$ cd mdbtools
$ ./autogen.sh && make  # this fails [1]
$ make distclean && make # but compiling again succeeds
$ sudo make install

-Levin

[1]
/bin/sh ../../libtool --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H
-I. -I../../include  -I../../include -I/opt/local/include/glib-2.0
-I/opt/local/lib/glib-2.0/include -I/opt/local/include     -g -O2
-DSQL -MT parser.lo -MD -MP -MF .deps/parser.Tpo -c -o parser.lo
parser.c
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../include
-I../../include -I/opt/local/include/glib-2.0
-I/opt/local/lib/glib-2.0/include -I/opt/local/include -g -O2 -DSQL
-MT parser.lo -MD -MP -MF .deps/parser.Tpo -c parser.c  -fno-common
-DPIC -o .libs/parser.o
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../include
-I../../include -I/opt/local/include/glib-2.0
-I/opt/local/lib/glib-2.0/include -I/opt/local/include -g -O2 -DSQL
-MT parser.lo -MD -MP -MF .deps/parser.Tpo -c parser.c -o parser.o
>/dev/null 2>&1
mv -f .deps/parser.Tpo .deps/parser.Plo
/bin/sh ../../ylwrap lexer.l lex.yy.c lexer.c -- flex -i
/bin/sh ../../libtool --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H
-I. -I../../include  -I../../include -I/opt/local/include/glib-2.0
-I/opt/local/lib/glib-2.0/include -I/opt/local/include     -g -O2
-DSQL -MT lexer.lo -MD -MP -MF .deps/lexer.Tpo -c -o lexer.lo lexer.c
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I../../include
-I../../include -I/opt/local/include/glib-2.0
-I/opt/local/lib/glib-2.0/include -I/opt/local/include -g -O2 -DSQL
-MT lexer.lo -MD -MP -MF .deps/lexer.Tpo -c lexer.c  -fno-common -DPIC
-o .libs/lexer.o
lexer.l: In function ‘yylex’:
lexer.l:38: error: ‘OR’ undeclared (first use in this function)
lexer.l:38: error: (Each undeclared identifier is reported only once
lexer.l:38: error: for each function it appears in.)
lexer.l:39: error: ‘NOT’ undeclared (first use in this function)
lexer.l:40: error: ‘IS’ undeclared (first use in this function)
lexer.l:41: error: ‘NUL’ undeclared (first use in this function)
lexer.l:63: error: ‘IDENT’ undeclared (first use in this function)
make[2]: *** [lexer.lo] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive] Error 1

Re: [mdb-dev] mdbtools compiled from source does not work where debian package does

[Kurt S. <ku...@cc...>]

Hi Levin,

I've got mdbtools compiling in fink on 10.6.  I'm using a version I checked out
from sourceforge back in 2008.

-kurt
(goatbar)
http://schwehr.org

Re: [mdb-dev] mdbtools compiled from source does not work where debian package does

[Levin A. <ma...@le...>]

On Thu, Apr 8, 2010 at 15:51, Sam Moffatt <pa...@gm...> wrote:
> There hasn't been that much activity around. Strange that it is broken
> now on both platforms with that. Ubuntu must have some trick they use
> or similar.

I tried building the latest CVS version. This version works.
(after `aptitude uninstall flex-old; aptitude install flex`)

Why hasn't there been a release after 0.6pre1?

Thanks for your help,
Levin

Re: [mdb-dev] mdbtools compiled from source does not work where debian package does

[Sam M. <pa...@gm...>]

There hasn't been that much activity around. Strange that it is broken
now on both platforms with that. Ubuntu must have some trick they use
or similar.

Sam Moffatt
http://pasamio.id.au



On Thu, Apr 8, 2010 at 10:46 PM, Levin Alexander <ma...@le...> wrote:
> On Thu, Apr 8, 2010 at 05:05, Sam Moffatt <pa...@gm...> wrote:
>
> (sorry the reply should have gone to the list)
>
>> On your mac can you run the following command for me:
>>
>> lipo -info `which mdb-tables`
>>
>> And return what the output is?
>
>   levin@rhea:~ $ lipo -info `which mdb-tables`
>   Non-fat file: /opt/local/bin/mdb-tables is architecture: x86_64
>
>> So it is using 64-bit integers which might break it, try convincing
>> macports to compile it as i386 and see if that makes a difference.
>
> I was unable to figure out how to convince MacPorts to build
> 32bit-binaries without recompiling everything. :(
>
> But I tried building mdbtools from source on the latest 32 bit Ubuntu
> 10.4 beta (i686) It shows the same problems as the 64 bit Ubuntu.
>
> (config.log: https://gist.github.com/83c8ac9b0892eaa9d6a5)
>
>> Is your Linux install 32 bit or 64-bit?
>
> It's broken on both.
>
>
> What I'll try next is to selectively apply the debian patches to the
> sources and see which patch, if any, makes it work.
>
> Is the source on the mdbtools-sourceforge page really the current
> repository? It seems hard to believe that the last commit was 4 years
> ago.
>
> -Levin
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

Re: [mdb-dev] mdbtools compiled from source does not work where debian package does

[Levin A. <ma...@le...>]

On Thu, Apr 8, 2010 at 05:05, Sam Moffatt <pa...@gm...> wrote:

(sorry the reply should have gone to the list)

> On your mac can you run the following command for me:
>
> lipo -info `which mdb-tables`
>
> And return what the output is?

   levin@rhea:~ $ lipo -info `which mdb-tables`
   Non-fat file: /opt/local/bin/mdb-tables is architecture: x86_64

> So it is using 64-bit integers which might break it, try convincing
> macports to compile it as i386 and see if that makes a difference.

I was unable to figure out how to convince MacPorts to build
32bit-binaries without recompiling everything. :(

But I tried building mdbtools from source on the latest 32 bit Ubuntu
10.4 beta (i686) It shows the same problems as the 64 bit Ubuntu.

(config.log: https://gist.github.com/83c8ac9b0892eaa9d6a5)

> Is your Linux install 32 bit or 64-bit?

It's broken on both.


What I'll try next is to selectively apply the debian patches to the
sources and see which patch, if any, makes it work.

Is the source on the mdbtools-sourceforge page really the current
repository? It seems hard to believe that the last commit was 4 years
ago.

-Levin

Re: [mdb-dev] mdbtools compiled from source does not work where debian package does

[Sam M. <pa...@gm...>]

On your mac can you run the following command for me:

lipo -info `which mdb-tables`

And return what the output is?

Cheers,

Sam Moffatt
http://pasamio.id.au



On Thu, Apr 8, 2010 at 10:01 AM, Levin Alexander <ma...@le...> wrote:
> Hi,
>
> I have a problem with mdbtools on OSX 10.6 (installed via macports). I
> have this JET3 database that seems to be parsed correctly on my ubuntu
> box; but fails to be read correctly on OSX with the same version of
> mdbtools.
>
> For example, mdb-tables on OSX returns no tables:
>
>    levin@rhea:~ $ uname -a
>    Darwin rhea.local 10.3.0 Darwin Kernel Version 10.3.0: Fri Feb 26
> 11:58:09 PST 2010; root:xnu 1504.3.12~1/RELEASE_I386 i386
>    levin@rhea:~ $ port list mdbtools
>    mdbtools                       @0.6pre1        databases/mdbtools
>    levin@rhea:~ $ md5 db.mdb
>    MD5 (db.mdb) = c1be560bede6c55e53651f7c6e7ff2b8
>    levin@rhea:~ $ mdb-ver -M db.mdb
>    mdbtools v0.6pre1
>    JET3
>    levin@rhea:~ $ mdb-tables db.mdb
>
>    levin@rhea:~ $
>
> For comparison, here is the (correct) output from ubuntu:
>
>    levin@q:~$ uname -a
>    Linux q 2.6.24-26-generic #1 SMP Tue Dec 1 17:55:03 UTC 2009
> x86_64 GNU/Linux
>    levin@q:~$ aptitude show mdbtools | grep Version
>    Version: 0.5.99.0.6pre1.0.20051109-4
>    levin@q:~$ md5sum db.mdb
>    c1be560bede6c55e53651f7c6e7ff2b8  db.mdb
>    levin@q:~$ mdb-ver -M db.mdb
>    mdbtools v0.6pre1
>    JET3
>    levin@q:~$ mdb-tables db.mdb
>    BE BG EBM20R EBM20RA EBM20Z EBM87R EBM87Z EBM96R GOA88R GOA88Z
> GOA96R GOA96RAS GOA96Z KAPITEL KEYS EBM20RAS EBM96Z GOA96RA KEYTABS
>    levin@q:~$
>
> Something is clearly wrong,
>
> (Further testing shows that the current mdbtools from sourceforge
> compiled from source on the ubuntu box also gives the incorrect
> results. The problem therefore seems to be fixed by one of the patches
> to the debian mdbtools package [1] but nothing jumps out)
>
> Anyone have seen this kind of problem before or have an idea how to debug this?
>
>
> Thank you,
> Levin Alexander
>
> [1] http://packages.debian.org/changelogs/pool/main/m/mdbtools/mdbtools_0.5.99.0.6pre1.0.20051109-6/changelog
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

[mdb-dev] mdbtools compiled from source does not work where debian package does

[Levin A. <ma...@le...>]

Hi,

I have a problem with mdbtools on OSX 10.6 (installed via macports). I
have this JET3 database that seems to be parsed correctly on my ubuntu
box; but fails to be read correctly on OSX with the same version of
mdbtools.

For example, mdb-tables on OSX returns no tables:

    levin@rhea:~ $ uname -a
    Darwin rhea.local 10.3.0 Darwin Kernel Version 10.3.0: Fri Feb 26
11:58:09 PST 2010; root:xnu 1504.3.12~1/RELEASE_I386 i386
    levin@rhea:~ $ port list mdbtools
    mdbtools                       @0.6pre1        databases/mdbtools
    levin@rhea:~ $ md5 db.mdb
    MD5 (db.mdb) = c1be560bede6c55e53651f7c6e7ff2b8
    levin@rhea:~ $ mdb-ver -M db.mdb
    mdbtools v0.6pre1
    JET3
    levin@rhea:~ $ mdb-tables db.mdb

    levin@rhea:~ $

For comparison, here is the (correct) output from ubuntu:

    levin@q:~$ uname -a
    Linux q 2.6.24-26-generic #1 SMP Tue Dec 1 17:55:03 UTC 2009
x86_64 GNU/Linux
    levin@q:~$ aptitude show mdbtools | grep Version
    Version: 0.5.99.0.6pre1.0.20051109-4
    levin@q:~$ md5sum db.mdb
    c1be560bede6c55e53651f7c6e7ff2b8  db.mdb
    levin@q:~$ mdb-ver -M db.mdb
    mdbtools v0.6pre1
    JET3
    levin@q:~$ mdb-tables db.mdb
    BE BG EBM20R EBM20RA EBM20Z EBM87R EBM87Z EBM96R GOA88R GOA88Z
GOA96R GOA96RAS GOA96Z KAPITEL KEYS EBM20RAS EBM96Z GOA96RA KEYTABS
    levin@q:~$

Something is clearly wrong,

(Further testing shows that the current mdbtools from sourceforge
compiled from source on the ubuntu box also gives the incorrect
results. The problem therefore seems to be fixed by one of the patches
to the debian mdbtools package [1] but nothing jumps out)

Anyone have seen this kind of problem before or have an idea how to debug this?


Thank you,
Levin Alexander

[1] http://packages.debian.org/changelogs/pool/main/m/mdbtools/mdbtools_0.5.99.0.6pre1.0.20051109-6/changelog

Re: [mdb-dev] Error

[Alexander L. <le...@ed...>]

Hi Mateo,

could you please post a stacktrace and/or an example how to reproduce?

It might be a corrupted database or a mdbtools bug, or you are in fact 
really out of memory.

I've got no knowledge about mdbtools in deep, but i was getting rid of the 
glib dependencies and replaced it with my own implementation, so maybe 
there is a chance to find out what happens...

Regards,

Alex.


On Wed, 24 Feb 2010, Mateo Martinez wrote:

> Dear all,
>
> I´ve the following error while importing a DB..
>
> *(process:xxxxxxx): GLib-ERROR (recursed) **: gmem.c:175: failed to
> allocate 4096 bytes.
>
> What can I do?
>
> Thanks.
> Regards,
>
> Mateo
>

[mdb-dev] Error

[Mateo M. <mat...@gm...>]

Dear all,

I´ve the following error while importing a DB..

*(process:xxxxxxx): GLib-ERROR (recursed) **: gmem.c:175: failed to
allocate 4096 bytes.

What can I do?

Thanks.
Regards,

Mateo

[mdb-dev] Status of Write Support?

[Nigel K. <sup...@pe...>]

(Original went direct to Martin - sorry!)

Hi,

I have just returned from site where we've migrated the last of our
Access-based client management systems to a new one with an MS-SQL back-end
and Java front-end. Regrettably, the app devs have made the java so
Windows-oriented that it won't run on a Linux client, but I will be having
words with them!

Anyway, I used mdb-tools for a long time to pull data from the remote sites
into a single MySQL database for reporting, but that platform will be phased
out Q1 2010. All that remains is to say a big 'thanks' to the mdb-tools
developers for some extremely useful software that made my job much easier.

Nigel Kendrick
Pet Doctors Veterinary Clinics, UK.

Re: [mdb-dev] FW: Status of Write Support?

[Martin E. <ma...@el...>]

On Fri, Oct 23, 2009 at 2:53 PM, Lenny Leblanc <lle...@ma...> wrote:
> I still see this project as being important to Linux adoption overall.
> People have access databases and without a way of at least converting them
> this is a major hurdle for Linux to overcome.  Even if most people wouldn’t
> use this command line tool directly, I can see the potential for this engine
> to be used in GUI environments in the future.

Don't know about the future, but the last time I looked both
OpenOffice Base and Kexi were using mdbtools for MDB import.

I think there's also a small GUI application included in the
mdbtools repository.

Martin

Re: [mdb-dev] FW: Status of Write Support?

[Peter <ze...@ru...>]

You might be able to utilize JNI. Check out:

http://www.codeproject.com/KB/cpp/CJniJava.aspx

My project required pretty much standalone MDB <-> Postgres data  
converter so I was able to switch to Java easily, and later reuse the  
same code in Tomcat servlet.


> Hey Peter,
>
> Thanks for posting this.  For my purposes I need C (or C++ may be  
> OK), but
> if it has write support it certainly should be possible to port from  
> this
> project to MDB Tools.
>
> I'll take a look at it and see how it will help.
>
> Thanks again,
>
> Dion
>
>
> On 10/24/09 1:28 PM, "Peter" <ze...@ru...> wrote:
>
>> I dont think implementing write support is worth the extra effort.
>> Java Jackcess library is much more mature and provides write
>> functionality - I dumped mdbtools in favor of Jackcess a long time
>> ago, never looked back.
>>
>>> Hi all,
>>>
>>> I must confess, the biggest problem with the status of the project  
>>> is
>>> a lack of time on my part.  I have too much paid work right now  
>>> (not a
>>> bad thing) to have time to work on it.
>>>
>>> The status of writing is more or less this:
>>>
>>> 1. "In place updates", those which don't require a page split, are
>>> working.
>>> 2. Row insertion has some code written, which takes CSV style data,
>>> packs into MDB format, does the page management (allocates new  
>>> pages,
>>> writes the row pointers, updates the free list, etc...).  The  
>>> problem
>>> is we are missing some understanding of the MDB file format because
>>> Access/JET doesn't see the newly inserted rows.
>>> 3. Creating new tables and so forth is not even started yet, there  
>>> are
>>> still a few too many magic values in the table structure to give a
>>> good estimate on when if ever this may be possible.
>>>
>>> My main goal I was pushing for was to create an "mdb-import" program
>>> that would take a CSV formatted file and import it into an already
>>> existing table structure.  This goal is presumably not that far off,
>>> but requires some further research of the file format which is  
>>> tedious
>>> work.  SQL insert/update support would be a follow-on sometime after
>>> that.
>>>
>>> Brian
>>>
>>> 2009/10/23 Lenny Leblanc <lle...@ma...>:
>>>> Hey All,
>>>>
>>>>
>>>>
>>>> I joined this list years ago and did a little bit of work on the
>>>> package in
>>>> creating a mdb-queries routine which allowed some work with the
>>>> queries in
>>>> Access.
>>>>
>>>>
>>>>
>>>> My memory isn’t so great but I think the biggest challenge back
>>>> then was the
>>>> ever changing file formats that access used and the developers had
>>>> a hard
>>>> time keeping up.  Combine this with the fact that all of this is
>>>> considered
>>>> proprietary so Microsoft has no intention of releasing their file
>>>> formats to
>>>> make life easier.
>>>>
>>>>
>>>>
>>>> I still see this project as being important to Linux adoption
>>>> overall.
>>>> People have access databases and without a way of at least
>>>> converting them
>>>> this is a major hurdle for Linux to overcome.  Even if most people
>>>> wouldn’t
>>>> use this command line tool directly, I can see the potential for
>>>> this engine
>>>> to be used in GUI environments in the future.
>>>>
>>>>
>>>>
>>>> Anyway, just wanted to throw in my $0.02.  Nice to see some traffic
>>>> on this
>>>> list for once J
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Lenny
>>>>
>>>>
>>>>
>>>> From: Peter Benjamin Volk [mailto:pe...@dd...]
>>>> Sent: Friday, October 23, 2009 3:33 AM
>>>> To: Houston, Dion A Sr CPT MIL USA TRADOC
>>>> Cc: mdb...@li...
>>>> Subject: Re: [mdb-dev] FW: Status of Write Support?
>>>>
>>>>
>>>>
>>>> Hey,
>>>>
>>>> I tried to contact the original developers about a year ago but did
>>>> not get
>>>> any reaction. In one of our projects we have a plan to continue to
>>>> develop
>>>> the mdbtools a bit. We have not gooten to far with it since other
>>>> things got
>>>> in our way. Seeing this project get back to live would be great.
>>>>
>>>> Cheers,
>>>> Peter
>>>>
>>>> Houston, Dion A Sr CPT MIL USA TRADOC wrote:
>>>>
>>>> Ooops, guess I sent this directly to Murray instead of the list...
>>>> Resending...
>>>>
>>>> Dion
>>>> ------ Forwarded Message
>>>> From: Dion Houston <dio...@us...>
>>>> Date: Thu, 22 Oct 2009 20:30:58 -0400
>>>> To: Murray Collingwood <mu...@fo...>
>>>> Subject: RE: [mdb-dev] Status of Write Support?
>>>>
>>>> OK, well I'll first state my bias.  The Jet database engine will
>>>> always have
>>>> a special place in my heart.  I still remember the excitement I had
>>>> when
>>>> Access 1.0 came out (I had been doing database work since dBase II
>>>> under
>>>> CP/M).  Later I had the chance to work in the Jet database group
>>>> which
>>>> provided my living for several years.  So my opinion is by no means
>>>> unbiased.  Jet, especially for the times, was an amazing
>>>> accomplishment.  It
>>>> really marked the first time a high performance database engine was
>>>> available essentially for free.
>>>>
>>>> MDB Tools is no Jet.  Nor do I think it was ever meant to be.  But
>>>> I would
>>>> definitely say there is a place for write support if for nothing
>>>> else than
>>>> interoperability.  In my case I'm hoping to enable people to use
>>>> the latest
>>>> and greatest data file formats with an older system.
>>>>
>>>> I've reviewed the code base and I believe it's a reasonable short
>>>> term
>>>> project to at least provide a Create Table function and the ability
>>>> to write
>>>> forward-only into that table.  This is the minimal requirements
>>>> that will
>>>> meet my needs.
>>>>
>>>> If anyone has an interest in this level functionality please let me
>>>> know.
>>>>
>>>> Also, if any of the original developers are lurking around on this
>>>> list,
>>>> thanks for all you've done so far!
>>>>
>>>> Dion
>>>>
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: Murray Collingwood <mu...@fo...>
>>>> Sent: Thursday, October 22, 2009 7:43 PM
>>>> To: mdb...@li... <mdb...@li...
>>>>>
>>>> Subject: Re: [mdb-dev] Status of Write Support?
>>>>
>>>> Hi guys
>>>>
>>>> I agree with Alex.  Actually, I think this read-only ability may be
>>>> part of
>>>> the plan to extract as much data out of Access as possible without
>>>> the
>>>> ability to put it back.  Frankly, I think it's a good plan.  The
>>>> sooner we
>>>> get rid of Access the better.
>>>>
>>>> Cheers
>>>> mc
>>>>
>>>>
>>>> 2009/10/23 Alexander Lehner <le...@ed...>
>>>>
>>>> Hi Houston, Dion A Sr CPT MIL USA TRADO,
>>>>
>>>> just wanted to let you know that I'm reading this mailing list for
>>>> more
>>>> than 1 year now and got about 2 or 3 posts so far.
>>>> mdbtools development seems to be dead somehow; reading works for my
>>>> usage,
>>>> writing - I don't know.
>>>> But I would not expect too much support for any further  
>>>> development.
>>>> Pretty sad for a cool project...
>>>>
>>>> Alex.
>>>>
>>>>
>>>>
>>>>
>>>> On Sat, 17 Oct 2009, Houston, Dion A Sr CPT MIL USA TRADOC wrote:
>>>>
>>>>> Hi all,
>>>>>
>>>>> I finally resolved my CVS issues with this project and have the
>>>>> latest
>>>>> source compiled for OS X Snow Leopard.  I see that there is a
>>>>> write.c that
>>>>> apparently has at least some support for writing.
>>>>>
>>>>> I am new to this project, and noticed that there is very little
>>>>> documentation.  My questions are:
>>>>>
>>>>>
>>>>> *   What is the level of write support currently in the CVS tree?
>>>>> *   How do you use it? (preferably a code snippet)
>>>>> *   Are there any more detailed docs on the API design?
>>>>>
>>>>> My particular application is to convert multiple file formats to
>>>>> and from
>>>>> a particular MDB database format in a cross platform way.  For
>>>>> converting to
>>>>> this MDB format I do not require random access, nor SQL, nor
>>>>> anything else.
>>>>> It would be nice to be able to create databases as well, but I can
>>>>> certainly place an empty database into a folder and just add the
>>>>> necessary
>>>>> table.
>>>>>
>>>>> Thanks in advance for any assistance,
>>>>>
>>>>> Dion
>>>>>
>>>>
>>>> ----------------------------------------------------------------------------
>>>> --
>>>> Come build with us! The BlackBerry(R) Developer Conference in SF,  
>>>> CA
>>>> is the only developer event you need to attend this year. Jumpstart
>>>> your
>>>> developing skills, take BlackBerry mobile applications to market
>>>> and stay
>>>> ahead of the curve. Join us from November 9 - 12, 2009. Register  
>>>> now!
>>>> http://p.sf.net/sfu/devconference
>>>> _______________________________________________
>>>> mdbtools-dev mailing list
>>>> mdb...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>>>
>>>>
>>>> --
>>>> Murray Collingwood
>>>> Focus Computing
>>>> p +61 415 24 26 24
>>>> http://www.focus-computing.com.au
>>>>
>>>>
>>>> ------ End of Forwarded Message
>>>>
>>>>
>>>>
>>>> ________________________________
>>>>
>>>>
>>>>
>>>> ----------------------------------------------------------------------------
>>>> --
>>>>
>>>> Come build with us! The BlackBerry(R) Developer Conference in SF,  
>>>> CA
>>>>
>>>> is the only developer event you need to attend this year. Jumpstart
>>>> your
>>>>
>>>> developing skills, take BlackBerry mobile applications to market
>>>> and stay
>>>>
>>>> ahead of the curve. Join us from November 9 - 12, 2009. Register  
>>>> now!
>>>>
>>>> http://p.sf.net/sfu/devconference
>>>>
>>>>
>>>>
>>>> ________________________________
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>>
>>>> mdbtools-dev mailing list
>>>>
>>>> mdb...@li...
>>>>
>>>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Peter Benjamin Volk
>>>>
>>>> Project Lead
>>>>
>>>>
>>>>
>>>>   DDEngine.org
>>>>
>>>>   An open source project
>>>>
>>>>   Phone:  [+49] (0) 351 862 9566
>>>>
>>>>   mailto:pe...@dd...
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>   Bunsenstraße 3  | D-01139 Dresden | GERMANY
>>>>
>>>> ***********************************************************
>>>>
>>>>
>>>>
>>>> Diese Mail einschliesslich der Anhänge könnte vertraulich sein.
>>>> Sollten Sie
>>>> nicht der beabsichtigte Empfänger dieser Mail sein, so ist  
>>>> jegliches
>>>> Verwenden, Offenbaren oder Kopieren der Mail und ihrer Anhänge
>>>> untersagt.
>>>> Bitte informieren Sie den Absender und löschen Sie die Mail und  
>>>> deren
>>>> Anhänge von Ihrem Rechner. Vielen Dank.
>>>>
>>>>
>>>>
>>>> This email and its attachments may be confidential and/or
>>>> privileged. If you
>>>> are not the intended recipient, any use, disclosure or copying of
>>>> this email
>>>> and its attachments is prohibited. If you have received this email
>>>> in error,
>>>> please notify immediately the sender by return email and delete
>>>> this email
>>>> and its attachments from your computer system. Thank you.
>>>>
>>>> ----------------------------------------------------------------------------
>>>> --
>>>> Come build with us! The BlackBerry(R) Developer Conference in SF,  
>>>> CA
>>>> is the only developer event you need to attend this year. Jumpstart
>>>> your
>>>> developing skills, take BlackBerry mobile applications to market
>>>> and stay
>>>> ahead of the curve. Join us from November 9 - 12, 2009. Register  
>>>> now!
>>>> http://p.sf.net/sfu/devconference
>>>> _______________________________________________
>>>> mdbtools-dev mailing list
>>>> mdb...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>>>
>>>>
>>>
>>>
> -----------------------------------------------------------------------------> 
> >
> -
>>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>>> is the only developer event you need to attend this year. Jumpstart
>>> your
>>> developing skills, take BlackBerry mobile applications to market and
>>> stay
>>> ahead of the curve. Join us from November 9 - 12, 2009. Register  
>>> now!
>>> http://p.sf.net/sfu/devconference
>>> _______________________________________________
>>> mdbtools-dev mailing list
>>> mdb...@li...
>>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>> is the only developer event you need to attend this year. Jumpstart  
>> your
>> developing skills, take BlackBerry mobile applications to market  
>> and stay
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> http://p.sf.net/sfu/devconference
>> _______________________________________________
>> mdbtools-dev mailing list
>> mdb...@li...
>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

Re: [mdb-dev] FW: Status of Write Support?

[Houston, D. A Sr C. M. U. T. <dio...@us...>]

Hey Peter,

Thanks for posting this.  For my purposes I need C (or C++ may be OK), but
if it has write support it certainly should be possible to port from this
project to MDB Tools.

I'll take a look at it and see how it will help.

Thanks again,

Dion


On 10/24/09 1:28 PM, "Peter" <ze...@ru...> wrote:

> I dont think implementing write support is worth the extra effort.
> Java Jackcess library is much more mature and provides write
> functionality - I dumped mdbtools in favor of Jackcess a long time
> ago, never looked back.
> 
>> Hi all,
>> 
>> I must confess, the biggest problem with the status of the project is
>> a lack of time on my part.  I have too much paid work right now (not a
>> bad thing) to have time to work on it.
>> 
>> The status of writing is more or less this:
>> 
>> 1. "In place updates", those which don't require a page split, are
>> working.
>> 2. Row insertion has some code written, which takes CSV style data,
>> packs into MDB format, does the page management (allocates new pages,
>> writes the row pointers, updates the free list, etc...).  The problem
>> is we are missing some understanding of the MDB file format because
>> Access/JET doesn't see the newly inserted rows.
>> 3. Creating new tables and so forth is not even started yet, there are
>> still a few too many magic values in the table structure to give a
>> good estimate on when if ever this may be possible.
>> 
>> My main goal I was pushing for was to create an "mdb-import" program
>> that would take a CSV formatted file and import it into an already
>> existing table structure.  This goal is presumably not that far off,
>> but requires some further research of the file format which is tedious
>> work.  SQL insert/update support would be a follow-on sometime after
>> that.
>> 
>> Brian
>> 
>> 2009/10/23 Lenny Leblanc <lle...@ma...>:
>>> Hey All,
>>> 
>>> 
>>> 
>>> I joined this list years ago and did a little bit of work on the
>>> package in
>>> creating a mdb-queries routine which allowed some work with the
>>> queries in
>>> Access.
>>> 
>>> 
>>> 
>>> My memory isn¹t so great but I think the biggest challenge back
>>> then was the
>>> ever changing file formats that access used and the developers had
>>> a hard
>>> time keeping up.  Combine this with the fact that all of this is
>>> considered
>>> proprietary so Microsoft has no intention of releasing their file
>>> formats to
>>> make life easier.
>>> 
>>> 
>>> 
>>> I still see this project as being important to Linux adoption
>>> overall.
>>> People have access databases and without a way of at least
>>> converting them
>>> this is a major hurdle for Linux to overcome.  Even if most people
>>> wouldn¹t
>>> use this command line tool directly, I can see the potential for
>>> this engine
>>> to be used in GUI environments in the future.
>>> 
>>> 
>>> 
>>> Anyway, just wanted to throw in my $0.02.  Nice to see some traffic
>>> on this
>>> list for once J
>>> 
>>> 
>>> 
>>> --
>>> 
>>> Lenny
>>> 
>>> 
>>> 
>>> From: Peter Benjamin Volk [mailto:pe...@dd...]
>>> Sent: Friday, October 23, 2009 3:33 AM
>>> To: Houston, Dion A Sr CPT MIL USA TRADOC
>>> Cc: mdb...@li...
>>> Subject: Re: [mdb-dev] FW: Status of Write Support?
>>> 
>>> 
>>> 
>>> Hey,
>>> 
>>> I tried to contact the original developers about a year ago but did
>>> not get
>>> any reaction. In one of our projects we have a plan to continue to
>>> develop
>>> the mdbtools a bit. We have not gooten to far with it since other
>>> things got
>>> in our way. Seeing this project get back to live would be great.
>>> 
>>> Cheers,
>>> Peter
>>> 
>>> Houston, Dion A Sr CPT MIL USA TRADOC wrote:
>>> 
>>> Ooops, guess I sent this directly to Murray instead of the list...
>>> Resending...
>>> 
>>> Dion
>>> ------ Forwarded Message
>>> From: Dion Houston <dio...@us...>
>>> Date: Thu, 22 Oct 2009 20:30:58 -0400
>>> To: Murray Collingwood <mu...@fo...>
>>> Subject: RE: [mdb-dev] Status of Write Support?
>>> 
>>> OK, well I'll first state my bias.  The Jet database engine will
>>> always have
>>> a special place in my heart.  I still remember the excitement I had
>>> when
>>> Access 1.0 came out (I had been doing database work since dBase II
>>> under
>>> CP/M).  Later I had the chance to work in the Jet database group
>>> which
>>> provided my living for several years.  So my opinion is by no means
>>> unbiased.  Jet, especially for the times, was an amazing
>>> accomplishment.  It
>>> really marked the first time a high performance database engine was
>>> available essentially for free.
>>> 
>>> MDB Tools is no Jet.  Nor do I think it was ever meant to be.  But
>>> I would
>>> definitely say there is a place for write support if for nothing
>>> else than
>>> interoperability.  In my case I'm hoping to enable people to use
>>> the latest
>>> and greatest data file formats with an older system.
>>> 
>>> I've reviewed the code base and I believe it's a reasonable short
>>> term
>>> project to at least provide a Create Table function and the ability
>>> to write
>>> forward-only into that table.  This is the minimal requirements
>>> that will
>>> meet my needs.
>>> 
>>> If anyone has an interest in this level functionality please let me
>>> know.
>>> 
>>> Also, if any of the original developers are lurking around on this
>>> list,
>>> thanks for all you've done so far!
>>> 
>>> Dion
>>> 
>>> 
>>> 
>>> -----Original Message-----
>>> From: Murray Collingwood <mu...@fo...>
>>> Sent: Thursday, October 22, 2009 7:43 PM
>>> To: mdb...@li... <mdb...@li...
>>>> 
>>> Subject: Re: [mdb-dev] Status of Write Support?
>>> 
>>> Hi guys
>>> 
>>> I agree with Alex.  Actually, I think this read-only ability may be
>>> part of
>>> the plan to extract as much data out of Access as possible without
>>> the
>>> ability to put it back.  Frankly, I think it's a good plan.  The
>>> sooner we
>>> get rid of Access the better.
>>> 
>>> Cheers
>>> mc
>>> 
>>> 
>>> 2009/10/23 Alexander Lehner <le...@ed...>
>>> 
>>> Hi Houston, Dion A Sr CPT MIL USA TRADO,
>>> 
>>> just wanted to let you know that I'm reading this mailing list for
>>> more
>>> than 1 year now and got about 2 or 3 posts so far.
>>> mdbtools development seems to be dead somehow; reading works for my
>>> usage,
>>> writing - I don't know.
>>> But I would not expect too much support for any further development.
>>> Pretty sad for a cool project...
>>> 
>>> Alex.
>>> 
>>> 
>>> 
>>> 
>>> On Sat, 17 Oct 2009, Houston, Dion A Sr CPT MIL USA TRADOC wrote:
>>> 
>>>> Hi all,
>>>> 
>>>> I finally resolved my CVS issues with this project and have the
>>>> latest
>>>> source compiled for OS X Snow Leopard.  I see that there is a
>>>> write.c that
>>>> apparently has at least some support for writing.
>>>> 
>>>> I am new to this project, and noticed that there is very little
>>>> documentation.  My questions are:
>>>> 
>>>> 
>>>>  *   What is the level of write support currently in the CVS tree?
>>>>  *   How do you use it? (preferably a code snippet)
>>>>  *   Are there any more detailed docs on the API design?
>>>> 
>>>> My particular application is to convert multiple file formats to
>>>> and from
>>>> a particular MDB database format in a cross platform way.  For
>>>> converting to
>>>> this MDB format I do not require random access, nor SQL, nor
>>>> anything else.
>>>>  It would be nice to be able to create databases as well, but I can
>>>> certainly place an empty database into a folder and just add the
>>>> necessary
>>>> table.
>>>> 
>>>> Thanks in advance for any assistance,
>>>> 
>>>> Dion
>>>> 
>>> 
>>> ----------------------------------------------------------------------------
>>> --
>>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>>> is the only developer event you need to attend this year. Jumpstart
>>> your
>>> developing skills, take BlackBerry mobile applications to market
>>> and stay
>>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>>> http://p.sf.net/sfu/devconference
>>> _______________________________________________
>>> mdbtools-dev mailing list
>>> mdb...@li...
>>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>> 
>>> 
>>> --
>>> Murray Collingwood
>>> Focus Computing
>>> p +61 415 24 26 24
>>> http://www.focus-computing.com.au
>>> 
>>> 
>>> ------ End of Forwarded Message
>>> 
>>> 
>>> 
>>> ________________________________
>>> 
>>> 
>>> 
>>> ----------------------------------------------------------------------------
>>> --
>>> 
>>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>>> 
>>> is the only developer event you need to attend this year. Jumpstart
>>> your
>>> 
>>> developing skills, take BlackBerry mobile applications to market
>>> and stay
>>> 
>>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>>> 
>>> http://p.sf.net/sfu/devconference
>>> 
>>> 
>>> 
>>> ________________________________
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> 
>>> mdbtools-dev mailing list
>>> 
>>> mdb...@li...
>>> 
>>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>> 
>>> 
>>> 
>>> 
>>> --
>>> 
>>> Peter Benjamin Volk
>>> 
>>> Project Lead
>>> 
>>> 
>>> 
>>>    DDEngine.org
>>> 
>>>    An open source project
>>> 
>>>    Phone:  [+49] (0) 351 862 9566
>>> 
>>>    mailto:pe...@dd...
>>> 
>>> 
>>> 
>>> 
>>> 
>>>    Bunsenstraße 3  | D-01139 Dresden | GERMANY
>>> 
>>> ***********************************************************
>>> 
>>> 
>>> 
>>> Diese Mail einschliesslich der Anhänge könnte vertraulich sein.
>>> Sollten Sie
>>> nicht der beabsichtigte Empfänger dieser Mail sein, so ist jegliches
>>> Verwenden, Offenbaren oder Kopieren der Mail und ihrer Anhänge
>>> untersagt.
>>> Bitte informieren Sie den Absender und löschen Sie die Mail und deren
>>> Anhänge von Ihrem Rechner. Vielen Dank.
>>> 
>>> 
>>> 
>>> This email and its attachments may be confidential and/or
>>> privileged. If you
>>> are not the intended recipient, any use, disclosure or copying of
>>> this email
>>> and its attachments is prohibited. If you have received this email
>>> in error,
>>> please notify immediately the sender by return email and delete
>>> this email
>>> and its attachments from your computer system. Thank you.
>>> 
>>> ----------------------------------------------------------------------------
>>> --
>>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>>> is the only developer event you need to attend this year. Jumpstart
>>> your
>>> developing skills, take BlackBerry mobile applications to market
>>> and stay
>>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>>> http://p.sf.net/sfu/devconference
>>> _______________________________________________
>>> mdbtools-dev mailing list
>>> mdb...@li...
>>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>> 
>>> 
>> 
>> 
----------------------------------------------------------------------------->>
-
>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>> is the only developer event you need to attend this year. Jumpstart
>> your
>> developing skills, take BlackBerry mobile applications to market and
>> stay
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> http://p.sf.net/sfu/devconference
>> _______________________________________________
>> mdbtools-dev mailing list
>> mdb...@li...
>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>> 
> 
> 
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: [mdb-dev] FW: Status of Write Support?

[Peter <ze...@ru...>]

I dont think implementing write support is worth the extra effort.  
Java Jackcess library is much more mature and provides write  
functionality - I dumped mdbtools in favor of Jackcess a long time  
ago, never looked back.

> Hi all,
>
> I must confess, the biggest problem with the status of the project is
> a lack of time on my part.  I have too much paid work right now (not a
> bad thing) to have time to work on it.
>
> The status of writing is more or less this:
>
> 1. "In place updates", those which don't require a page split, are  
> working.
> 2. Row insertion has some code written, which takes CSV style data,
> packs into MDB format, does the page management (allocates new pages,
> writes the row pointers, updates the free list, etc...).  The problem
> is we are missing some understanding of the MDB file format because
> Access/JET doesn't see the newly inserted rows.
> 3. Creating new tables and so forth is not even started yet, there are
> still a few too many magic values in the table structure to give a
> good estimate on when if ever this may be possible.
>
> My main goal I was pushing for was to create an "mdb-import" program
> that would take a CSV formatted file and import it into an already
> existing table structure.  This goal is presumably not that far off,
> but requires some further research of the file format which is tedious
> work.  SQL insert/update support would be a follow-on sometime after
> that.
>
> Brian
>
> 2009/10/23 Lenny Leblanc <lle...@ma...>:
>> Hey All,
>>
>>
>>
>> I joined this list years ago and did a little bit of work on the  
>> package in
>> creating a mdb-queries routine which allowed some work with the  
>> queries in
>> Access.
>>
>>
>>
>> My memory isn’t so great but I think the biggest challenge back  
>> then was the
>> ever changing file formats that access used and the developers had  
>> a hard
>> time keeping up.  Combine this with the fact that all of this is  
>> considered
>> proprietary so Microsoft has no intention of releasing their file  
>> formats to
>> make life easier.
>>
>>
>>
>> I still see this project as being important to Linux adoption  
>> overall.
>> People have access databases and without a way of at least  
>> converting them
>> this is a major hurdle for Linux to overcome.  Even if most people  
>> wouldn’t
>> use this command line tool directly, I can see the potential for  
>> this engine
>> to be used in GUI environments in the future.
>>
>>
>>
>> Anyway, just wanted to throw in my $0.02.  Nice to see some traffic  
>> on this
>> list for once J
>>
>>
>>
>> --
>>
>> Lenny
>>
>>
>>
>> From: Peter Benjamin Volk [mailto:pe...@dd...]
>> Sent: Friday, October 23, 2009 3:33 AM
>> To: Houston, Dion A Sr CPT MIL USA TRADOC
>> Cc: mdb...@li...
>> Subject: Re: [mdb-dev] FW: Status of Write Support?
>>
>>
>>
>> Hey,
>>
>> I tried to contact the original developers about a year ago but did  
>> not get
>> any reaction. In one of our projects we have a plan to continue to  
>> develop
>> the mdbtools a bit. We have not gooten to far with it since other  
>> things got
>> in our way. Seeing this project get back to live would be great.
>>
>> Cheers,
>> Peter
>>
>> Houston, Dion A Sr CPT MIL USA TRADOC wrote:
>>
>> Ooops, guess I sent this directly to Murray instead of the list...
>> Resending...
>>
>> Dion
>> ------ Forwarded Message
>> From: Dion Houston <dio...@us...>
>> Date: Thu, 22 Oct 2009 20:30:58 -0400
>> To: Murray Collingwood <mu...@fo...>
>> Subject: RE: [mdb-dev] Status of Write Support?
>>
>> OK, well I'll first state my bias.  The Jet database engine will  
>> always have
>> a special place in my heart.  I still remember the excitement I had  
>> when
>> Access 1.0 came out (I had been doing database work since dBase II  
>> under
>> CP/M).  Later I had the chance to work in the Jet database group  
>> which
>> provided my living for several years.  So my opinion is by no means
>> unbiased.  Jet, especially for the times, was an amazing  
>> accomplishment.  It
>> really marked the first time a high performance database engine was
>> available essentially for free.
>>
>> MDB Tools is no Jet.  Nor do I think it was ever meant to be.  But  
>> I would
>> definitely say there is a place for write support if for nothing  
>> else than
>> interoperability.  In my case I'm hoping to enable people to use  
>> the latest
>> and greatest data file formats with an older system.
>>
>> I've reviewed the code base and I believe it's a reasonable short  
>> term
>> project to at least provide a Create Table function and the ability  
>> to write
>> forward-only into that table.  This is the minimal requirements  
>> that will
>> meet my needs.
>>
>> If anyone has an interest in this level functionality please let me  
>> know.
>>
>> Also, if any of the original developers are lurking around on this  
>> list,
>> thanks for all you've done so far!
>>
>> Dion
>>
>>
>>
>> -----Original Message-----
>> From: Murray Collingwood <mu...@fo...>
>> Sent: Thursday, October 22, 2009 7:43 PM
>> To: mdb...@li... <mdb...@li... 
>> >
>> Subject: Re: [mdb-dev] Status of Write Support?
>>
>> Hi guys
>>
>> I agree with Alex.  Actually, I think this read-only ability may be  
>> part of
>> the plan to extract as much data out of Access as possible without  
>> the
>> ability to put it back.  Frankly, I think it's a good plan.  The  
>> sooner we
>> get rid of Access the better.
>>
>> Cheers
>> mc
>>
>>
>> 2009/10/23 Alexander Lehner <le...@ed...>
>>
>> Hi Houston, Dion A Sr CPT MIL USA TRADO,
>>
>> just wanted to let you know that I'm reading this mailing list for  
>> more
>> than 1 year now and got about 2 or 3 posts so far.
>> mdbtools development seems to be dead somehow; reading works for my  
>> usage,
>> writing - I don't know.
>> But I would not expect too much support for any further development.
>> Pretty sad for a cool project...
>>
>> Alex.
>>
>>
>>
>>
>> On Sat, 17 Oct 2009, Houston, Dion A Sr CPT MIL USA TRADOC wrote:
>>
>>> Hi all,
>>>
>>> I finally resolved my CVS issues with this project and have the  
>>> latest
>>> source compiled for OS X Snow Leopard.  I see that there is a  
>>> write.c that
>>> apparently has at least some support for writing.
>>>
>>> I am new to this project, and noticed that there is very little
>>> documentation.  My questions are:
>>>
>>>
>>>  *   What is the level of write support currently in the CVS tree?
>>>  *   How do you use it? (preferably a code snippet)
>>>  *   Are there any more detailed docs on the API design?
>>>
>>> My particular application is to convert multiple file formats to  
>>> and from
>>> a particular MDB database format in a cross platform way.  For  
>>> converting to
>>> this MDB format I do not require random access, nor SQL, nor  
>>> anything else.
>>>  It would be nice to be able to create databases as well, but I can
>>> certainly place an empty database into a folder and just add the  
>>> necessary
>>> table.
>>>
>>> Thanks in advance for any assistance,
>>>
>>> Dion
>>>
>>
>> ------------------------------------------------------------------------------
>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>> is the only developer event you need to attend this year. Jumpstart  
>> your
>> developing skills, take BlackBerry mobile applications to market  
>> and stay
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> http://p.sf.net/sfu/devconference
>> _______________________________________________
>> mdbtools-dev mailing list
>> mdb...@li...
>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>
>>
>> --
>> Murray Collingwood
>> Focus Computing
>> p +61 415 24 26 24
>> http://www.focus-computing.com.au
>>
>>
>> ------ End of Forwarded Message
>>
>>
>>
>> ________________________________
>>
>>
>>
>> ------------------------------------------------------------------------------
>>
>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>>
>> is the only developer event you need to attend this year. Jumpstart  
>> your
>>
>> developing skills, take BlackBerry mobile applications to market  
>> and stay
>>
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>>
>> http://p.sf.net/sfu/devconference
>>
>>
>>
>> ________________________________
>>
>>
>>
>> _______________________________________________
>>
>> mdbtools-dev mailing list
>>
>> mdb...@li...
>>
>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>
>>
>>
>>
>> --
>>
>> Peter Benjamin Volk
>>
>> Project Lead
>>
>>
>>
>>    DDEngine.org
>>
>>    An open source project
>>
>>    Phone:  [+49] (0) 351 862 9566
>>
>>    mailto:pe...@dd...
>>
>>
>>
>>
>>
>>    Bunsenstraße 3  | D-01139 Dresden | GERMANY
>>
>> ***********************************************************
>>
>>
>>
>> Diese Mail einschliesslich der Anhänge könnte vertraulich sein.  
>> Sollten Sie
>> nicht der beabsichtigte Empfänger dieser Mail sein, so ist jegliches
>> Verwenden, Offenbaren oder Kopieren der Mail und ihrer Anhänge  
>> untersagt.
>> Bitte informieren Sie den Absender und löschen Sie die Mail und deren
>> Anhänge von Ihrem Rechner. Vielen Dank.
>>
>>
>>
>> This email and its attachments may be confidential and/or  
>> privileged. If you
>> are not the intended recipient, any use, disclosure or copying of  
>> this email
>> and its attachments is prohibited. If you have received this email  
>> in error,
>> please notify immediately the sender by return email and delete  
>> this email
>> and its attachments from your computer system. Thank you.
>>
>> ------------------------------------------------------------------------------
>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>> is the only developer event you need to attend this year. Jumpstart  
>> your
>> developing skills, take BlackBerry mobile applications to market  
>> and stay
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> http://p.sf.net/sfu/devconference
>> _______________________________________________
>> mdbtools-dev mailing list
>> mdb...@li...
>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>
>>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart  
> your
> developing skills, take BlackBerry mobile applications to market and  
> stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>