Resolved datareader return zero rows, but query in mssql studio returns one

[hobgoblinvasya]

hi all

as the title of the thread says i have a weird problem. when i execute sqlcommand.executereader, the resulting datareader has no rows.

however if i copy the text in the command text and execute it in my sql server management studio (word for word) it returns one row. is there a setting that i am missing? perhaps a security issue?

i am connecting using trusted connection = yes in my code, and integrated windows security with the sql management studio. thus theoretically the security settings should be exactly the same.

any help would be appreciated.
thanks.

edit: im using vs .net 2005 and sql management studio 2005.

 

[hobgoblinvasya]

ok, nvm. i figured it out right after posting this question. was connecting to the wrong db (replica instead of an actual db.) thus the record simply wasnt there

sorry for the trouble.