zend框架2和sqlserver驱动程序问题 [英] zend framework 2 and sqlserver driver issues

问题描述

当我尝试从我的zf2应用程序连接到我的sql服务器数据库，如下所示，

when i try connecting to my sql server database from my zf2 application as shown below,

return array(
    'db' => array(
        'driver' => 'Pdo',
        'dsn'            => 'sqlsrv:dbname=album;hostname=192.168.0.20',
        'username'       => 'user',
        'password'       => 'pass',
        'driver_options' => array(
            PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
        ),
    ),
    'service_manager' => array(
        'factories' => array(
            'Zend\Db\Adapter\Adapter' => 'Zend\Db\Adapter\AdapterServiceFactory',
        ),
    ),
);

我收到此错误，

File:
/usr/local/zend/apache2/htdocs/zf2-tutorial/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Pdo/Connection.php:289
Message:
Connect Error: could not find driver

缺少这里的东西？

Am i missing something here? Or rather this does not work at all on the linux oriented machines ?

推荐答案

尝试取出这行：// PDO :: MYSQL_ATTR_INIT_COMMAND =>'SET NAMES \'UTF8\''。
您的连接说明您正在尝试连接到 MSSQL ，而不是 MySQL 。

Try taking out this line: "// PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''". Your connection say you are trying to connect to MSSQL and not MySQL.

return array(
    'db' => array(
        'driver' => 'Pdo',
        'dsn'            => 'sqlsrv:dbname=album;hostname=192.168.0.20',
        'username'       => 'user',
        'password'       => 'pass',
        'driver_options' => array(
           // PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''
        ),
    ),
    'service_manager' => array(
        'factories' => array(
            'Zend\Db\Adapter\Adapter' => 'Zend\Db\Adapter\AdapterServiceFactory',
        ),
    ),
);

这篇关于zend框架2和sqlserver驱动程序问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！