On 10/11/12 16:58, Andre Koopal wrote:
Hi,
Today I am working on a project where I need to convert an access database dump to something else (mysql likely). Most things I found on the web are not really suitable to script this process (it will need to run every month), but mdbtools looks to be promising. However I tried to compile that on toolserver all I got out of it are coredumps :-(. (Tried both on willow and nightshade). The ubuntu pacakge does work on my home server.
Did anybody ever look into mdbtools and have it working? Is it perhaps possible to have it globally installed on toolserver, as it probably is usefull to some of the glam-projects as well?
I was able to compile mdbtools-0.6pre1 for linux, see the result at /mnt/user-store/mdbtools
I admit that compilation was a bit tricky. When it complains that backend.c:31: error: static declaration of 'mdb_backends' follows non-static declaration, remove the static keyword from that line. yacc and flex are not installed in nightshade, I worked around that by running those of willow. The flex rule expected an output file of .c, so I ran ln -s lex.yy.c .c (otherwise you get an empty lexer.c)
However, the generated binaries didn't output any table for your file.
I then realised that my local mdbtools does work with yout file. Seems that mdbtools-0.7 is in GitHub, but not in SourceForge: https://github.com/brianb/mdbtools
However, in order for just running autoconf.sh, it needs libtool, which is not installed in Linux or Solaris.
If people want an mdb file to test with, the file I need to convert is at /mnt/user-store/rce-nl-data.
Regards,
Andre
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette