Professional Web Applications Themes

Operation is not valid due to the current state of the object - ASP.NET

I'm using the Oracle .NET data provider in my ASP.NET application to connect to Oracle. I am recieveing the error: System.InvalidOperationException: Operation is not valid due to the current state of the object. I'm getting this error when I try to access the OracleDataReader object variable like so... while ( reader.Read() ) { Response.Write (reader["field1"].ToString() ); // THIS IS WHERE THE ERROR OCCURS!!! } The code runs fine in a C# console application...so it has to be an ASP.NET issue, and I'm thinking it is probably a security setting somewhere. Thanks for any help!...

  1. #1

    Default Operation is not valid due to the current state of the object

    I'm using the Oracle .NET data provider in my ASP.NET application to connect
    to Oracle. I am recieveing the error:

    System.InvalidOperationException: Operation is not valid due to the current
    state of the object.

    I'm getting this error when I try to access the OracleDataReader object
    variable like so...

    while ( reader.Read() )
    {
    Response.Write (reader["field1"].ToString() ); // THIS IS WHERE THE
    ERROR OCCURS!!!
    }

    The code runs fine in a C# console application...so it has to be an ASP.NET
    issue, and I'm thinking it is probably a security setting somewhere.

    Thanks for any help!

    --dweezil Guest

  2. #2

    Default RE: Operation is not valid due to the current state of the object


    Hi,

    If you had earlier installed .NET Data Provider for Oracle initially, and
    now you are using .net 1.1, which has a built in oracle client, this might
    occur.

    Try uninstalling the .net data provider for Oracle.

    Thanks.



    "--dweezil" wrote:
    > I'm using the Oracle .NET data provider in my ASP.NET application to connect
    > to Oracle. I am recieveing the error:
    >
    > System.InvalidOperationException: Operation is not valid due to the current
    > state of the object.
    >
    > I'm getting this error when I try to access the OracleDataReader object
    > variable like so...
    >
    > while ( reader.Read() )
    > {
    > Response.Write (reader["field1"].ToString() ); // THIS IS WHERE THE
    > ERROR OCCURS!!!
    > }
    >
    > The code runs fine in a C# console application...so it has to be an ASP.NET
    > issue, and I'm thinking it is probably a security setting somewhere.
    >
    > Thanks for any help!
    >

    ranganh Guest

Similar Threads

  1. Operation is not allowed when the object is closed
    By Ian Currie in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: December 22nd, 11:47 PM
  2. Replies: 3
    Last Post: March 9th, 05:19 PM
  3. Replies: 2
    Last Post: November 22nd, 06:15 AM
  4. Replies: 1
    Last Post: November 5th, 01:03 PM
  5. Object in application state
    By Jenny in forum ASP.NET General
    Replies: 0
    Last Post: July 30th, 07:04 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139