Question

数据库已打开，就是不显示

<table width="890" height="33" border="1" cellpadding="0" style="border-collapse: collapse; border-width: thin; border-style: solid; font-size: 14px;">
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset2.EOF))
%>
<tr>
<td width="97" height="27"><div align="left"><%=(Recordset2.Fields.Item("编号").Value)%></div></td>
<td width="344"><div align="left"><%=(Recordset2.Fields.Item("标题").Value)%></div></td>
<td width="226"><%=(Recordset2.Fields.Item("日期").Value)%></td>
<td width="106"><%=(Recordset2.Fields.Item("标记").Value)%></td>
<td width="91"><%=(Recordset2.Fields.Item("下载").Value)%></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset2.MoveNext()
Wend
%>
</table>
<%@LANGUAGE="VBSCRIPT"%>
<!--#include virtual="/Connections/SQL_xx.asp" -->
<%
Dim Recordset2
Dim Recordset2_cmd
Dim Recordset2_numRows
Set Recordset2_cmd = Server.CreateObject ("ADODB.Command")
Recordset2_cmd.ActiveConnection = MM_SQL_xx_STRING
Recordset2_cmd.CommandText = "SELECT * FROM b_xx"
Recordset2_cmd.Prepared = true
Set Recordset2 = Recordset2_cmd.Execute
Recordset2_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
Recordset2_numRows = Recordset2_numRows + Repeat1__numRows
%>

Answer 1

试着把新建数据库连接信息在tnsnames中建好,再打开plsql就可以看到新建数据库服务名了。