Oracle ODBC : Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Question

I have message Oracle ODBC : Driver's SQLAllocHandle on SQL_HANDLE_ENV failed when try to open oracle connection in excel. I'm working in virtual machine via citrix. Could you please give tips why it is appear and how avoid problem ?

Solution

The problem appears to be a permission issue during the installation of both Oracle 9i and 10G.

If you navigate Oracle home you will find that the directory has different permissions then the root of the tree. In the case of 10G the path is C:Oracleproduct10.1.0Client_1. Open the properties for the Client_X directory, and you will see that "Authenticated Users" should have Read and Execute, List Folder Contents, and Read. To fix the problem, do the following.... -Select Authenticated Users -Uncheck Read and Execute -Press Apply -Check Read and Execute -Press Apply