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
hakan.stroberg.vcf
Description: Vcard
|
Try Searching:
servers, voip, java, networking, microsoft ...
|
|
|
|