Discussion:
unknown
1970-01-01 00:00:00 UTC
Permalink
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
apt-cache policy mdbtools
Installed: 0.7-1
Candidate: 0.7-1
*** 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
Loading...