为什么总是链接不上SQLSERVER

[lhh1002]

<?php 
 $conn=mssql_connect("127.0.0.1","sa","123456"); 
 if($conn) 
 { 
  echo("链接"); 
 } 
?> 

始终出现如下错误

Fatal error: Call to undefined function mssql_connect() in E:\wwwroot\phptest\PHP\index.php on line 3 

我的PHP是php-5.3.2-nts-Win32-VC9-x86.msi
sql驱动是php_sqlsrv_53_nts_vc9.dll

php.ini也做了相应配置
; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.
extension=php_sqlsrv_53_nts_vc9.dll

请教

[CunningBoy]

问题是MsSQL没有加载成功
用phpinfo()看看，MsSQL模块有没有加载

[Dleno]

mssql扩展没有装载上。

[「已注销」]

sqlsrv support:enabled
Directive Local Value Master Value
sqlsrv.LogSeverity 0 0
sqlsrv.LogSubsystems 0 0
sqlsrv.WarningsReturnAsErrors On On


以上就是我的 sql信息

[Dleno]

mssql不是sqlsrv

[CunningBoy]

[Quote=引用 4 楼 dingsongtao 的回复:]

mssql不是sqlsrv
[/Quote]

对头

[「已注销」]

5.3.2的php.ini中应该如何配置啊

[yanwen0023]

用dns连接

[rodsgo]

楼主用的是微软开发的sqlsrv请用PDO版
php_pdo_sqlsrv_53_nts_vc9.dll
还要安装
http://msdn.microsoft.com/en-us/data/aa937733.aspx 这个东东
连接示例如下

<?php
try {
   $conn = new PDO( "sqlsrv:Server=(local);Database=AdventureWorks", NULL, NULL); 
   $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );}

catch( PDOException $e ) {
   die( "Error connecting to SQL Server" ); 
}

echo "Connected to SQL Server\n";

$query = 'select * from Person.ContactType'; 
$stmt = $conn->query( $query ); 
while ( $row = $stmt->fetch( PDO::FETCH_ASSOC ) ){ 
   print_r( $row ); 
}
?>

[super_peter]

php连mssql，除了php.ini需要配置（开启php_mssql.dll）外，还要把ntwdblib.dll这个组件放到php服务器的c:/windows/system32下面，如果连mssql2005，ntwdblib.dll的两个版本（2000.2.8.0和2000.80.194.0）都行；如果要连mssql2000时必须用2000.80.194.0这个版本。

[yangzewei2006]

SQL DLL版本不对，在网上找个相应的版本下载，放到SYSTEM32下面即可