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, 3314👍, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...