I have Oracle 11g database which I need to connect in Visual studio 2015 (Enterprise Update 3).
I have install Oracle client 11 on my machine reference to following directories
I believe there are both Oracle Client 32-bit and 64-bit but not sure
When I try to add connection using .NET Framework Data Provider for OLEDB or .NET Framework Data Provider for Oracle , I get following error
On my C:\Window\System32 I have found odbcad32; reference to following screen shot;
I am not what I am missing from picture. need help
Many thanks in advance
I reinstall both Oracle Client 32-bit and 64-bit in following location and it worked;
C:\app\KZ\product\11.2.0\client_32
C:\app\KZ\product\11.2.0\client_64
A simple way to find this out in Windows is to run SQLPlus from your Oracle homes's bin directory and then check Task Manager. If it is a 32-bit version of SQLPlus, you'll see a process on the Processes tab that looks like this:
sqlplus.exe *32
If it is 64-bit, the process will look like this:
sqlplus.exe