INFO: Required Oracle File Versions for Use with ASP

Last reviewed: March 4, 1998
Article ID: Q176411

The information in this article applies to:

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.4.0. or higher.
SQL*NET should be version 2.3.3.0.3 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.

REFERENCES

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

   ARTICLE-ID: Q175018
   TITLE     : HOWTO: Acquire and Install the Microsoft Oracle ODBC Driver
               v2.0

For the latest Knowledge Base artices and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:

   http://support.microsoft.com/support/vinterdev/

Keywords          : kb3rdparty
Technology        : kbInetDev
Version           : WINNT:1.0,1.0b,97
Platform          : winnt
Issue type        : kbinfo

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 4, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.