无法从 win 2008 R2 连接到 oracle
我无法从 Windows 2008 R2 连接到 Oracle（从 Visual Studio 连接）
我已经安装了 Oracle 客户端 x64，但仍然无法连接
“未找到 Oracle 客户端和网络组件。这些组件由 Oracle Corporation 提供，是 Oracle 版本 7.3.3 或更高版本客户端软件安装的一部分”
我也尝试通过 ODBC 连接，但我无法
提供任何想法
i can't connect to oracle from windows 2008 R2 (connect from visual studio)
i have installed oracle client x64 , but still can't connect
“Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation”
also i tried to connect trough ODBC but i couldn't
any ideas please
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
你的问题提出了几个问题。您收到的错误消息是什么？你的环境变量中是否包含ORACLE_HOME？
对于 Oracle 工具，定义一些环境变量非常重要。最重要的是 ORACLE_HOME，应该指向安装 Oracle 客户端软件的目录（您应该有 ORACLE_HOME\bin ORACLE_HOME\lib 等。接下来，您应该将 ORACLE_HOME\bin 包含在您的 PATH 中。我不知道关于 Visual Studio，但这就是它通常应该如何工作的方式。客户端安装的字长可能与 RDBMS 安装的字长不同，但必须适合您的应用程序。
我希望这有帮助。
Your question raises a few questions. What is the error message you get? Does your environment variables contain ORACLE_HOME?
For Oracle tools it is important to have some environment variables defined. Most important are ORACLE_HOME, should point to the directory where your Oracle client software is installed (you should have something like ORACLE_HOME\bin ORACLE_HOME\lib etc. Next, you should have the ORACLE_HOME\bin included in your PATH. I don't know about visual studio but this is how it normally should work. The wordsize of the client installation can be different than that of the rdbms installation but has to fit your application.
I hope this helps.
这不是什么大问题。您可能需要使用 Oracle 数据提供程序重新编译代码。
“适用于 Oracle 的 Microsoft OLEDB 提供程序和适用于 Oracle 的 Microsoft ODBC 驱动程序
如果您使用 Oracle 数据源，则应迁移到 Oracle 提供的提供程序和驱动程序。 Microsoft OLEDB Provider for Oracle (msdaora.dll) 和 Microsoft ODBC driver for Oracle (msorcl32.dll) 是使用 Oracle Call Interface (OCI) 版本 7 构建的。Oracle 不再支持使用 OCI 版本 7 调用的应用程序，并且这些技术已弃用。 " --Microsoft
http://social .msdn.microsoft.com/Forums/en/sqldataaccess/thread/96048ef5-ef9e-4b1c-b8a3-5d7b91d55adb
https://connect.microsoft.com/SQLServer/feedback/details/267677/x64-version-of-msdaora-driver-please
Oracle ODAC
http://www.oracle.com/technetwork/developer -tools/visual-studio/downloads/index.html
This isn't a pretty problem. You will likely need to recompile your code with the Oracle data provider instead.
"Microsoft OLEDB Provider for Oracle and Microsoft ODBC driver for Oracle
If you are using Oracle data sources, you should migrate to the Oracle-supplied provider and driver. Microsoft OLEDB Provider for Oracle (msdaora.dll) and Microsoft ODBC driver for Oracle (msorcl32.dll) are built by using Oracle Call Interface (OCI) version 7. Oracle no longer supports applications that use OCI version 7 calls, and these technologies are deprecated. " --Microsoft
http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/96048ef5-ef9e-4b1c-b8a3-5d7b91d55adb
https://connect.microsoft.com/SQLServer/feedback/details/267677/x64-version-of-msdaora-driver-please
Oracle ODAC
http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html