[mdb-dev] mdb-export Can't alloc filename

[Eric Morgan]

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

[Richard Karolyi]

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."