今天在测试ASP.NET程序,在连接ORACLE数据库时报出了“Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed”的错误。可我本机上确确实实已经装了Oracle Client,而且在我本机上运行时也正常,一旦通过IIS发布,在运行时就会报上述错误。通过查找网络资料,该问题已经成功解决。现将解决过程发布,供大家参考。
首先,把可能出现该问题的情况简单阐述一下:a:Oracle 9.02i 版的问题b:是NTFS格式分区造成的。Oracle公司对此问题也给出了描述:Problem Description ------------------- When running an application that connects to Oracle and uses the Authenticated User privilege (such as Microsoft’s Internet Information Server (IIS)) via Oracle’s 9.2 client software and any of these programmatic interfaces 1. Oracle Provider for OLE DB 2. Microsoft OLE DB Provider for Oracle 3. Oracle ODBC Driver 4. Microsoft ODBC for Oracle 5. Oracle Objects for OLE (OO4O) you w