且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用pdo通过php和linux连接到mssql

更新时间: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)

http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx

http://www.php.net/manual/en/ref.pdo-dblib.php