ASP code to execute Stored Proc

Question

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

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"

Anyone know how to solve this?

Answer 1

You need to specify a connection string.

conn.ConnectionString = "MyDatabase"

Answer 2

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

Answer 3

Could you post the code of your stored procedure? I'm willing to bet you're missing a

Set NoCount On