+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    hobgoblinvasya is offline VB.NET Forum Newbie hobgoblinvasya is on a distinguished programming path ahead
    .NET Framework
    .NET 2.0 (VS 2005)
    Join Date
    Feb 2009
    Posts
    12
    Reputation
    21

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

    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.
    Last edited by hobgoblinvasya; 06-30-2009 at 1:56 PM.

  2. #2
    hobgoblinvasya is offline VB.NET Forum Newbie hobgoblinvasya is on a distinguished programming path ahead
    .NET Framework
    .NET 2.0 (VS 2005)
    Join Date
    Feb 2009
    Posts
    12
    Reputation
    21

    Default

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts