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 = 2
CPTimeout =
CPReuse =
请问这个为什么连接有问题,是我哪里没配置正确么?