mdbtools-dev

[mdb-dev] New member

[Alfonso Muñoz-P. F. <alf...@vt...>]

Hi, I’m new to the list and new to the project. So I’ll introduce myself 
quickly and proceed with a few questions.

I’m working at the J.H. von Thünen-Institut in Germany and I’m leading a 
database integration project where we have a couple of Access databases 
to migrate to either Postgres (preferably) or MySQL. I searched online 
for tools to do this kind of task and, as I guessed, there are a few 
commercial applications and this project which seems quite promising.

I wanted to know what are the best way to post, suggestions and possible 
patches. Should I use the SF mailing list, GitHub issues, SF forum or SF 
bug tracker?

Thanks in advance.

-- 
Alfonso Muñoz-Pomer Fuentes
Johann Heinrich von Thünen-Institut
Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei
Institut für Forstgenetik
Sieker Landstrasse 2
22927 Grosshansdorf

Telefon: +49 (0)4102/696-145
Fax:     +49 (0)4102/696-200
Email:   alf...@vt...
Web:     http://www.vti.bund.de

Re: [mdb-dev] 0.7_rc1 release

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

Hello Brian


I'm still fixing a few things here and there in mdbtools. I hope you have notifications.

I was thinking it would be nice to have a github hook to post on that list when there's a commit.

I think you can do that on the admin tab, in services hooks. There is an email hook that might do the trick.


Also there is a bug report about updating the source forge page that only you can fix.
https://github.com/brianb/mdbtools/issues/14

Finally, I'd like to add a bash_completion script I've been developing for Debian. I don't really know where to put it. Maybe an new extra/ folder? It could contain a nice .desktop file too.
http://anonscm.debian.org/gitweb/?p=collab-maint/mdbtools.git;a=blob_plain;f=debian/mdbtools.bash-completion;hb=HEAD
http://anonscm.debian.org/gitweb/?p=collab-maint/mdbtools.git;a=blob_plain;f=debian/mdbtools-gmdb.desktop;hb=HEAD


Cheers

Re: [mdb-dev] build mdb-export on OpenVMS

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

Hi Frank,

when I started to get in touch with mdblib, I needed a cross-platform 
library to access mdb files and wanted it under a POSIX environment, using 
either Linux gcc or mingw, the Windows crosscompiler.

As far as I remember, I simply started by compiling and linking all the 
sourcefiles together and removed those, which had a main() function, that 
gave a duplicate.

The dependencies on system libraries and headers are very weak, so 
actually the 'configure' is a little bit overhead in this situation.

If you are strong enough to create Makefile's or automated compile 
scripts, I'd suggest to avoid the automake/configure method.

Feel free to contact me, also via PM -

A.



On Tue, 28 Aug 2012, Fra...@lp... wrote:

> Hi all,
>
> when I was looking for tools then can read data from mdb-files at not-windows-plattform I
> found this project. I tried to build the exe-files on my OpenVMS-System. Bash-Shell is
> installed, ZLIB and GLIB. But in generell OpenVMS has only poor unix-like tools.
>
> First I tried the "stable" version 0.5:
> ---------------------------------------
>
> bash$ configure
> checking for a BSD-compatible install... /bin/install -c
> checking whether build environment is sane... yes
> sed: couldn't open file %s: %s
> /dka100/software/mdbtools/mdbtools-0-5/missing: Unknown `--run' option
> Try `/dka100/software/mdbtools/mdbtools-0-5/missing --help' for more information
> configure: WARNING: `missing' script is too old or missing
> checking for gawk... gawk
> checking whether make sets ${MAKE}... yes
> checking for gcc... gcc
> checking for C compiler default output... a.out
> checking whether the C compiler works... yes
> checking whether we are cross compiling... no
> checking for suffix of executables...
> checking for suffix of object files... o
> checking whether we are using the GNU C compiler... no
> checking whether gcc accepts -g... yes
> checking for style of include used by make... GNU
> checking dependency style of gcc... gcc3
> checking whether make sets ${MAKE}... (cached) yes
> checking build system type...
>                              config.sub: too many arguments
> Try `config.sub --help' for more information.
> configure: error: /bin/sh ./config.sub
>  exit (1);
> ..^
> %CC-I-IMPLICITFUNC, In this statement, the identifier "exit" is implicitly decla
> red as a function.
> at line number 110 in file DKA100:[SOFTWARE.mdbtools.mdbtools-0-5]dummy-3335.c;1
> failed
> bash$
>
>
> -------
> Next I tried version 0.6pre1:
> -----------------------------
>
> AXP06$ bash ./configure
> rm: cannot remove `conftest/sub': directory not empty
> checking for a BSD-compatible install... /bin/install -c
> checking whether build environment is sane... yes
> sed: couldn't open file %s: %s
> /dka100/000000/software/mdbtools/mdbtools-0-6pre1/missing: Unknown `--run' optio
> n
> Try `/dka100/000000/software/mdbtools/mdbtools-0-6pre1/missing --help' for more
> information
> configure: WARNING: `missing' script is too old or missing
> checking for gawk... gawk
> checking whether make sets $(MAKE)... yes
> checking for gcc... gcc
> checking for C compiler default output... a.out
> checking whether the C compiler works... yes
> rm: cannot remove `conftest': is a directory
> checking whether we are cross compiling... no
> checking for suffix of executables...
>                                      rm: cannot remove `conftest': is a directo
> ry
> checking for suffix of object files... o
> checking whether we are using the GNU C compiler... no
> checking whether gcc accepts -g... yes
> checking for gcc option to accept ANSI C... none needed
> checking for style of include used by make... GNU
> checking dependency style of gcc...
>                                    mkdir: cannot create directory `conftest.dir
> ': file exists
> mkdir: cannot create directory `sub': file exists
> nonecannot remove `conftest.dir/sub': directory not empty
> checking whether make sets $(MAKE)... (cached) yes
> checking build system type...
>                              config.sub: too many arguments
> Try `config.sub --help' for more information.
> configure: error: /bin/sh ./config.sub
>  exit (1);
> ..^
> %CC-I-IMPLICITFUNC, In this statement, the identifier "exit" is implicitly decla
> red as a function.
> at line number 110 in file SYS$SYSROOT:[SYSMGR.VMS_TEMP.cgLuE4La]dummy.c;2 faile
> d
> AXP06$
>
> The last version I found is 0.7 rc1
> -----------------------------------
> This kit does not have a configure-file. 'autoconf' is needed. In order to install
> autoconf perl is needed to install first. (May be other also.) But I only like to build an
> exe-file from c-code.
>
> Why such overhead? This works only on the newest Linux-versions. For poor unix-systems
> (POSIX-conform) a munually build should be more easy.
> Example:
> % gcc mdb-export
> % link mdb-export
>
> Do I have a chance to build mdb-export without make and without configure and without
> autoconf, simply with gcc and link (and perhaps some qualifiers)?
>
>
> regards, Frank
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

[mdb-dev] build mdb-export on OpenVMS

[<Fra...@lp...>]

Hi all,

when I was looking for tools then can read data from mdb-files at not-windows-plattform I
found this project. I tried to build the exe-files on my OpenVMS-System. Bash-Shell is
installed, ZLIB and GLIB. But in generell OpenVMS has only poor unix-like tools.

First I tried the "stable" version 0.5:
---------------------------------------

bash$ configure
checking for a BSD-compatible install... /bin/install -c
checking whether build environment is sane... yes
sed: couldn't open file %s: %s
/dka100/software/mdbtools/mdbtools-0-5/missing: Unknown `--run' option
Try `/dka100/software/mdbtools/mdbtools-0-5/missing --help' for more information
configure: WARNING: `missing' script is too old or missing
checking for gawk... gawk
checking whether make sets ${MAKE}... yes
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... no
checking whether gcc accepts -g... yes
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking whether make sets ${MAKE}... (cached) yes
checking build system type...
                              config.sub: too many arguments
Try `config.sub --help' for more information.
configure: error: /bin/sh ./config.sub
  exit (1);
..^
%CC-I-IMPLICITFUNC, In this statement, the identifier "exit" is implicitly decla
red as a function.
at line number 110 in file DKA100:[SOFTWARE.mdbtools.mdbtools-0-5]dummy-3335.c;1
 failed
bash$


-------
Next I tried version 0.6pre1:
-----------------------------

AXP06$ bash ./configure
rm: cannot remove `conftest/sub': directory not empty
checking for a BSD-compatible install... /bin/install -c
checking whether build environment is sane... yes
sed: couldn't open file %s: %s
/dka100/000000/software/mdbtools/mdbtools-0-6pre1/missing: Unknown `--run' optio
n
Try `/dka100/000000/software/mdbtools/mdbtools-0-6pre1/missing --help' for more
information
configure: WARNING: `missing' script is too old or missing
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
rm: cannot remove `conftest': is a directory
checking whether we are cross compiling... no
checking for suffix of executables...
                                      rm: cannot remove `conftest': is a directo
ry
checking for suffix of object files... o
checking whether we are using the GNU C compiler... no
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking for style of include used by make... GNU
checking dependency style of gcc...
                                    mkdir: cannot create directory `conftest.dir
': file exists
mkdir: cannot create directory `sub': file exists
nonecannot remove `conftest.dir/sub': directory not empty
checking whether make sets $(MAKE)... (cached) yes
checking build system type...
                              config.sub: too many arguments
Try `config.sub --help' for more information.
configure: error: /bin/sh ./config.sub
  exit (1);
..^
%CC-I-IMPLICITFUNC, In this statement, the identifier "exit" is implicitly decla
red as a function.
at line number 110 in file SYS$SYSROOT:[SYSMGR.VMS_TEMP.cgLuE4La]dummy.c;2 faile
d
AXP06$

The last version I found is 0.7 rc1
-----------------------------------
This kit does not have a configure-file. 'autoconf' is needed. In order to install
autoconf perl is needed to install first. (May be other also.) But I only like to build an
exe-file from c-code.

Why such overhead? This works only on the newest Linux-versions. For poor unix-systems
(POSIX-conform) a munually build should be more easy.
Example:
% gcc mdb-export
% link mdb-export

Do I have a chance to build mdb-export without make and without configure and without
autoconf, simply with gcc and link (and perhaps some qualifiers)?


regards, Frank

Re: [mdb-dev] Port libmdb (mdb-tools) for iOS

[Jakob E. <jab...@gm...>]

Actually, the MDB Tools are already on Github: https://github.com/brianb/mdbtools
The version on sourceforge is very outdated.

Concerning an iOS port: the problem is that mdb-tools are licensed under the LGPL, which is as far as I understand it is not compatible with iOS. So even if you could get it to work technically, you might not be legally allowed to use libmdb on the iPhone. Some people don't care about the problem and just use LGPL code on the iPhone, but I'd carefully consider the licensing issues before starting a port. On the other hand, I think even some of Apple's apps use LGPL code (I think Webkit is LGPL), but that doesn't help if someone complains and Apple pulls your app.

In fact, the LGPL license is one of the reasons why I stopped using mdbtools in my app (MDB Viewer for Mac) and wrote my own library for reading Access files.

Concerning documentation: Read the HACKING file for a good overview of the MDB file format.

Best regards,
Jakob

On 11.08.2012, at 08:45, Tudor Holton <tu...@tu...> wrote:

> On a related note, is there any chance of shifting to a git repos?  These kinds of project branching (as in code-share project branching) work much better on git, in my experience.
> 
> Cheers,
> Tudor.
> 
> On 12-08-11 03:17 AM, Robert Zermeno wrote:
>> Alex,
>>  
>> Thanks for the quick feedback.  STL is supported by iOS and if you used all the STL classes as they were intended I believe you have made my day.  If you do not mind, can you provide me with your source code for me to try it out?  I am sure it will work, but if not it will be a great start to finish the port.  Once finished, perhaps the community can make a branch for iOS support as I would like to continue to see this project support newer Access files.
>>  
>> If you can zip the project and send it to me that will be awesome.
>>  
>> Thanks,
>>  
>> Robert
>>  
>> 
>> From: Alexander Lehner <le...@ed...>
>> To: Robert Zermeno <ref...@ya...> 
>> Cc: "mdb...@li..." <mdb...@li...> 
>> Sent: Friday, August 10, 2012 9:55 AM
>> Subject: Re: [mdb-dev] Port libmdb (mdb-tools) for iOS
>> 
>> 
>> 
>> On Fri, 10 Aug 2012, Robert Zermeno wrote:
>> 
>> > Ladies/Gents,
>> >
>> > I just became a memeber and I hope the community can now receive my message.  If you have received it twice, I am sorry.
>> >  
>> > I am trying to read MSAccess mdb files on my iOS on the fly and saw this product.  I know it is not written for iOS, but has anyone tried to make it work?
>> > For the day and a half of searching, I cannot find free source to read .mdb files on iOS.  The real problem to get it to work is mdb-tools dependency of glib.  I am considering of porting this library to be usable in iOS environment (eliminate dependency of glib and other libraries iOS does not support).  I want to first start with libmdb as other items depend on it.  When successful, speak to the community where it should go from there (perhaps make support for newer Access files)?
>> >  
>> > However, I feel libmdb can be done, but have not looked deep in the code to see if it will be a beast of a effort.  Can anybody provide me with valuable documentation on both mdb-tools architecture (each class and its purpose since there is very limited code comments) and the MDB file specification?  I know MDB file specification is not OCG, but any notes jotted down will be useful for me.
>> >  
>> > If you feel I should not waste my time please let me know why?  I really need this functionality and I thought this C class is the best basis project to start with to port over (seeing how iOS supports Objective-C++).
>> 
>> 
>> Hi Robert,
>> 
>> there was a discussion concerning the dependency on glibc earlier on this
>> list, but I don't remember how it ended. Maybe it's worth searching the
>> archive.
>> 
>> I had this problem as well and solved it, by replacing the functions of
>> glibc that are beeing used in libmdb by my own implementation.
>> These are mainly some containers (hashes etc) and I re-implemented them by
>> using STL.
>> So my workaround is no longer plain ANSI-C but C++.
>> If that's ok for you, I can give you my code.
>> 
>> Alex.
>> 
>> 
>> 
>> 
>> 
>> 
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and 
>> threat landscape has changed and how IT managers can respond. Discussions 
>> will include endpoint security, mobile security and the latest in malware 
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> 
>> 
>> _______________________________________________
>> mdbtools-dev mailing list
>> mdb...@li...
>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> 
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: [mdb-dev] Port libmdb (mdb-tools) for iOS

[Tudor H. <tu...@tu...>]

On a related note, is there any chance of shifting to a git repos?  
These kinds of project branching (as in code-share project branching) 
work much better on git, in my experience.

Cheers,
Tudor.

On 12-08-11 03:17 AM, Robert Zermeno wrote:
> Alex,
> Thanks for the quick feedback.  STL is supported by iOS and if you 
> used all the STL classes as they were intended I believe you have made 
> my day.  If you do not mind, can you provide me with your source code 
> for me to try it out?  I am sure it will work, but if not it will be a 
> great start to finish the port.  Once finished, perhaps the community 
> can make a branch for iOS support as I would like to continue to see 
> this project support newer Access files.
> If you can zip the project and send it to me that will be awesome.
> Thanks,
> Robert
>
> *From:* Alexander Lehner <le...@ed...>
> *To:* Robert Zermeno <ref...@ya...>
> *Cc:* "mdb...@li..." 
> <mdb...@li...>
> *Sent:* Friday, August 10, 2012 9:55 AM
> *Subject:* Re: [mdb-dev] Port libmdb (mdb-tools) for iOS
>
>
>
> On Fri, 10 Aug 2012, Robert Zermeno wrote:
>
> > Ladies/Gents,
> >
> > I just became a memeber and I hope the community can now receive my 
> message.  If you have received it twice, I am sorry.
> >
> > I am trying to read MSAccess mdb files on my iOS on the fly and saw 
> this product.  I know it is not written for iOS, but has anyone tried 
> to make it work?
> > For the day and a half of searching, I cannot find free source to 
> read .mdb files on iOS.  The real problem to get it to work is 
> mdb-tools dependency of glib.  I am considering of porting this 
> library to be usable in iOS environment (eliminate dependency of glib 
> and other libraries iOS does not support).  I want to first start with 
> libmdb as other items depend on it.  When successful, speak to the 
> community where it should go from there (perhaps make support for 
> newer Access files)?
> >
> > However, I feel libmdb can be done, but have not looked deep in the 
> code to see if it will be a beast of a effort. Can anybody provide me 
> with valuable documentation on both mdb-tools architecture (each class 
> and its purpose since there is very limited code comments) and the MDB 
> file specification?  I know MDB file specification is not OCG, but any 
> notes jotted down will be useful for me.
> >
> > If you feel I should not waste my time please let me know why?  I 
> really need this functionality and I thought this C class is the best 
> basis project to start with to port over (seeing how iOS supports 
> Objective-C++).
>
>
> Hi Robert,
>
> there was a discussion concerning the dependency on glibc earlier on this
> list, but I don't remember how it ended. Maybe it's worth searching the
> archive.
>
> I had this problem as well and solved it, by replacing the functions of
> glibc that are beeing used in libmdb by my own implementation.
> These are mainly some containers (hashes etc) and I re-implemented them by
> using STL.
> So my workaround is no longer plain ANSI-C but C++.
> If that's ok for you, I can give you my code.
>
> Alex.
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>
>
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: [mdb-dev] Port libmdb (mdb-tools) for iOS

[Robert Z. <ref...@ya...>]

Alex,
 
Thanks for the quick feedback.  STL is supported by iOS and if you used all the STL classes as they were intended I believe you have made my day.  If you do not mind, can you provide me with your source code for me to try it out?  I am sure it will work, but if not it will be a great start to finish the port.  Once finished, perhaps the community can make a branch for iOS support as I would like to continue to see this project support newer Access files.
 
If you can zip the project and send it to me that will be awesome.
 
Thanks,
 
Robert
 

From: Alexander Lehner <le...@ed...>
To: Robert Zermeno <ref...@ya...> 
Cc: "mdb...@li..." <mdb...@li...> 
Sent: Friday, August 10, 2012 9:55 AM
Subject: Re: [mdb-dev] Port libmdb (mdb-tools) for iOS



On Fri, 10 Aug 2012, Robert Zermeno wrote:

> Ladies/Gents,
>
> I just became a memeber and I hope the community can now receive my message.  If you have received it twice, I am sorry.
>  
> I am trying to read MSAccess mdb files on my iOS on the fly and saw this product.  I know it is not written for iOS, but has anyone tried to make it work?
> For the day and a half of searching, I cannot find free source to read .mdb files on iOS.  The real problem to get it to work is mdb-tools dependency of glib.  I am considering of porting this library to be usable in iOS environment (eliminate dependency of glib and other libraries iOS does not support).  I want to first start with libmdb as other items depend on it.  When successful, speak to the community where it should go from there (perhaps make support for newer Access files)?
>  
> However, I feel libmdb can be done, but have not looked deep in the code to see if it will be a beast of a effort.  Can anybody provide me with valuable documentation on both mdb-tools architecture (each class and its purpose since there is very limited code comments) and the MDB file specification?  I know MDB file specification is not OCG, but any notes jotted down will be useful for me.
>  
> If you feel I should not waste my time please let me know why?  I really need this functionality and I thought this C class is the best basis project to start with to port over (seeing how iOS supports Objective-C++).


Hi Robert,

there was a discussion concerning the dependency on glibc earlier on this
list, but I don't remember how it ended. Maybe it's worth searching the
archive.

I had this problem as well and solved it, by replacing the functions of
glibc that are beeing used in libmdb by my own implementation.
These are mainly some containers (hashes etc) and I re-implemented them by
using STL.
So my workaround is no longer plain ANSI-C but C++.
If that's ok for you, I can give you my code.

Alex.

Re: [mdb-dev] Port libmdb (mdb-tools) for iOS

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

On Fri, 10 Aug 2012, Robert Zermeno wrote:

> Ladies/Gents,
>
> I just became a memeber and I hope the community can now receive my message.  If you have received it twice, I am sorry.
>  
> I am trying to read MSAccess mdb files on my iOS on the fly and saw this product.  I know it is not written for iOS, but has anyone tried to make it work?
> For the day and a half of searching, I cannot find free source to read .mdb files on iOS.  The real problem to get it to work is mdb-tools dependency of glib.  I am considering of porting this library to be usable in iOS environment (eliminate dependency of glib and other libraries iOS does not support).  I want to first start with libmdb as other items depend on it.  When successful, speak to the community where it should go from there (perhaps make support for newer Access files)?
>  
> However, I feel libmdb can be done, but have not looked deep in the code to see if it will be a beast of a effort.  Can anybody provide me with valuable documentation on both mdb-tools architecture (each class and its purpose since there is very limited code comments) and the MDB file specification?  I know MDB file specification is not OCG, but any notes jotted down will be useful for me.
>  
> If you feel I should not waste my time please let me know why?  I really need this functionality and I thought this C class is the best basis project to start with to port over (seeing how iOS supports Objective-C++).


Hi Robert,

there was a discussion concerning the dependency on glibc earlier on this
list, but I don't remember how it ended. Maybe it's worth searching the
archive.

I had this problem as well and solved it, by replacing the functions of
glibc that are beeing used in libmdb by my own implementation.
These are mainly some containers (hashes etc) and I re-implemented them by
using STL.
So my workaround is no longer plain ANSI-C but C++.
If that's ok for you, I can give you my code.

Alex.

[mdb-dev] Port libmdb (mdb-tools) for iOS

[Robert Z. <ref...@ya...>]

Ladies/Gents,

I just became a memeber and I hope the community can now receive my message.  If you have received it twice, I am sorry.
 
I am trying to read MSAccess mdb files on my iOS on the fly and saw this product.  I know it is not written for iOS, but has anyone tried to make it work?
For the day and a half of searching, I cannot find free source to read .mdb files on iOS.  The real problem to get it to work is mdb-tools dependency of glib.  I am considering of porting this library to be usable in iOS environment (eliminate dependency of glib and other libraries iOS does not support).  I want to first start with libmdb as other items depend on it.  When successful, speak to the community where it should go from there (perhaps make support for newer Access files)?
 
However, I feel libmdb can be done, but have not looked deep in the code to see if it will be a beast of a effort.  Can anybody provide me with valuable documentation on both mdb-tools architecture (each class and its purpose since there is very limited code comments) and the MDB file specification?  I know MDB file specification is not OCG, but any notes jotted down will be useful for me.
 
If you feel I should not waste my time please let me know why?  I really need this functionality and I thought this C class is the best basis project to start with to port over (seeing how iOS supports Objective-C++).
 
Bob

[mdb-dev] mdbtools 0.7 release

[Chris S. <cgs...@gm...>]

Just in case anyone else has problems, autogen.sh needs an update. In the
libtoolize --version call, libtoolize is misspelled as libtooloze, so it
automatically tries to default down to glibtoolize, which in my case, I
don't have and don't use. After updating, my configure ran fine. If you
pull the latest source from git, the problem is fixed, but until another
tarball is released, the fix is necessary!

Regards,
Chris

[mdb-dev] 0.7 release

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

Hi all

Brian looks very busy and is unavailable. So I took the liberty to tag version
0.7 in the repository, after about 9 monthes!

Changes from version 0.7-rc1 are very small:
- Lot of documentation updated
- namespace reserved keywork when compiled with a c++ compiler
- A couple of code astetic changes that have been hanging in Debian for
  years. Thanks Filip Van Raemdonck
- Support for glibtoolize. Thanks Adam Vandenberg.

You can get the tarball version here:
https://github.com/brianb/mdbtools/tarball/0.7 (tar)
https://github.com/brianb/mdbtools/zipball/0.7 (zip)

Incoming are more intrusive patches such a odbc unicode support... :)

-- Jean-Michel Nirgal Vourgère

Re: [mdb-dev] Write in a .mdb

[Dmitry N. <luc...@ma...>]

Hi!

mdbtools for import from *.mdb
Try some PHP or java tools, that can write to mdb-file
may be: http://jackcess.sourceforge.net/

Good Luck, Dmitry

On Fri, 22 Jun 2012 13:51:24 -0300
André Toscano <and...@gm...> wrote:

> Hi, I have a question about writing data in .mdb with mdb-tools.
> There are sites in a google search that inform a feature of write data
> in mdb-tools?
> Is it supported?
> If is, what version can I use to write data in .mdb?
> Thanks in advance
> Regards
> -- 
> André Emilio Toscano
> 
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> 

[mdb-dev] Write in a .mdb

[André T. <and...@gm...>]

Hi, I have a question about writing data in .mdb with mdb-tools.
There are sites in a google search that inform a feature of write data
in mdb-tools?
Is it supported?
If is, what version can I use to write data in .mdb?
Thanks in advance
Regards
-- 
André Emilio Toscano

Re: [mdb-dev] Opening .mdb without .mdw?

[Dmitry N. <luc...@ma...>]

Hi!
I think it`s posible.
Try the command line interface:
mdb-schema --drop-table {name_of_file}.mdb mysql > shema.sql
mdb-export -I mysql -D '%Y-%m-%d' -q \' -X \\ {name_of_file}.mdb "{name_of_tables-find_in_file-shema.sql}">> database.sql
See the results in files as mysql database. Or try commands for cvs format.

Good luck, Dmitry

On Fri, 22 Jun 2012 10:47:48 -0400
David Ackerman <do...@ny...> wrote:

> Hi,
> 
> My name is David Ackerman and I have been trying to use mdb-tools to
> open a recovered .mdb access database. The database is not able to be
> opened in any versions of access, due to privilege problems. My
> coworkers and I have narrowed the problem down to a missing .mdw, or
> workgroup file, that access uses to store user and security
> information. It seems that we cannot open this database without the
> workgroup file. I have tried using mdb-export, to convert the file to
> csv tables and reimport them into a new database, but I am unable to
> do this because mdb-tables gives me the error that the file is not a
> proper database file. Mdb-tools recognizes the file as a jet4 database
> and we have no reason to believe it has been corrupted, though, so it
> is probably due to the missing mdw file. I am wondering if mdb-tools
> is the right software for me to be using to try and get around this
> privileges issue, and if so, what the recommended way of going about
> it would be. I appreciate any input on this issue.
> 
> Thank You,
> David Ackerman
> 
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> 

[mdb-dev] Opening .mdb without .mdw?

[David A. <do...@ny...>]

Hi,

My name is David Ackerman and I have been trying to use mdb-tools to
open a recovered .mdb access database. The database is not able to be
opened in any versions of access, due to privilege problems. My
coworkers and I have narrowed the problem down to a missing .mdw, or
workgroup file, that access uses to store user and security
information. It seems that we cannot open this database without the
workgroup file. I have tried using mdb-export, to convert the file to
csv tables and reimport them into a new database, but I am unable to
do this because mdb-tables gives me the error that the file is not a
proper database file. Mdb-tools recognizes the file as a jet4 database
and we have no reason to believe it has been corrupted, though, so it
is probably due to the missing mdw file. I am wondering if mdb-tools
is the right software for me to be using to try and get around this
privileges issue, and if so, what the recommended way of going about
it would be. I appreciate any input on this issue.

Thank You,
David Ackerman

Re: [mdb-dev] make failed ?!

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

Hello

Maybe you need to update the building scripts. Did you try 
autoreconf -i
?
On Thursday 14 June 2012 07:43:12 dia...@bl... wrote:
> Hello there,
> 
> I'm trying to install the mdb utilities, and this is what terminal gives back.
> iMac intel, lion 10.7.4
> Thanks for your help.
> Andres.
> 
> 
> $ ./configure
> checking for a BSD-compatible install... /usr/bin/install -c
> checking whether build environment is sane... yes
> /Users/me/Desktop/missing: Unknown `--run' option
> Try `/Users/me/Desktop/missing --help' for more information
> configure: WARNING: `missing' script is too old or missing
> checking for gawk... no
> checking for mawk... no
> checking for nawk... no
> checking for awk... awk
> checking whether make sets ${MAKE}... no
> checking for gcc... gcc
> checking for C compiler default output... configure: error: C compiler cannot create executables
> $ make
> Launch of "make" failed: the PowerPC architecture is no longer supported.
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> 

[mdb-dev] make failed ?!

[<dia...@bl...>]

Hello there,

I'm trying to install the mdb utilities, and this is what terminal gives back.
iMac intel, lion 10.7.4
Thanks for your help.
Andres.


$ ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
/Users/me/Desktop/missing: Unknown `--run' option
Try `/Users/me/Desktop/missing --help' for more information
configure: WARNING: `missing' script is too old or missing
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether make sets ${MAKE}... no
checking for gcc... gcc
checking for C compiler default output... configure: error: C compiler cannot create executables
$ make
Launch of "make" failed: the PowerPC architecture is no longer supported.

[mdb-dev] namespace: reserved C++ keyword

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

On Thursday 09 February 2012 09:37:09 Dobrov Grigoriy wrote:
> (...) 
> The problem is that I am trying to include mdbtools.h header in my C++
> project and compiler fails in line 495:
> extern void mdb_print_schema(MdbHandle *mdb, FILE *outfile, char *tabname,
> char *namespace, guint32 export_options);
> 
> The fail happens because  'namespace'  is a  keyword in C++ so the C++
> compiler doesn't expect it to occur in the middle of function declaration.
> I understand that C-programmers aren't obliged to think about C++ keywords
> so it seems to me that it's more reasonable to patch the header in debian
> package, of course, if you are not against the idea to help c++ developers

I renamed namespace into dbnamespace.
See https://github.com/brianb/mdbtools/commit/7634e329c740825c97652175bcad16a1a58688ae

[mdb-dev] -Wall fixing

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

Sorry for the spam, one more:

https://github.com/brianb/mdbtools/commit/b7200c9b576cf8c22beae63927c6fedc2e6816c0
contains some trivial fixes for -Wall compilation

Re: [mdb-dev] 2 more patches

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

On Monday 16 January 2012 02:21:54 Nirgal wrote:
> Attached are two very old patches that were hanging in Debian distro...
> * treeviewmodel slightly improves the typing, so that less casts are necessary.
> * filelocals reduce the scope of some local functions declaring them static.
> These are small changes that I guess can go in. What do you think of these?

Commited.

[mdb-dev] man: removed <> from synopsis lines

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

I think <> should not be present in sysnopsis lines in man pages since txt2man properly underline them.
I removed them.
https://github.com/brianb/mdbtools/commit/9ee13359402483d570446bef904f0a7f888d6d44

[mdb-dev] Commited doc changes

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

I just commited some small changes in documentation:
- See also sections
- mdb-header exit code

Re: [mdb-dev] mdb-export with -I and -N

[George L. E. <ab...@ge...>]

Nirgal wrote:

> On Friday 27 January 2012 19:32:58 George L. Emigh wrote:
>> (...) ran into another problem, wanted
>> to add a prefix to the table names using the -N <namespace> option.
>> 
>> for -N qp mdb-schema gives:
>> DROP TABLE [qp_Customer Table];
>> CREATE TABLE [qp_Customer Table]
>> 
>> which is what I expected, but mdb-export -I mysql -N qp gives:
>> INSERT INTO qp`Customer Table` (
>> 
>> Namespaces is not mentioned in the man pages but is when you run the
>> command without any options, is Namespaces going to be removed?
> 
> Ops. My mistake. I just comited a fix regarding namespaces:
> 
> $ src/util/mdb-export -I mysql ~/Desktop/uuid.mdb table1I
> INSERT INTO `table1` (`test2`, `test`) VALUES ("OK",NULL);
> INSERT INTO `table1` (`test2`, `test`) VALUES ("OK",NULL);
> 
> $ src/util/mdb-export -I mysql -N qp ~/Desktop/uuid.mdb table1I
> INSERT INTO `qp_table1` (`test2`, `test`) VALUES ("OK",NULL);
> INSERT INTO `qp_table1` (`test2`, `test`) VALUES ("OK",NULL);
> 
> $ src/util/mdb-export -I postgres ~/Desktop/uuid.mdb table1
> INSERT INTO "table1" ("test2", "test") VALUES ("OK",NULL);
> INSERT INTO "table1" ("test2", "test") VALUES ("OK",NULL);
> 
> $ src/util/mdb-export -I postgres -N qp ~/Desktop/uuid.mdb table1
> INSERT INTO "qp"."table1" ("test2", "test") VALUES ("OK",NULL);
> INSERT INTO "qp"."table1" ("test2", "test") VALUES ("OK",NULL);
> 
> Patch is available at:
> 
https://github.com/brianb/mdbtools/commit/7e34078bcc9a7b23ab028db969cdf77c0b283752

Excellent, thanks.

> 
>> Also I see the sanitize option is gone, will that option to convert
>> spaces
>> to underscores be coming back?  I liked the feature, convert all fields
>> and table names to lowercase would be nice too, but for now I'll just
>> alter my tables after the conversion.
> 
> I don't plan to work on sanitizing again (but maybe someone else will).
> Non-ascii tables results in duplicate names. For exemple, chinese names
> will create tables "___" "___". One need to add something to diferentiate
> them, such as a number: "___1" "___2". Then you need to store new names
> for handling foreign contraints, and so on. Not trivial at all.
> With the proper escape now working, I don't see the point.
> Removing spaces from table names after mysql conversion seems a bit out of
> scope, in my opinion.


That part was not and should never actually a big problem, I am an old guy 
who dislikes spaces in things like table and field names and prefer them 
lower case as well, so it was just an issue of preference, and I changed 
everything to my liking with a little php scripting and I'm moving forward 
on my project.

So it's obviously not necessary to have those things part of mdbtools.

Thanks again for a fantastic tool.


> 
> Cheers
> 
> 
------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
-- 
George L. Emigh - AB4BD

[mdb-dev] -N documentation in man pages

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

I just added schema prefixing option in man documentation of mdb-schema and mdb-export:

https://github.com/brianb/mdbtools/commit/ad87174f10d96ca1ab27cb61feb70b6d2db9b143

[mdb-dev] mdb-export with -I and -N

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

On Friday 27 January 2012 19:32:58 George L. Emigh wrote:
> (...) ran into another problem, wanted 
> to add a prefix to the table names using the -N <namespace> option.
> 
> for -N qp mdb-schema gives:
> DROP TABLE [qp_Customer Table];
> CREATE TABLE [qp_Customer Table]
> 
> which is what I expected, but mdb-export -I mysql -N qp gives:
> INSERT INTO qp`Customer Table` (
> 
> Namespaces is not mentioned in the man pages but is when you run the command 
> without any options, is Namespaces going to be removed?

Ops. My mistake. I just comited a fix regarding namespaces:

$ src/util/mdb-export -I mysql ~/Desktop/uuid.mdb table1I
INSERT INTO `table1` (`test2`, `test`) VALUES ("OK",NULL);
INSERT INTO `table1` (`test2`, `test`) VALUES ("OK",NULL);

$ src/util/mdb-export -I mysql -N qp ~/Desktop/uuid.mdb table1I
INSERT INTO `qp_table1` (`test2`, `test`) VALUES ("OK",NULL);
INSERT INTO `qp_table1` (`test2`, `test`) VALUES ("OK",NULL);

$ src/util/mdb-export -I postgres ~/Desktop/uuid.mdb table1
INSERT INTO "table1" ("test2", "test") VALUES ("OK",NULL);
INSERT INTO "table1" ("test2", "test") VALUES ("OK",NULL);

$ src/util/mdb-export -I postgres -N qp ~/Desktop/uuid.mdb table1
INSERT INTO "qp"."table1" ("test2", "test") VALUES ("OK",NULL);
INSERT INTO "qp"."table1" ("test2", "test") VALUES ("OK",NULL);

Patch is available at:
https://github.com/brianb/mdbtools/commit/7e34078bcc9a7b23ab028db969cdf77c0b283752

> Also I see the sanitize option is gone, will that option to convert spaces 
> to underscores be coming back?  I liked the feature, convert all fields and 
> table names to lowercase would be nice too, but for now I'll just alter my 
> tables after the conversion.

I don't plan to work on sanitizing again (but maybe someone else will).
Non-ascii tables results in duplicate names. For exemple, chinese names will create tables "___" "___". One need to add something to diferentiate them, such as a number:
"___1" "___2".
Then you need to store new names for handling foreign contraints, and so on.
Not trivial at all.
With the proper escape now working, I don't see the point.
Removing spaces from table names after mysql conversion seems a bit out of scope, in my opinion.

Cheers