Mr Corn Man (5/20/2015)
Yes, the registry change was on the server. I have access to do that, but not to the tnsnames. Go figure.
It's neat that you got openrowset on Oracle working without going through TNSNAMES. You should submit an article here on sqlservercentral describing how to setup Oracle client connectivity, required server settings, and everything, so those of us who occasionally need to pull data from Oracle can ramp up quickly.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho