你现在找不到指定的模块怎么还会这样?出现错误提示: Fatal error: Call to undefined function: mssql_pconnect() in E:\homepage\career\publib\mssql.php on line 26应该直接就是 Unknown(): Unable to load dynamic library 'C:\php\extensions\php_mssql.dll'能再描述的清楚一点嘛
把PHP_MSSQL.DLL复制到了SYSTEM32看看. 你机子上有没有装sql server?
to caotian2000() :我的是IIS平台上配置PHP,连接sql server数据库,php.ini配置改成extension_dir = "C:\php\extensions\" ;extension=php_mssql.dll分号去掉然后它就提示 Unknown(): Unable to load dynamic library 'C:\php\extensions\php_mssql.dll' - 找不到指定的模块 但我到C:\php\extensions\文件夹里能找到php_mssql.dll,高手们,请帮帮忙,解决了立即给分
to leakey8(做人累,做男人更累。) : 1/我已经把extensions目录所有文件都拷过去了,还是这样 2/我是连接到另外一台电脑的数据库,本机并没有安装sql server我想会不会是我配置完重启服务器的方法有错
我是写成一个类<?php class mssql { var $dbhost="192.168.0.10"; //数据库地址 var $dbuser="sa"; //数据库用户名 var $dbpw="sa"; //数据库密码 var $dbname="test";//数据库名称 var $rs; var $num=0; ////////////// init class /////////////////// function mssql($dbhost="", $dbuser="", $dbpw="",$dbname="") { $this->dbhost = $dbhost ? $dbhost: $this->dbhost; $this->dbuser = $dbuser ? $dbuser: $this->dbuser; $this->dbpw = $dbpw ? $dbpw: $this->dbpw ; $this->dbname = $dbname ? $dbname: $this->dbname; $this->connect(); /////connect server $this->select_db(); ///// select database } function connect($dbhost="",$dbuser="",$dbpw="") { $dbhost = $dbhost ? $dbhost : $this->dbhost; $dbuser = $dbuser ? $dbuser : $this->dbuser; $dbpw = $dbpw ? $dbpw : $this->dbpw ; if(!mssql_connect($dbhost, $dbuser, $dbpw)) { $this->halt('Can not connect to server'); } } function select_db($dbname="") { $dbname=$dbname?$dbname:$this->dbname; return @mssql_select_db($dbname); }
出现这样的错误: Warning: mssql_pconnect(): Unable to connect to server: 192.168.8.241 in E:\homepage\career\publib\test.php on line 2我只写了一句 $link = mssql_pconnect("192.168.8.241", "sa", "1101"); 又是什么问题啊?
Fatal error: Call to undefined function: mssql_pconnect() in E:\homepage\career\publib\mssql.php on line 26应该直接就是
Unknown(): Unable to load dynamic library 'C:\php\extensions\php_mssql.dll'能再描述的清楚一点嘛
你机子上有没有装sql server?
;extension=php_mssql.dll分号去掉然后它就提示
Unknown(): Unable to load dynamic library 'C:\php\extensions\php_mssql.dll' - 找不到指定的模块
但我到C:\php\extensions\文件夹里能找到php_mssql.dll,高手们,请帮帮忙,解决了立即给分
1/我已经把extensions目录所有文件都拷过去了,还是这样
2/我是连接到另外一台电脑的数据库,本机并没有安装sql server我想会不会是我配置完重启服务器的方法有错
class mssql
{
var $dbhost="192.168.0.10"; //数据库地址
var $dbuser="sa"; //数据库用户名
var $dbpw="sa"; //数据库密码
var $dbname="test";//数据库名称 var $rs;
var $num=0;
////////////// init class ///////////////////
function mssql($dbhost="", $dbuser="", $dbpw="",$dbname="")
{
$this->dbhost = $dbhost ? $dbhost: $this->dbhost;
$this->dbuser = $dbuser ? $dbuser: $this->dbuser;
$this->dbpw = $dbpw ? $dbpw: $this->dbpw ;
$this->dbname = $dbname ? $dbname: $this->dbname;
$this->connect(); /////connect server
$this->select_db(); ///// select database
}
function connect($dbhost="",$dbuser="",$dbpw="")
{
$dbhost = $dbhost ? $dbhost : $this->dbhost;
$dbuser = $dbuser ? $dbuser : $this->dbuser;
$dbpw = $dbpw ? $dbpw : $this->dbpw ;
if(!mssql_connect($dbhost, $dbuser, $dbpw))
{
$this->halt('Can not connect to server');
}
} function select_db($dbname="")
{
$dbname=$dbname?$dbname:$this->dbname;
return @mssql_select_db($dbname);
}
function query($sql)
{
$query = mssql_query($sql);
$this->rs=$query;
if(!$query)
print_r($sql); // $this->halt('SQL Query Error');
return $query;
}
//为型如 selsect * from xxx where xxx limit 0,2这样的查询设立的
// ms sql不支持? 不知道哦 管它了
function limit($start,$limit)
{
///移动内部指针
$rows=mssql_num_rows($this->rs);
$start=$start<0?"0":$start;
if($start>=$rows) //没有剩下的了
{
$this->num=0;
return 0;
}
//结果剩余的条数
if(($start+$limit)<=$rows) //合法的
$this->num=$limit;
else
$this->num=$rows-$start; //也就是说 num最小都有 1 ???
mssql_data_seek($this->rs,$start); //移动
return $this->rs;
}
function fetch_object($rs="")
{
$rs=$rs?$rs:$this->rs;
return @mssql_fetch_object($rs);
}
function fetch_array($rs="")
{
$rs=$rs?$rs:$this->rs;
return @mssql_fetch_array($rs);
}
function fetch_row ($rs="")
{
$rs=$rs?$rs:$this->rs;
return @mssql_fetch_row($rs);
}
function data_seek($record_id)
{
return @mssql_data_seek($record_id);
}
function num_rows($rs="")
{
$rs=$rs?$rs:$this->rs;
return @mssql_num_rows($rs);
}
function affected_rows($rs="")
{
$rs=$rs?$rs:$this->rs;
return @mssql_rows_affected($rs);
}
function halt($message ="")
{
echo $message;
exit();
}
function free_result()
{
return mssql_free_result($this->rs);
}
/*
function result($row)
{
return @mssql_result($this->rs, $row);
}
function fetch_row()
{
return mssql_fetch_row($this->rs);
}
function close()
{
return mssql_close();
}
*/
}
?>
Unknown(): Unable to load dynamic library 'C:\php\extensions\php_mssql.dll' - 找不到指定的模块
复制这个文件到system32下或装一下sql server客户端
Warning: mssql_pconnect(): Unable to connect to server: 192.168.8.241 in E:\homepage\career\publib\test.php on line 2我只写了一句
$link = mssql_pconnect("192.168.8.241", "sa", "1101");
又是什么问题啊?