logo       
Google Custom Search
    AddThis Social Bookmark Button

PHP + unixODBC + MS Access: msg#00005

Subject: PHP + unixODBC + MS Access
Hi,

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

<?php
$mydb = odbc_connect("MSAccess-dummy","","");
$query = "select * from Addresses";
$result = odbc_exec($mydb,$query);
$report = 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 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 resource in */usr/local/httpd/htdocs/odbc.php* on line *5* *Warning*: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in */usr/local/httpd/htdocs/odbc.php* on line *6* *Warning*: odbc_result(): supplied argument is not a valid ODBC result resource in */usr/local/httpd/htdocs/odbc.php* on line *7* *Warning*: odbc_close(): supplied argument is not a valid ODBC-Link 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??? Which parameter??

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

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

My odbcinst.ini looks like:

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


My odbc.ini file looks like:

[MSAccess-dummy]
Description = Microsoft Access Events database
Driver      = MDBODBC
Database    = /home/hakans/dummy.mdb
Servername  = localhost
UserName    =
Password    =
Port        = 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åkan

Attachment: hakan.stroberg.vcf
Description: Vcard


Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>