ASP使用ADO连接ORACLE数据库失败解决方法

错误现象

-----------connectionstring:  
  Provider=OraOLEDB.Oracle;   Data   Source=ORACLE;   User   Id=sinodigital;Password=aaaaa;  
  ------------err.description:  
  Provider   cannot   be   found.   It   may   not   be   properly   installed.  
  -----------connectionstring:  
  Provider=MSDAORA.1;Password=aaaaa;User   ID=sinodigital;Data   Source=oracle;Persist   Security   Info=True  
  ------------err.description:  
  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.  
   
  -----------connectionstring:  
  DSN=dl;UID=sinodigital;PWD=aaaaa;SERVER=oracle;  
  ------------err.description:  
  [Microsoft][ODBC   Driver   Manager]   Driver's   SQLAllocHandle   on   SQL_HANDLE_ENV   failed

 

原因：oracle安装目录文件夹的authenticated users用户权限不足，导致asp文件创建数据库连接时，系统无法访问oracle目录

解决方案：以oracle9.2为例

1、在web服务器的oracle安装目录下，右键选择ora92文件夹的属性

2、在“安全”页下将authenticated   user的“读取及运行”的允许取消选中（时间比较长），点击确定

3、再次打开属性页面，将“安全”页下将authenticated   user的“读取及运行”的允许选中，点击确定，即可

如果没有“安全”页，将菜单“工具”->查看下的“使用简单文件共享（推荐）”取消选中，确定即可。

转载于:https://www.cnblogs.com/lauer0246/archive/2010/04/12/1710166.html