我使用PDO Driver for FreeTDS与Zend Framework合作!
FreeTDS安装
您需要安装php5-sybase(Sybase连接器提供连接到MSSQL Server和Sybase所需的库)以及freeTDS软件和unixODBC。
要安装和配置FreeTDS,请参阅this link。
此外,this link提供了有关FreeTDS安装的良好读数。
配置连接字符串并与Zend Framework 1.11连接
在/etc/freetds/freetds.conf上配置您的连接,如下所示:
[MyServer]
host = <>
port = <>
# use 8.0 for newer versions of SQLSERVER
tds version = 8.0
# text size don't need to be such a high value, its just an example
text size = 4294967295
client charset = UTF-8然后,在Zend Framework 1.11上,像这样配置您的连接:
;; BANCO DE DADOS LINUX
database.adapter = PDO_MSSQL
database.params.pdoType = dblib
database.params.host = MyServer
database.params.dbname = <>
database.params.username = <>
database.params.password = <>
database.params.driver_options.charset = UTF-8
database.isDefaultTableAdapter = true