[unixODBC-support] isql connects to MS Access?

Bing Du bdu at iastate.edu
Tue Dec 20 16:08:43 GMT 2005


Hello everyone,

Anybody have successful experience using isql to query MS Access?  The
Access (2003) database that's used is Northwind.mdb which is stored on
Linux.

$ isql -v accessdsn
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select CustomerID from Customers;
Error at Line : parse error near ;
[08001][unixODBC]Couldn't parse SQL

[ISQL]ERROR: Could not SQLExecute

$ isql --version
unixODBC 2.2.8

/etc/odbc.ini:
=============
[bingtest]
Description = Microsoft Access Database
Driver = MDBToolsODBC
Database = /home/bdu/Northwind.mdb
Servername = localhost
UserName =
Password =
port = 5432
=============

/etc/odbcinst.ini
==========
[MDBToolsODBC]
Description             = MDB Tools ODBC drivers
Driver          = /usr/lib/libmdbodbc.so.0
Setup           =
FileUsage               = 1
CPTimeout               =
CPReuse         =
UsageCount              = 3
==========

$ rpm -aq php-odbc
php-odbc-4.3.2-26.ent

$ rpm -aq|grep mdbtool
mdbtools-0.5-1
mdbtools-odbc-0.5-1

If anybody interested, here is a pretty good tutorial on Microsoft Access
Database using Linux and PHP
http://bryanmills.net:8086/archives/000099.html.

Thanks in advance for any help,

Bing




More information about the unixODBC-support mailing list