Installing Oracle ODBC Driver to Windows 2012 Server R2

Step1:   Download 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio



After installing the above software create a envirnoment variable called TNS_ADMIN


Variable Name :TNS_ADMIN

Variable Value : C:\oracle\product\10.2.0\client_2\network\admin  (Make sure path is correct. If your machine is connected to Domain path may differ)

Step3: Open C:\Windows\SysWOW64\odbcad32.exe


USER DSN –> Add –> Oracle in Ora Clientxxx


If you cannot see the TNS service name in drop down means you have not done previous step.

You can also check the proper settings by pressing Test Connection and providing the Credentials.