但是同样的DSN,在thinkphp就是能连接,但是好像最基本的模型操作都无法支持,比如select()方法。
一直报错:
:(
[ SQL语句 ] : DESCRIBE tb_user
错误位置
FILE: E:\php\ThinkPHP\Extend\Driver\Db\DbPdo.class.php LINE: 104
这是直接连接的代码:
$conn = new PDO('firebird:dbname=localhost/3050:E:\database\test.fdb','sysdba','masterkey');
$sql = 'SELECT * from tb_user;';
$data = $conn->query($sql)->fetchAll();
foreach ($data as $row){
echo $row['ID'] . "\t";
echo $row['NAME'] . "\t";
echo $row['LOGIN'] . "\t";
echo $row['PASSWD'] . "<br />";
}用thinkphp的配置 'DB_Type' => 'pdo',
'DB_DSN' => 'firebird:dbname=localhost/3050:E:\database\test.fdb',
'DB_USER' => 'sysdba',
'DB_PWD' => 'masterkey',
'DB_PREFIX' => 'tb_', Action里这样查询:
class IndexAction extends Action {
public function index(){
$tb = M('user');
$d = $tb->select();
dump($d);
}
} 最佳答案