How to install OraOLEDB12.dll 64 bit / OraOLEDB11.dll 32 bit ? or How to solve "OraOLEDB.Oracle Provider is not registered" error?


32 Bit
-------
1. login into cmd prompt (using Run as Administrator option) and run the below command

cd C:\ORACLE\cli11gR2_32\bin

C:\ORACLE\cli11gR2_32\bin> c:\Windows\system32\regsvr32.exe OraOLEDB11.dll

Note:
Ensure the path variable was set and referring the location "C:\ORACLE\cli11gR2_32\bin"



64 Bit
--------

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

 

1. Download  "ODAC112040Xcopy_64bit"
2. Unzip it
3.login into cmd prompt (using Run as Administrator option) and run the below command

cd C:\Users\Downloads\ODAC112040Xcopy_64bit

C:\Users\Downloads\ODAC112040Xcopy_64bit>dir
 Volume in drive C is System Volume
 Volume Serial Number is DC2F-3B02

 Directory of C:\Users\Downloads\ODAC112040Xcopy_64bit

04/11/2017  05:10 PM    <DIR>          .
04/11/2017  05:10 PM    <DIR>          ..
01/06/2014  03:55 PM    <DIR>          asp.net
01/06/2014  03:56 PM    <DIR>          asp.net4
10/23/2013  04:36 PM            26,323 configure.bat
10/23/2013  04:21 PM            11,538 install.bat
01/06/2014  04:00 PM    <DIR>          instantclient_11_2
01/06/2014  03:46 PM    <DIR>          network
01/06/2014  03:57 PM    <DIR>          odp.net20
01/06/2014  03:58 PM    <DIR>          odp.net4
01/06/2014  03:59 PM    <DIR>          oledb
01/06/2014  03:59 PM    <DIR>          oramts
01/06/2014  03:42 PM             8,766 readme.htm
01/03/2014  03:10 PM            14,042 unconfigure.bat
01/06/2014  04:00 PM            20,676 uninstall.bat
               5 File(s)         81,345 bytes
              10 Dir(s)  282,921,463,808 bytes free

C:\Users\Downloads\ODAC112040Xcopy_64bit>INSTALL ALL “C:\Oracle\Oracle64Driver” Oracle64Driver TRUE

4. copy the content of instantclient folder into to bin folder