linuxÏÂPHPÁ¬½ÓAccessÎÊÌâ

<?
$myDB=odbc_connect("Dogs","","");
$query="select name,weight from dog_list";
$result=odbc_do($myDB,$query);
while(odbc_fetch_row($result)){
        print odbc_result($result,"name");
        print odbc_result($result,"weight");
}
?>

ºǫ́´í:
[Tue Nov 24 02:52:29 2009] [error] [client 192.168.41.30] PHP Warning:  odbc_do() [ <a href='function.odbc-do'>function.odbc-do </a>]: SQL error: [unixODBC]Couldn't parse SQL\n, SQL state 08001 in SQLExecDirect in /var/www/html/b.php on line 4
[Tue Nov 24 02:52:29 2009] [error] [client 192.168.41.30] PHP Warning:  odbc_fetch_row(): supplied argument is not a valid ODBC result resource in /var/www/html/b.php on line 5

[root@yjj logs]# cat /etc/odbc.ini
[Dogs]
Description = Microsoft Access Database of Dogs
Driver = MDBToolsODBC
Database = /home/DKRecord.mdb
Servername = localhost
UserName =
Password =
port = 5432

[root@yjj logs]# cat /etc/odbcinst.ini
[MDBToolsODBC]
Description            = MDB Tools ODBC drivers
Driver          = /usr/lib/libmdbodbc.so.0
Setup          =
FileUsage