Failed to connect to database.
Initialization error
Could not locate OCI dll
If you have an Oracle 9.2 and an Oracle 10g client on your PC you may have this problem. The workaround is below:
SQL Optimizer doesn't use right
registry values in
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES - Values to get ORACLE_HOME
SQL Optimizer uses
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOME - Value, which can be different/wrong !
After you change the registry value HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOME from the old Oracle92-Home to the new Oracle 10g Home - Directory SQL Optimizer works correct.
