mdb tools

Hello Sirs

ENVIRONMENT:
Linux Red Hat 8.0

TARGHET:
Retrieve data from a .mdb file mounted on linux file system from PHP-HTML


I’ve successfully installed mdb tools:
./configure –-with-unixodbc
make
make install

I tried to set up a DSN using ODBCConfig but it seems that the setup driver file is missing.

So I’ve manually insert DSN:


*** ODBC.INI:
[MSAccess]
Description = Microsoft Access
Driver = MDBToolsODBC
Database = /var/www/mdb/test.mdb
Servername = localhost
UserName =
Password =
Port = 5432


*** ODBCINST.INI:
[MDBToolsODBC]
Description = MDB Tools ODBC drivers
Driver = /usr/local/lib/libmdbodbc.so.0
Setup =
FileUsage = 1
CPTimeout =
CPReuse =


*** myappl.PHP:
<?php
$myDB = odbc_connect("MSAccess","","");
$query = "select mfg from tblModems";
$result = odbc_exec($myDB, $query);
$report = odbc_fetch_row($result);
echo odbc_result($result, 1);
odbc_close($myDB);

but when I try to use my DSN inside the php-html file MS Explorer tell me:

Warning: SQL error: [unixODBC]Could not find Database parameter, SQL state 08001 in SQLConnect in
/usr/keb/apache/htdocs-portal/keb-php/customer.php on line 72


line 72 is this: $myDB = odbc_connect("MSAccess","","");

oh by the way.. If I try isql command DSN works properly !


I don't know what to do !


Thanks in advance.

Did you find a solution ?
I've got the exact problem.

TIA