Collections:
Connect ASP Pages to Oracle Servers in Oracle
How To Connect ASP Pages to Oracle Servers in Oracle?
✍: 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 %>
2016-10-15, 707👍, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe i...