asp连接数据库的问题?急急急
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
dim strname,strpassword,sql,conn,str
dim n
sql="select * from jobs"
str="DRIVER={SQL Server};SERVER=mysqlserver;UID=sa;PWD=sa;DATABASE=pubs"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open str
set rstemp=server.createobject("adodb.recordset")
rstemp.Open sql,conn
Response.Write rstemp.RecordCount
for n=0 to rstemp.RecordCount-1
Response.Write rstemp.Fields(1).Value
next
%>
</BODY>
</HTML>
以上是我的asp代码,运行没有问题,但是可是为设么运行
"Response.Write rstemp.RecordCount "时出现却是-1呢?
很奇怪,我用的是sqlserver中默认的pubs数据库,表是jobs!!!!!有记录的!