用网上的测试代码试的。服务器上php,mssql都正常运行。php和mysql连接正常,asp与mssql连接正常。然后windows目录下的php.ini
;extension=php_mssql.dll前面的;去掉
extension_dir = "extensions的目录"
已经设置好了的。<?php
//$con=mssql_connect("localhost","sa","555");
$con->Open("Provider=SQLOLEDB; Data Source=(local);Initial Catalog=ev991; User ID=sa; Password=555");
echo $con;
if(!$con)
echo "<br>连接成功";
else
echo "连接失败";
?>
没有任何出错信息。
;extension=php_mssql.dll前面的;去掉
extension_dir = "extensions的目录"
已经设置好了的。<?php
//$con=mssql_connect("localhost","sa","555");
$con->Open("Provider=SQLOLEDB; Data Source=(local);Initial Catalog=ev991; User ID=sa; Password=555");
echo $con;
if(!$con)
echo "<br>连接成功";
else
echo "连接失败";
?>
没有任何出错信息。
$con=mssql_connect( "localhost ", "sa ", "555 ");
echo $con;
if(!$con)
echo " <br >连接成功 ";
else
echo "连接失败 ";
? > 那这个总该是对的吧??一样不行啊
这个我在本机测试正常的
$link = mssql_connect("localhost", "userid", "secret");
mssql_select_db("MyDB", $link);
$SQL = "Select * from table1 select * from table2";
$rs = mssql_query($SQL, $link);
do {
while ($row = mssql_fetch_row($rs)) {
}
} while (mssql_next_result($rs));
mssql_free_result($rs);
mssql_close($link);
?>