Problem with the Recordset

[Pjam]

Hello everyone,

I have a web application written in asp,Visual studio .net 2002.My problem is that I execute a sql server store procedure and I get an empty recordset, while executing the same sp on query anlyzer I can see 5 records.Basically the sp create a temp table, populate it, and lastly selects the results from the temp table.

I am not sure whether the recordset is empty or not.Bcoz the recordset.RecordCount n recordset.EOF doesn't return any values.It looks like they are not getting executed.

Please help me to get solve this problem.

Regards,
Prakash James.

[jeffstl]

Hello everyone,

I have a web application written in asp,Visual studio .net 2002.My problem is that I execute a sql server store procedure and I get an empty recordset, while executing the same sp on query anlyzer I can see 5 records.Basically the sp create a temp table, populate it, and lastly selects the results from the temp table.

I am not sure whether the recordset is empty or not.Bcoz the recordset.RecordCount n recordset.EOF doesn't return any values.It looks like they are not getting executed.

Please help me to get solve this problem.

Regards,
Prakash James.

It would help if we could see both the sp SQL as well as your application SQL.

Also if the SQL is not executing properly is it returning an error of any kind?

Please post any errors from executing that SQL here.

Double check any values or parameters you are passing to your application SQL and make sure they are correct and match with the sp SQL.

[jhardman]

I have a web application written in asp,Visual studio .net 2002.

So is this an ASP project (unlikely) or an ASP.NET (also called ASPX) project? If it is the latter, you need to post in the .NET forum, the ASP forum won't help.

Jared