不连接sql2005的情况下能正常显示php页面,
但是一连接sql2005就显示
Call to undefined function mssql_pconnect()源码很简单
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<?php
$db_id = mssql_pconnect("127.0.0.1","sa","123456");//提示是这行错误
mssql_select_db("kcdb",$db_id);
$str="select top 10 * from zhichu"; //查询
$f_result = mssql_query("select top 5 * from zhichu",$db_id);
while($tmp=mssql_fetch_row($f_result)){
for($i=0;$i<count($tmp);$i++){
echo $tmp[$i].'<br/>';
}
mssql_close();
?></body>
</html>配置文件php.ini里面extension=php_mssql.dll前面的分号是去掉的.
但是一连接sql2005就显示
Call to undefined function mssql_pconnect()源码很简单
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<?php
$db_id = mssql_pconnect("127.0.0.1","sa","123456");//提示是这行错误
mssql_select_db("kcdb",$db_id);
$str="select top 10 * from zhichu"; //查询
$f_result = mssql_query("select top 5 * from zhichu",$db_id);
while($tmp=mssql_fetch_row($f_result)){
for($i=0;$i<count($tmp);$i++){
echo $tmp[$i].'<br/>';
}
mssql_close();
?></body>
</html>配置文件php.ini里面extension=php_mssql.dll前面的分号是去掉的.
如果没有,要安装MSSQL的客户端,或者要复制ntwdblib.dll到C:\windows\system32下面
这个是Off的有关系么?
你用phpinfo()检查MsSQL加载了没有?
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0 有看到mssql应该是加载了吧,刚刚发现extension_dir之前配的时候没改路径,现在改好了,又报另一个错误了
Unable to connect to server: 127.0.0.1
还是这句代码错
$db_id = mssql_pconnect("127.0.0.1","sa","123456");
晕了,加载了怎么还连不上呢,本机,密码也对的...
$link1 = mssql_pconnect('127.0.0.1\SQLEXPRESS', 'sa', '123456');要加上你的数据库实例名
在MSSQL服务里面可以看到实例名