如何通过 PHP 和 Linux 使用 pdo 连接到 mssql?
问题描述:
我正在尝试使用以下代码建立新的 PDO 连接.
I'm trying to for a new PDO connection using the following code.
new PDO("mssql:driver=????;Server={$serverName};Database={$databaseName}", $username, $password, array(PDO::ATTR_PERSISTENT => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
我不确定要使用哪些驱动程序?或者如何安装它们.我可以使用 PHP 中的 mssql_connect
函数完美连接,但我想改用 PDO 库.
I'm not sure what drivers to use? Or how to install them. I can connect perfectly fine using the mssql_connect
function in PHP but I want to use the PDO library instead.
我的 php.ini
mssql 设置是:
My php.ini
settings for mssql are:
ssql
MSSQL Support enabled
Active Persistent Links 0
Active Links 1
Library version FreeTDS
Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.charset no value no value
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60
答
PDO mssql 驱动没有了,使用sqlsrv
(php windows下)或dblib
(下php linux)
The PDO mssql driver is no more, use sqlsrv
(under php windows) or dblib
(under php linux)