Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
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
✍: FYIcenter.com
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, 5148👍, 0💬
Popular Posts:
What is a measure in OLAP ? Measures are the key performance indicator that you want to evaluate. To...
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you...
How many types of validation controls are provided by ASP.NET ? There are six main types of validati...
How Many Types of Tables Supported by Oracle? - Oracle DBA FAQ - Managing Oracle Database Tables Ora...
What is the method to customize columns in DataGrid? Use the template column.