Oracle ODBC:SQL_HANDLE_ENV上的驱动程序的SQLAllocHandle失败 [英] Oracle ODBC : Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

问题描述

我收到消息Oracle ODBC:SQL_HANDLE_ENV上的驱动程序的SQLAllocHandle失败 尝试在excel中打开oracle连接时. 我正在通过citrix在虚拟机中工作. 您能否提供提示为什么它出现以及如何避免出现问题?

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 ?

推荐答案

在安装Oracle 9i和10G时，该问题似乎是权限问题.

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

如果浏览Oracle主目录，则会发现该目录具有与树的根不同的权限.对于10G，路径为C:Oracleproduct10.1.0Client_1.打开Client_X目录的属性，您将看到经过身份验证的用户"应具有读取和执行"，列出文件夹内容"和读取".要解决此问题，请执行以下操作. -选择经过身份验证的用户 -取消选中读取并执行 -按应用 -检查读取并执行 -按应用"

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

这篇关于Oracle ODBC:SQL_HANDLE_ENV上的驱动程序的SQLAllocHandle失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！