电信免流量卡:ASP 页面中如何连接远程SQL SERVER2000?

说明:在局域网中有一台安装SQL SERVER 2000的机器,我远程ping 正常,远程SQL SERVER2000客户端也能正常连接打开其中数据库,请问我想通过ASP页面实现对远程SQL SERVER 2000数据库的查询操作, 在ASP页面中使用如下脚本,为什么连接不上?

<%
on error resume next
strconn = "Driver={SQL Server};SERVER=10.97.1.27;DATABASE=ABRSCAN;UID=sa;PWD=sa"
'strconn = "PROVIDER=SQLOLEDB;DATA SOURCE=10.97.1.27;UID=sa;PWD=sa;DATABASE=ABRSCAN"
set conn = server.createobject("adodb.connection")
conn.open strconn

%>
<%
dim rs
set rs = server.createobject("adodb.recordset")

%>

<%
sql="select * from ciginfo "
'sql=sql&"download.id,download.showname,bb,download.dateandtime,download.hits,download.classid,download.Nclassid,Nclass.Nclass "
'sql=sql&" from ciginfo "
'sql=sql&" order by download.dateandtime desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
%>
<tr>
<td bgcolor="#ecfaff">没有记录!!!</td>
</tr>
<%else%>
<%
do while not rs.eof
barcode = rs("barcode")
'if(len(name)>26) then name = left(name,26) + "...."

%>
<tr>
<td width="100%" height="24" bgcolor="#ecfaff" >  <img src="images/RedArrow.gif" width="4" height="7">  [<%=rs("barcode")%>]  <font color='#999999'> <font color=red> <font color='#999999'> </font></font></font><span class="style1"></span></td>
<%
rs.movenext
loop
end if
rs.close
%>
去掉 on error resum next 后
显示:

Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

[Microsoft][ODBC SQL Server Driver][Named Pipes]没有发现指定的 SQL Server。

/no1/conn.asp，行18

-------------------------------------------------
我希望在ASP页面中实现对远程SQL SERVER 2000的操作
请指点---