Re: Oracle and ASP

At least in your code, you're not making the connection to the database.

You will be in the infinite loop because you are getting an 'operation not valid when the object is closed' error while trying to loop through the recordset. Your recordset cannot move next (not valid) so it just loops again

Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open constr

"qwest" <jerryb_at_qwest.net> wrote in message news:zkOga.200$HG6.68222_at_news.uswest.net...
> Hello all!
>
> I'm trying to connect to an Oracle db via ASP and am
> having the following problem:
>
> When I go to the page, nothing displays. It acts (on the
> browser side) as if it were an open loop and doesn't
> finish. I've given it about 10 minutes to run and came
> back with no further progress. My code follows:
>
> <%
> ConStr = "Driver={Oracle ODBC Driver};" & _
> "Dbq=RATDB.world;" & _
> "Uid=DETECTIVE;" & _
> "Pwd=DETECTIVE"
>
> Set RS = Server.CreateObject("ADODB.RecordSet")
> SQL = "SELECT * FROM DISH_LOCATION;"
> RS.open SQL, ConStr
>
> do until RS.eof
> response.write RS("DLOC_ID") & " " & RS
> ("DLOC_DESC") & "<br><br>"
> RS.movenext
> loop
>
> RS.close
> set RS = nothing
> %>
>
> Any help is extremely appreciated.
>
> J :-)
>
>
Received on Fri Mar 28 2003 - 07:29:23 CST