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

[Richard K. <rk...@er...>]

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 <gem...@gm...> 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