How to access data using VBSCRIPT from a stored procedure which contains values in Temp table ?

Question

Hi , for testing purpose I wrote a VBscript which will fetch values from Sybase by executing a stored procedure which contains values in temp table. When I run the script I get the following errors ,

"Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."

or

"Item cannot be found in the collection corresponding to the requested name or ordinal."

Somewhere when I was googling I found that , the above error message will be shown when we use temp table in stored procedure, if that is the reason , then how can I access data via VBscript by executing the stored procedure ?? I am using QTP to run VBScript

Answer 1

I don't know Sybase as well but it sounds like the recordset you return either has field names different than what you are expecting OR its not even there.

I assume you are inserting into the temp table and then eventually selecting from it to return the values. If sybase supports it, use a Set NOCOUNT On at the beginning of your stored proc.

You likely are getting multiple recordsets back and the first one isn't the one you want.

Answer 2

Hi i am also facing the same issue...while doing connectivity of QTP to SQL server... Could yoy expalin it briefly