用于执行存储过程的ASP代码

I am getting error trying to run my asp code for executing stored proc.

我试图运行我的asp代码执行存储过程时收到错误。

my code is:

我的代码是:

Set conn = server.createobject("ADODB.connection")
conn.open

Set rs = server.createobject("ADODB.recordset")
strSQL = "exec spActiveEmployee"
rs.open strSQL, conn, 3, 3

I am getting an error that says: - "Either BOF or EOF is True or the current record has been deleted"

我收到一条错误消息: - “BOF或EOF为True或当前记录已被删除”

Anyone know how to solve this?

有谁知道如何解决这个问题?

2 个解决方案

#1

Check this out: Why do I get 'BOF or EOF' errors?

看看这个:为什么我会收到'BOF或EOF'错误?

#2

You need to specify a connection string.

您需要指定连接字符串。

conn.ConnectionString = "MyDatabase"

#1