[mdb-dev] Column names getting cut off

[Camden D. <cd...@gm...>]

Hello list.  For a project I'm developing I need to access a live mdb
database to pull some data and utilize it in a php app on a linux box.
 Since the data need to be 'live', I can't simply export the mdb to
another format; I have to access it as an mdb.

Currently, I'm trying to use mdbtools, mdbtools-odbc, and unixodbc. 
I've tried using the rpms for version 0.5-1 and 0.5-236 of the
mdbtools packages, and version 2.2.8-55 of unixodbc.

Everything installs fine, and I can connect to my mdb just fine.  The
mdb is Jet 4 and about 200 megs large, and contains a few dozen
tables.  I can access most of the tables just fine.  However, the one
that I actually need doesn't come through correctly.  When I use
mdb-sql to do a 'describe table' on it, about the first 20 columns
come through find, but then the next 80 or so columns are completely
blank.  The one between the ones that work and ones that don't is cut
off, with only half the column name showing up.  The ones with blank
column names still have their type and size displayed correctly, so
it's kind of being read correctly.

I've looked at the table in Access, and nothing seems very strange
about that particular column.  My tables and column names do contain
underscores, but as it works with other tables that have underscores,
I don't think that's the issue.  I tried the 'compact and repair
database' option in Access as well, but that didn't fix it.

I tried compiling the 0.6 version of mdbtools, but it can't read any
of the tables in my database.  I tried the cvs version as well, but
couldn't get it to even compile correctly.

Any help would be greatly appreciated.
-Camden Daily