Re: No results from query in some contexts

From: Iain (Iain_at_idclTAKEAWAY.co.uk)
Date: 11/25/05 

Date: Fri, 25 Nov 2005 09:49:23 +0000

On Thu, 24 Nov 2005 20:09:22 -0500, Andrew J. Kelly wrote:

> It must be a permissions thing with the sp and the account you are
> connecting with. Try giving execute permission directly to that account and
> maybe even read permission on that table as well. Then use profiler to
> ensure you are connecting and executing that proc as you expect. Other than
> that I don't see why you would be getting these results.

WEll, I'm running both environments on the same machine at the same time
with Integrated Security, which means both should be running the same user
(and of course I am an administrator ..)

Hold up!

I appear to have two different problems.

In my code I had a bug which meant I was not correctly reading the result
set.

Of course I immediately tried to run the query in VS2005 to see if it
worked. It appeared not to! The sproc works (and I can print the ROWCOUNT
so I KNOW the sproc has worked), but it does not display the results - just
the header (and it lies about the number of rows).

So I was trying to diagnose something which appears to be an oddity in
VS2005.

Sorry for this!

Iain 

-- 
Iain Downs (DirectShow MVP)
Commercial Software Therapist
www.idcl.co.uk
Quantcast