php版本5.3.5
操作系統win7
使用mssql方式鏈接:
$hostname = '192.168.0.178:1435';
$username = 'test';
$password = 'test';
mssql_connect($hostname, $username, $password);
程序報錯:
Fatal error: Call to undefined function mssql_connect()
使用phpinfo(),顯示沒有mssql信息
查看php.ini,已經有:
extension=php_mssql.dll
經驗證,和上面的擴展無關,需要另一擴展:
extension=php_dblib.dll
加入之后重啟apache,顯示:
mssql
MSSQL Support
enabled
Active Persistent Links
0
Active Links
0
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
On
On
mssql.textlimit
Server default
Server default
mssql.textsize
Server default
Server default
mssql.timeout
60
60
另有此文:
說明php5.3以上已不是原生支持mssql,也就是說,使用php_dblib.dll來支持mssql,而不是php_mssql.dll