I've had a nasty little problem today and thought it was worth sharing.
I've been trying to use the Microsoft OLE DB Provider for Oracle to connect to some Oracle databases but it was failing with the error:
"Test connection failed because of an error in initiialising provider. oracle error occurred, but error message could not be retrieved from Oracle".
I was able to connect to Oracle instances just fine from normal Oracle client tools but not when using the Microsoft OLE DB Provider for Oracle - so my natural assumption was that there was a problem with my Microsoft Data Access Components (MDAC) install. I downloaded Component Checker to check out my MDAC install but it reported no problems at all - everything was as it should be.
That's when I stumbled upon this blog post: http://mobeen.spaces.live.com/blog/cns!C7EE59ADAEED6598!153.entry. Here the guy states that the problem isn't in MDAC but its in the Oracle client install which can have an incorrect setting in registry key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOME.
I checked out my registry and sure enough I had the same problem. I made the change, attempted connection again and everything worked. Problem solved!! Praise the lord!
Anyone wanna complain to Larry for me? :)
-Jamie