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