使用pdo通过php和linux连接到mssql [英] Connecting to mssql using pdo through php and linux

问题描述

 新的PDO（mssql：driver = ???? Server = {$ serverName}; Database = {$ databaseName}，$ username，$ password，array（PDO :: ATTR_PERSISTENT => false，PDO :: ATTR_ERRMODE => PDO :: ERRMODE_EXCEPTION）） ; 
  

我不知道使用什么驱动程序？或如何安装它们。我可以使用PHP中的mssql_connect函数完美连接，但我想要使用PDO库。

如果您有关于如何解决我的问题或如何更好地说明我的问题的想法，请告诉我们。

我的php.ini设置为mssql是：

ssql

/>
活动持久链接0

活动链接1

库版本FreeTDS

指令本地值主值

mssql.allow_persistent开启

mssql.batchsize 0 0

mssql.charset没有值没有值

mssql.compatability_mode关闭

mssql.connect_timeout 5 5

mssql.datetimeconvert开启

mssql.max_links无限无限

mssql.max_persistent无限无限

mssql.max_procs无限无限

mssql.min_error_severity 10 10

mssql.min_message_severity 10 10

mssql.secure_connection关闭

mssql.textlimit服务器默认服务器默认值

mssql.textsize服务器默认服务器默认值

mssql.timeout 60 60

感谢

解决方案

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

这篇关于使用pdo通过php和linux连接到mssql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！