Error: "The procedure entry point OCIPAnyDataSetFlag could not be located in the dynamic link lib (4326060)

Error received when connecting to Spotlight on Oracle when two or more Oracle Home clients are installed on the computer:

"The procedure entry point OCIPAnyDataSetFlag could not be located in the dynamic link library oraclient9.dll"

User had two Oracle Home clients installed (e.g. 9i and 9.2.x).

All Utilities pointed to the Oracle 9.2.x client except for the Oracle Home Selector.

1. First, verify which Oracle Home is the correct, latest or current Oracle Home client.

2. Ensure ALL SQL*Net sources and utilities are pointing to the correct Oracle Home client.

3. Run the Oracle Home Selector to point it to the correct Oracle Home client.

4. Run Tnsping <sid> and verify which Oracle Home is being used:
e.g.
Used parameter files:
D:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora

5. Open a command prompt and type PATH. Verify the current Oracle Home is listed at the very front of the Path. ---- Use Control Panel | System | Advanced | Environment Variables to edit the PATH if necessary.

6. Registry: Go to Start | Run > type Regedit
In the Registry, go to HKEY_Local_Machine | Software | Oracle | ensure "ORACLE_HOME" value is set to the current Oracle Home.

****WARNING: Using Registry Editor incorrectly can cause serious problems that can damage the operating system and the software installed. Quest cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.****