用的是adodb链接的 代码:
include_once("./common/adodb/adodb.inc.php");
$con=ADONewConnection("mssql"); $link=$con->Connect("192.168.0.117","sa","123456","backManger"); if($link)
{
echo "YES"; }else
{
echo "NO"; }错误:Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.0.117 in D:\wamp\www\myproject\mine\common\adodb\drivers\adodb-mssql.inc.php on line 520
include_once("./common/adodb/adodb.inc.php");
$con=ADONewConnection("mssql"); $link=$con->Connect("192.168.0.117","sa","123456","backManger"); if($link)
{
echo "YES"; }else
{
echo "NO"; }错误:Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.0.117 in D:\wamp\www\myproject\mine\common\adodb\drivers\adodb-mssql.inc.php on line 520
这个里面的东西, 第520行,粘代码你直接这样连接看看
$link = mssql_connect("192.168.0.117","sa","123456");
如果这样的都有错, 先检查一下这个"192.168.0.117"有没问题
直接一个
$conn = new COM("ADODB.Connection");
然后一段连接字符串就可以了啊!
操作非常之方便和ASP操作SQL Server 一样!