When creating a connection with Spotlight, it throws the "Cannot find OCI DLL" error but the error window shows the wrong ORACLE_HOME path.
For example, the ORACLE_HOME path maybe "C:\oracle11g\product\11.2.0\client_1" but the error shows:
"Cannot find OCI DLL: C:\Oracle11g\product\11.2.0\client_2\BIN\*.*"
1. Go to Windows Start | REGEDIT
2. Go to HKEY_CURRENT_USER\Software\Classes\VirtualStore\MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_<Your_Oracle_Client>
(e.g. HKEY_CURRENT_USER\Software\Classes\VirtualStore\MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraClient11g_home1)
3. Look for the ORACLE_HOME value and change it to the correct path to the actual ORACLE_HOME
