一、安装oracel10g client,必要时请使用administrator用户登录系统后再安装
二、找到安装目录下的bin目录,添加ASP.NET相关的用户权限,之后重启IIS,否则会报告:
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.三、因为IIS是64位,此时访问Oracle会报告:
Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.解决办法是在命令行执行以下命令:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1