Microsoft KB Archive/176411

{| The information in this article applies to:
 * width="100%"|
 * Microsoft Active Server Pages, versions 1.0, 1.0b
 * Microsoft Visual Studio versions 97

SUMMARY
You can use Microsoft Internet Information Server (IIS) 3.0 to access Oracle through Active Server Pages (ASP) and ODBC. Because of the potential concurrency of database access, a robust set of multi-threading ODBC components are needed for this to behave consistently. This article describes the minimum requirements for connecting to Oracle.

MORE INFORMATION
Oracle's ODBC solution requires several important components: the ODBC driver itself, required support files, and SQL*NET. All of these components must be consistent and up-to-date versions for Active Server Pages to work reliably with Oracle. Following is more specific information about the components.

Oracle Components

 * Upgrade to the Oracle support files to version 7.3.3.5.2. or higher.
 * SQL*NET should be version 2.3.3.0.4 or higher.

Patches are available from Oracle. Please call Oracle directly; you'll need a support contract with Oracle. For information about a software third-party vendor list, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q60781 TITLE    : Hardware and Software Third-Party Vendor List, L-P NOTE: Some products mentioned in this article are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability. NOTE: Beware of multiple copies of Ociw32.dll. This file may be installed by other software vendors in locations other than its default (the Oracle home directory), resulting in redundant copies of the DLL. The thread safe version of this DLL is 1.0.0.5.

IMPORTANT: The Oracle patching/upgrade process normally includes the upgrade of the server, utilities, and the client software. When upgrading Oracle clients (such as IIS machines accessing Oracle data sources), you can safely ignore any warnings that refer to the server or utilities. Ignoring the warnings and continuing with the setup program may be necessary to reach the client software upgrade.

Microsoft Components
The Microsoft ODBC Driver for Oracle (Msorcl32.dll) should be version 2.73.7269 or higher. This can be obtained at http://microsoft.com/data/mdac15.htm.