hobgoblinvasya
Member
- Joined
- Feb 18, 2009
- Messages
- 12
- Programming Experience
- 1-3
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.
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.
Last edited: