错误现象
-----------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的“读取及运行”的允许选中，点击确定，即可
如果没有“安全”页，将菜单“工具”->查看下的“使用简单文件共享（推荐）”取消选中，确定即可。