Aug 07, 2014 08:04 PM|Lannie|LINK
Yes Good database. I use that too.
Let's back up and do clean install.
Uninstall Oracle client(s) on the application server.
Go to registry HKEY Local Machine > Software and remove the Oracle Key
Find your Oracle home and make sure it is an empty directory
Reboot and install this driver and Client. When you run the installer, use the CLIENT INSTALLATION option.
64-bit ODAC 11.2 Release 5 (184.108.40.206.20) for Windows x64
ODAC1120320_x64.zip - 225 MB (230,297,429 bytes)
make sure you can execute a test query from SQL PLUS prompt to ensure good connection to database
(no firewall issues blocking Oracle listening port, tnsnames.ora properly configured, etc.)
Then follow my previous steps to obtain the exact same oracledataaccess.dll used by your client install
with LOCALreference made to it in the /BIN directory of APP.
And make sure your application is explicitly compiled at x64 and not ANY or x86.