[mdb-dev] isql crashes when trying to use MDB

[Gregor at H. <gr...@ho...>]

Hey there. I am having a rough time getting started with trying to use 
MDB with unixODBC. The OS is Slackware 64-bit, aka Slamd64.

If I use isql, it crashes when I do anything. Any help on diagnosing 
this would be highly appreciated.


$ isql -v CalvegEcoRegions
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> help
Error at Line : syntax error near exec
+
|
+
Segmentation fault


I have built mdbtools-0.6pre1 and specified --with-unixodbc=/usr/local

This created the following files under /usr/local/lib. Note that the 
filenames are a bit unusual in that they don't contain .so Is that expected?

    libmdb -> libmdb.0.0.0
    libmdb.0 -> libmdb.0.0.0
    libmdb.0.0.0
    libmdb.a
    libmdb.la
    libmdbodbc -> libmdbodbc.0.0.0
    libmdbodbc.0 -> libmdbodbc.0.0.0
    libmdbodbc.0.0.0
    libmdbodbc.a
    libmdbodbc.la
    libmdbsql -> libmdbsql.0.0.0
    libmdbsql.0 -> libmdbsql.0.0.0
    libmdbsql.0.0.0
    libmdbsql.a
    libmdbsql.la


My odbcinst.ini and odbc.ini are as follows:

[Microsoft Access Driver (*.mdb)]
Description = MDB Tools ODBC drivers
Driver     = /usr/local/lib/libmdbodbc.0.0.0
Setup      =
FileUsage  = 1
CPTimeout  =
CPReuse    =

[Regions]
Description = My first MDB
Driver      = Microsoft Access Driver (*.mdb)
Database    = /tmp/RegionData2010.mdb
Host        =
Port        =
User        =
Password    =


-- 
HostGIS, Open Source solutions for the global GIS community
Greg Allensworth - SysAdmin, Programmer, GIS Person, Security
    Network+   Server+   A+   Security+   Linux+
    PHP   PostgreSQL   MySQL   DHTML/JavaScript/AJAX

"No one cares if you can back up — only if you can recover."