Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Connect ASP Pages to Oracle Servers

By: FYIcenter.com

(Continued from previous topic...)

How To Connect ASP Pages to Oracle Servers?

If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the correct Oracle ODBC driver and define a DSN on the IIS Web server.

Then you can use ADODB objects to connect to the Oracle server over the ODBC driver in your ASP pages. The tutorial example below gives you a good example:

<%
   Set oConn = Server.CreateObject("ADODB.Connection")
   oConn.Open "DSN=FYI_DSN;UID=fyi;PWD=retneciyf"
   Set oRS = oConn.Execute("SELECT * FROM dev_faq")
   Response.write("<p>Data from Oracle server via ODBC:")
   Response.write("<pre>")
   Do While NOT oRS.EOF
      Response.Write(oRS("ID") & vbcrlf)
      oRS.MoveNext 
   Loop
   Response.write("</pre>")
   oRS.close
   oConn.close 
%>

  1. What Is Open Database Communication (ODBC)?
  2. How To Install Oracle ODBC Drivers?
  3. How To Find Out What Oracle ODBC Drivers Are Installed?
  4. How Can Windows Applications Connect to Oracle Servers?
  5. How To Create Tables for ODBC Connection Testing?
  6. How To Verify Oracle TNS Settings?
  7. How To Define a Data Source Name (DSN) in ODBC Manager?
  8. How To Connect MS Access to Oracle Servers?
  9. How To Connect ASP Pages to Oracle Servers?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...