Object Reference Error on ADODB.RecordSet Fields

[Donald Welker]

One of my developers is working on a .Net web app that has a wee bit o
legacy code in Page_Onload:

....
Dim MySelect as String = "SELECT User FROM DUAL"
Dim rs as ADODB.RecordSet
rs.Open(MySelect,Conn)
rs.MoveFirst
UNam = rs.Fields("User").Value
....

This code gets invoked separately from each of two web apps linked from an
HTML page.
The second web app fails to locate rs.Fields("User") and returns "Object
reference not set to an instance of an object." but it DOES succeed in
opening the recordset and retrieving a record.

If we assign the row to an array A and retrieve the value of A(0,0) we do
indeed get the correct string (the username as seen by the database)?!

Anybody got any ideas? (The connection is via Oracle 9.2)

[Ray at]

..NET doesn't like it when code assumes that it will use the default
property, i.e. recordsetObject.fields.ITEM(index).value

But I don't know that that is your problem. Take a look here.
[url]http://www.aspfaq.com/5002[/url]

Ray at work

"Donald Welker" <welkerdp@npt.nuwc.navy.mil> wrote in message
news:uGJwsEfiDHA.944@tk2msftngp13.phx.gbl...

> One of my developers is working on a .Net web app that has a wee bit o
> legacy code in Page_Onload:
>
> ...
> Dim MySelect as String = "SELECT User FROM DUAL"
> Dim rs as ADODB.RecordSet
> rs.Open(MySelect,Conn)
> rs.MoveFirst
> UNam = rs.Fields("User").Value
> ...
>
> This code gets invoked separately from each of two web apps linked from an
> HTML page.
> The second web app fails to locate rs.Fields("User") and returns "Object
> reference not set to an instance of an object." but it DOES succeed in
> opening the recordset and retrieving a record.
>
> If we assign the row to an array A and retrieve the value of A(0,0) we do
> indeed get the correct string (the username as seen by the database)?!
>
> Anybody got any ideas? (The connection is via Oracle 9.2)
>
>