How To Connect ASP Pages to Oracle Servers

Q

How To Connect ASP Pages to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection

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

2007-04-17, 5505👍, 0💬

How To Define a Data Source Name (DSN) in ODBC Manager
How To Define a Data Source Name (DSN) in ODBC Manager? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection 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 Administ... 2007-04-17, 8513👍, 0💬

What Are the "mysql" Command Line Arguments
What Are the "mysql" Command Line Arguments? - MySQL FAQs - Command-Line End User Interface mysql "mysql" supports only one optional command line argument, "database". But "mysql" allows the operating system to redirect input and output streams at the command line level. Here are some good examples:... 2007-05-10, 5901👍, 0💬

How To Connect MS Access to Oracle Servers
How To Connect MS Access to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection 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 tab... 2007-04-17, 5753👍, 0💬

Java Bean Class with 100 Fields
How to write a bean class, when you have 100 fields and each have three sub fields. 2007-04-26, 5607👍, 0💬

How Can Windows Applications Connect to Oracle Servers
How Can Windows Applications Connect to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection A Windows application can connect to an Oracle server directly, if it knows how to use the Oracle TNS technology. A Windows application can connect to an Oracle server indire... 2007-04-17, 5514👍, 0💬

How To Connect ASP Pages to Oracle Servers
How To Connect ASP Pages to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection 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 co... 2007-04-17, 5506👍, 0💬

How To Create Tables for ODBC Connection Testing
How To Create Tables for ODBC Connection Testing? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here: SQL> CONNECT system/ret... 2007-04-17, 5475👍, 0💬

How Many SQL DDL Commands Are Supported by "mysql"
How Many SQL DDL Commands Are Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are 4 SQL Data Definition Language (DDL) commands that are supported by "mysql". They are listed below with short descriptions: "CREATE dataObjectType dataObjectName" - Creates new database... 2007-05-08, 5036👍, 0💬

What Is the Command Line End User Interface - mysql
What Is the Command Line End User Interface - mysql? - MySQL FAQs - Command-Line End User Interface mysql "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It i... 2007-05-10, 5033👍, 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.