ASP & SQL Server Stored Procedures

[cstrong]

Hey all,

OK, we have some stored procedures in one of our test databases which are called from an ASP page on our intranet.

The sp is only a simple INSERT statement and only inserts one row each time the SP is called.

This works just fine from Query Analyser.

However, when called from a ASP page, it won't work. The only way it works is if we have a SELECT statement in the SP! I will be posting this within an ASP forum also but I was wondering if any of you had seen this before as it sounds pretty bizarre to me!!

By the way, the error on the ASP page is that the Recordset is Closed. I did not write the ASP code and have pretty much no knowledge of it!!

Thanks!
Clive

 

[stakadush]

can you post your code? (-:

 

[bgreenhouse]

Clive - why does a recordset enter in to it? I don't understand why there would be any recordset needing to be accessed if you're just sending variables to a sp. Can you post your code?

Ben