21,886
社区成员
发帖
与我相关
我的任务
分享
$conn=new COM('ADODB.Connection') or die('连接错误');
$myDSN="Provider=SQLNCLI.1;Persist Security Info=True;Data Source=localhost;User ID=sa;Password=sasa;Initial Catalog=db_php";
$conn->open($myDSN) or die('连接语句无效');
$sql="select * from [username]";
$rs=$conn->execute($sql);
if($rs->eof()){
print('没有任何数据');
}else{
while(!$rs->eof()){
echo $rs->fields[0]->value;
$rs->movenext();
}
}
上面代码出现 “连接语句无效” 什么原因呢。
$myDSN="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER={localhost\SQLSERVER};DATABASE=db_php;UID=sa;PWD=sasa;";
$myDSN="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=localhost\SQLSERVER};DATABASE=db_php;UID=sa;PWD=sasa;";
$myDSN="PROVIDER=MSDASQL;DRIVER={SQL Server};zc38={localhost\这里是实例名};DATABASE=db_php;UID=sa;PWD=sasa;";