更新时间:2023-02-22 16:28:12
p> PDO mssql驱动没有更多,使用 sqlsrv
(在php windows下)或 dblib
http://msdn.microsoft.com /en-us/sqlserver/ff657782.aspx
http://www.php.net/manual/en/ref.pdo-dblib.php
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));
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'm wanting to use the PDO library instead.
Please let me know if you have an ideas on how to either solve my issue or how I can word my question better?
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
Thanks
The PDO mssql driver is no more, use sqlsrv
(under php windows) or dblib
(under php linux)