This content has been marked as final. Show 2 replies
Thanks a lot for the response, I got it working with adding database detail in tnsnames.ora file, below are the steps, may be helpful for other users
I was able to do it, Steps for installation.
- Download Oracle Client GUI version from Oracle website
- Download ODAC from Oracle website
- Install using setup.exe with all general properties
- Open Net Manager and add tsn
- Restart the server and it should start showing up under providers 'Oracle for OLE DB'
- Make Connection and it should work