isql crashes when trying to use MDB
Gregor at HostGIS <[email protected]> Tue, 17 Aug 2010 15:10:06 -0700
| Newsgroups | gmane.comp.db.mdb-tools.devel |
|---|---|
| Message-ID | <[email protected]> |
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."
------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev