Oracle and ASP

From: qwest <jerryb_at_qwest.net>
Date: Thu, 27 Mar 2003 20:21:05 -0600
Message-ID: <zkOga.200$HG6.68222@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 Thu Mar 27 2003 - 20:21:05 CST