The following example is an older version of Oracle Client software. The steps are similar for Oracle 9i.
Ensuring that the correct drivers are used and that the appropriate patches from Oracle are installed will help create a stable platform for your application.
This is step-by-step guide on how to successfully set up an Internet Information Server computer for ASP or ADO connectivity to an Oracle Server. It is important to note that the sample setup guide is provided as an example and will not apply to every installation of Oracle client software. For more detailed assistance, please contact Oracle support.
WebAccess has be tested using Oracle 9i.
The recommended software versions for the clients from Microsoft are as follows:
Microsoft Data Access Components 2.5 with Microsoft ODBC for Oracle driver Msorcl32.dll) version 2.573.4403.0 (or later)
-or-
The Microsoft OLEDB Provider for Oracle (msdaora.dll) version 2.50.4403.0 (or later)
The following Oracle software versions (or later) are recommended:
Oracle Server 7.3.3.0.0 7.3.4.0.0 8.0.3.0.0 8.0.4.0.0
------------- --------- --------- --------- ---------
RSF 7.3.3.5.3 7.3.4.2.0 8.0.3.2.3 8.0.4.3.2
SQL*Net 2.3.3.0.5 2.3.4.0.4 N/A N/A
Net8 N/A N/A 8.0.3.0.4 8.0.4.0.3
Oracle updates and patches may be obtained from Oracle Support.
The Microsoft Data Access Components (MDAC) 2.5 installation can be obtained at http://www.microsoft.com/data/mdac2.htm.
NOTE: For optimum results, it is recommended that you perform the following configuration on a fresh installation of Windows 2000, 2003 or XP with Internet Information Server also installed.
Installing the Microsoft Data Access Components 2.5
If you select Custom installation, make sure that you select the following:
ODBC Components
OLE DB Components
ODBC Driver for Oracle Databases
OLE DB Provider for Oracle Databases
Microsoft ActiveX Data Objects
NOTE: The Microsoft Data Access Components 2.5 installation is available at http://www.microsoft.com/data/mdac2.htm.
Installing the Oracle required support files and SQL*Net
Active Server Pages uses ActiveX Data Objects (ADO) to communicate to Oracle through Open Database Connectivity (ODBC). To enable this connectivity, install Oracle's client software on the Web server.
The following is a sample step-by-step setup guide to install the necessary software for client access to an Oracle 7 database. This sample sets up SQL*Net version 2.3.3.0.0 with the required support files version 7.3.3.0.0 on a computer running Windows NT 4.0 Server.
1. From your Oracle software compact disc, run Setup from the root directory.
NOTE: If you are installing Oracle software from a network drive, you must map a network drive to install the Oracle software.
2. Select Language.
3. Select Installation Directory.
You will be prompted that the install directory path information needs to be added to the registry. The Oracle installer will automatically do this for you. At this point, Setup will exit and you will have to restart again. Repeat the above steps.
4. Select Oracle7 Client Products.
5. Select Application User.
6. When you are prompted to install the Oracle documentation either on your hard disk drive or to read it from the compact disc, choose the appropriate location.
7. The Oracle client Setup will now copy the files and configure the client software.
8. To connect to an Oracle database using ODBC, you must supply a valid SQL*Net connect string. SQL Net Easy Configuration allows you to create an alias that you can reference in an ODBC Data Source Name (DSN) to connect to your Oracle Server.
9. Run SQL*Net Easy Configuration. (Click Start, point to Programs, select Oracle for Windows NT, and then choose SQL Net Easy Configuration.)
10. Select Add Database Alias.
11. Type in a name for the alias (for example, the server name).
12. Select the protocol (most commonly, it will be TCP/IP).
13. Specify the host machicomputerne and the database instance. This is the name of the Oracle Server and the database on that server. If you do not know these values, get them from your Oracle Database Administrator (DBA).
14. Confirm the settings.
15. Select Exit SQL*Net Easy Configuration.
16. Creating a System DSN
17. On the Project Node, from the Control Panel use the 32-Bit ODBC Administrator to add a System DSN.
18. Select Microsoft ODBC for Oracle version 2.573.2927.
19. In the Microsoft ODBC for Oracle dialogue, supply the required information. The user name will be provided by your Oracle DBA and the "Server" is the alias created with SQL Net Easy Configuration.
Data Source Name : OracleDSN
Description : Oracle Server Test on Server Name (optional)
User Name : <supplied by your Oracle DBA>
Server : <SQL*Net Easy Configuration Alias>
12. Leave the options set to their default values.