Oracle - Connect ASP Pages to Oracle Servers in Oracle

Connect ASP Pages to Oracle Servers in Oracle

Q

How To Connect ASP Pages to Oracle Servers in Oracle?

✍: FYIcenter.com

A

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 
%>

⇒ODBC Drivers and DSN Configuration for Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 482👍, 0💬

Define DSN with ODBC Manager in Oracle
How To Define a Data Source Name (DSN) in ODBC Manager in Oracle? DSN (Data Source Name) is an ODBC connection identifier for Windows applications. Here is how you can define a DSN on your Windows system: Go to Control Panel. Go to Administrative Tools. Run Data Sources (ODBC). Go to System DSN tab.... 2016-10-15, 570👍, 0💬

Connect MS Access to Oracle Servers in Oracle
How To Connect MS Access to Oracle Servers in Oracle? Once you got a DSN defined in the ODBC manager that connects to an Oracle server, you can connect a normal MS Access document to the Oracle server, and link an Access table to Oracle table. The tutorial below gives you a good example: Start MS Ac... 2016-10-15, 547👍, 0💬

Downloading and Installing MySQL on Windows
Where to find answers to frequently asked questions on Downloading and Installing MySQL on Windows? I want to learn how to install MySQL database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Downloading and Installing MySQL on Windows. Clear a... 2018-06-12, 495👍, 0💬

Connect ASP Pages to Oracle Servers in Oracle
How To Connect ASP Pages to Oracle Servers in Oracle? 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 ser... 2016-10-15, 483👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.