Access Data in Oracle From ASP Pages

From: Gil & Sue - 2NLuv2C <cuaresma_a_at_email.msn.com>
Date: Wed, 22 Sep 1999 15:56:34 -0500
Message-ID: <u3mbMyTB$GA.338@cpmsnbbsa05>

Hi,

I'm having trouble displaying the records in Oracle from ASP. This is what it looks like:

<html>
<body>
<%

SET connDB = SERVER.CREATEOBJECT("ADODB.Connection") connDB.OPEN "CompanyDatabase"
sqlResults = "SELECT EMPLOYEE_ID, EMPLOYEE_NAME FROM EMPLOYEES" SET rstResults = SERVER.CREATEOBJECT("ADODB.Recordset") rstResults.OPEN sqlResults, connDB, ADOPENSTATIC

rstResults.MOVEFIRST
DO UNTIL rstResults.EOF

RESPONSE.WRITE rstResults("EMPLOYEE_ID") & " " & rstResults("COUNTY_NAME")

rstResults.MOVENEXT
LOOP
%>

</body>
</html>

... and I already have an ODBC Driver set up.

Tell me how to do it???

Thanks. Received on Wed Sep 22 1999 - 15:56:34 CDT