<?
$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 =
请问这个为什么连接有问题,是我哪里没配置正确么?
$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 =
请问这个为什么连接有问题,是我哪里没配置正确么?
网上有实现的方式 但是都很旧 我是在其中遇到的问题
所有能装的驱动都安装了 unixODBC,mdbtools-odbc,mdbtools
限制很多,项目比较麻烦,希望各位提提建议~~~沮丧的就不要提了~~已经倍受打击