Re: No results from query in some contexts

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/24/05 

Date: Thu, 24 Nov 2005 09:49:19 -0500

Can you at least show us the code? My guess would be one of two things.
Either you are connecting to a different db or the ASP app is not formatting
the query properly. More specifically it may be treating the value in the
WHERE clause as the wrong datatype. But without seeing your query and the
DDL for the table we can make guesses all day long. 

-- 
Andrew J. Kelly  SQL MVP
"Iain" <Iain@idclTAKEAWAY.co.uk> wrote in message 
news:b3yk4d51xvex.h2leodn5zmip$.dlg@40tude.net...
>I have a database with a number of tables in and some stored procedures to
> read from them
>
> WHen I expect the sprocs from within VS2005 (or my asp.net application) I
> get no results returned, even though opening the table in VS 2005 shows 
> teh
> data I expect.
>
> Running the same sproc from SQL Server Management studio returns the
> expected results.
>
> The data was inserted in the tables (in at least one case) from teh 
> asp.net
> application that cannot now read it!
>
> I sort of think this could be a security / role related problem, but I
> really can't see what!
>
> Does this ring any bells?
>
>
> Iain
> -- 
> Iain Downs (DirectShow MVP)
> Commercial Software Therapist
> www.idcl.co.uk