Re: mdb-export Can't alloc filename

Hi Eric,


Are you sure your file paths are correct?
Keep in mind that Linux usually is case-sensitive, so e.g.
20140210vv.mdb and 20140210vv.MDB are NOT the same file.

Also the message might be caused by an invalid use of command parameters,
for some reason. Make sure that they are correct.

I think -I requires a parameter that tells it which SQL dialect it
should generate insert-statements for. see manpage ($ man mdb-export) :

"  -I     INSERT statements (instead of CSV). You must specify the SQL dialect."

 From what I can see the supported dialects are
"access", "sybase", oracle", "postgres" and "mysql"

Additional to that I'm not sure if -R and -I make sense in combination,
since -R is for specifying a row delimiter - which I assume is for CSV output -,
while -I is for specifying the SQL dialect to be used for output INSTEAD of CSV

---

Now to the building problems.

Make sure that you have all dependencies needed not only for running mdb-export,
but also for _building_ mdb-export.
That means that you will not only need the libraries, but also the development-
headers that are needed for compiling against the libraries respectively.

In Ubuntu (and other debian based distributions) those packages are usually the
same name like the library, but with a "-dev" postfix.
E.g. on my system sql.h was installed by the unixodbc-dev package, you might
have to install that. ($ sudo apt-get install unixodbc-dev )

On Ubuntu you might be able to just use
$ sudo apt-get build-dep mdbtools
to install all building dependencies needed automagically.


Good luck and best regards,
Richard


On Mon, 10 Mar 2014 02:08:07 +0100, Eric Morgan <[email protected]> wrote:

> apt-cache policy mdbtools
> mdbtools:
>   Installed: 0.7-1
>   Candidate: 0.7-1
>   Version table:
>  *** 0.7-1 0
>         500 http://us.archive.ubuntu.com/ubuntu/ raring/main amd64 Packages
>         100 /var/lib/dpkg/status
>
> The mdb file is just sitting in my home folder (no windows mounts or
> anything).
>
> $ mdb-export -I -R ';' 20140210vv.mdb FirstTable >> /tmp/20140210vv.sql
> Can't alloc filename
>
> I also can't build the cvs source or the tarball downloaded from
> sourceforge.net
>
> odbc.c:20:17: fatal error: sql.h: No such file or directory
> compilation terminated.
> make[2]: *** [odbc.lo] Error 1
>
> Any help?
>
> Thanks,
> Eric

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech