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 %>
⇐ Connect MS Access to Oracle Servers in Oracle
2016-10-15, 4352🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...