Use Oracle Object for OLE in ASP to access Oracle 8

ASP (Active Server Pages) is one of Microsoft's tools for developing Internet applications. It is similar to HTML (Hypertext
Markup Language (Hypertext Markup Language), Script and CGI (Common Gateway Interface Universal Gateway Interface) combination, but its operation efficiency is
Higher than CGI, easier and more flexible programming than HTML, and better program security and confidentiality than Script. Therefore, ASP is currently in the web development technology
Development tools that are the easiest to learn and the most flexible.
ASP's built-in ADO component is an Internet network database access solution developed by Microsoft and an important contributor to ASP's database access.
In theory, ADO can Access databases supported by ODBC, such as Microsoft SQL Server, Access, Foxpro, Oracle, and Dbase,
However, in practice, we found that ADO can fully support Microsoft SQL Server and Acess. However, it is difficult for Oracle.
Using ADO to access Oracle8, we found that ADO could not access Oracle8's numeric fields, and found that ADO accessed Oracle8 very slowly.
In order to solve the speed and other technical problems of using ASP to access Oracle8, I tried to use Oracle Object for OLE to access Oracle8.
I expected results.
Oracle Object for OLE is an important product developed by Oracle for client database access. It is based on Windows95/98/NT.
All OLE-compatible applications access the Oracle database. It is an OLE Server without a user interface, and its Oracle Objects Server is an ASP
One of the key contributors to accessing the Oracle database.
To access the Oracle8 Database through the Oracle Objects Server, in addition to the basic Web Server and ASP software, you must also ensure that the Web Server has been installed
Oracle Object for OLE software is installed. The required software includes: Network Protocol Adapter, Oracle Object for OLE2.X,
SQL * Net Client2.X, Oracle Net8 Client8.X, SQL * Plus, and Oracle8 ODBC Driver. After confirming that the Web server has installed the above software,
You must also use SQL * Net Client2.X or Oracle Net8 Client8.X to test the Database connection and set the Database Alias (Database Alias ).
Oracle Objects Server provides the following services: clientlient, Orasession, Oraconnection, OraDatabase, OraDynaset, OraSQLstmt,
Nine objects, including OraField, Oraparameter, and Oraparameter Array, are available to developers. Its functions and functions are described as follows:
1. Clientlient object
The specified lient object is used to define the range of the server (Client or Workstation). The specified lient records all Orasession objects on the server.
The specified lient is automatically created by the system as needed.