0

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

enter image description here

When I try to add connection using .NET Framework Data Provider for OLEDB or .NET Framework Data Provider for Oracle , I get following error

enter image description here

On my C:\Window\System32 I have found odbcad32; reference to following screen shot;

enter image description here

I am not what I am missing from picture. need help

Many thanks in advance

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
K.Z
  • 5,201
  • 25
  • 104
  • 240

1 Answers1

0

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

To check which version of Client Instance is running on local machine

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
K.Z
  • 5,201
  • 25
  • 104
  • 240