Fetching data from stored procedure.

[#1]

Hi All,

I could reload the script for fetching the data from my stored procedure Sample.

SQL

EXECUTE sample;

But am not able to see any available feilds out of it, and its showing blank , where as when am running the same SP am getting one value .

Could someone please help me out here?

Thanks,

Mahasweta

[#2]

I would suggest do a few checks:

1) See if you are using ODBC or native driver. Try changing the connection to use either one.

2) Check for null values in stored proc resultset and if possible replace nulls with some default value.

Thanks

Amit

[#3]

This heavily depends on the connection you are using.

I have made some tests on my machine:

- when using an ODBC-connection this does not work
- when using an OLEDB-connection this works

But as I said, this depends on your DB and the database-drivers ...

Which database are you using?

Best regards

Stefan