[mdb-dev] PHP + unixODBC + MS Access

[<hak...@mp...>]

Hi,

I want to access *.mdb files within my php scripts. I have a Linux web=20
server with unixODBC installed. When I access the database with the=20
following php code:

<?php
$mydb =3D odbc_connect("MSAccess-dummy","","");
$query =3D "select * from Addresses";
$result =3D odbc_exec($mydb,$query);
$report =3D odbc_fetch_row($result);
echo odbc_result($result, 1);
odbc_close($mydb);
?>

I get this error back:

*Warning*: SQL error: [unixODBC]Could not find Database parameter, SQL=20
state 08001 in SQLConnect in */usr/local/httpd/htdocs/odbc.php* on line *=
3*
*Warning*: odbc_exec(): supplied argument is not a valid ODBC-Link=20
resource in */usr/local/httpd/htdocs/odbc.php* on line *5*
*Warning*: odbc_fetch_row(): supplied argument is not a valid ODBC=20
result resource in */usr/local/httpd/htdocs/odbc.php* on line *6*
*Warning*: odbc_result(): supplied argument is not a valid ODBC result=20
resource in */usr/local/httpd/htdocs/odbc.php* on line *7*
*Warning*: odbc_close(): supplied argument is not a valid ODBC-Link=20
resource in */usr/local/httpd/htdocs/odbc.php* on line *8*

The triling warnings are due to the first one but what am I missing???=20
Which parameter??

I downloaded the latest sources from MDBTools repository and used the=20
following configuration:

$ ./configure --prefix=3D/usr/local/mdbodbc=20
--with-unixodbc=3D/usr/local/unixODBC --enable-sql

My odbcinst.ini looks like:

[MDBODBC]
Description =3D MDB Tools ODBC Driver
Driver      =3D /usr/local/mdbodbc/lib/libmdbodbc.so
Setup       =3D
FileUsage   =3D 1
CPTimeout   =3D
CPReuse     =3D


My odbc.ini file looks like:

[MSAccess-dummy]
Description =3D Microsoft Access Events database
Driver      =3D MDBODBC
Database    =3D /home/hakans/dummy.mdb
Servername  =3D localhost
UserName    =3D
Password    =3D
Port        =3D 5432

$ ll /home/hakans/dummy.mdb
-rw-r--r--  1 hakans users 180224 Jan 12 11:10 /home/hakans/dummy.mdb


Grateful for any kind of help.

Regards,
/H=E5kan