托管 ODP.NET 驱动程序未显示在数据源对话框中 [英] Managed ODP.NET driver does not show up in Data Source dialog

问题描述

在我的计算机上安装了托管 ODP.NET 后，ODP.NET 托管驱动程序不会出现在 Visual Studio 2013 Professional 的选择数据源对话框中.>

它应该是这样的:

这是它在我的机器上的实际外观:

我已按照轻松驱动 .NET" Oracle 网站上的文章.

我还安装了 Oracle Developer Tools for Visual Studio.仍然没有可供选择的托管驱动程序.

我的问题:

为了让数据提供者出现，我忘记做什么了吗?

解决方案

打开注册表编辑器并检查 RegKey HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoft.NETFrameworkv4.0.30319AssemblyFoldersExodp.net.managed 存在.它仅包含(默认)值以及您的 Oracle.ManagedDataAccess.dll 的位置.

添加密钥以防丢失，例如:

Windows 注册表编辑器 5.00 版[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoft.NETFrameworkv4.0.30319AssemblyFoldersExodp.net.managed]@="c:\oracle\product\12.1\odp.net\managed\common"

您也可以在 {ORACLE HOME}odp.netmanagedx64configure.bat 和 {ORACLE HOME}odp.netmanaged 尝试 Oracle 配置脚本x86configure.bat，他们也应该这样做

然后检查您的编译选项是否至少选择了.NET Framework 4的目标框架.

12.2 版更新

Key odp.net.managed 似乎在旧版本 12.1 中使用.最新版本使用 Oracle.ManagedDataAccess:

Windows 注册表编辑器 5.00 版[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoft.NETFrameworkv4.0.30319AssemblyFoldersExOracle.ManagedDataAccess]@="C:\oracle\product\12.2\Client_x64\odp.net\managed\common"[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoft.NETFrameworkv4.0.30319AssemblyFoldersExOracle.ManagedDataAccess.EntityFramework6]@="C:\oracle\product\12.2\Client_x64\odp.net\managed\common\EF6"

Having installed managed ODP.NET on my computer, the ODP.NET Managed Driver does not appear inside the Choose Data Source dialog in Visual Studio 2013 Professional.

This is how it should look like:

This is how it actually looks on my machine:

I've followed the steps described in the "An Easy Drive to .NET" article on the Oracle website.

I've also installed the Oracle Developer Tools for Visual Studio. Still no managed driver to select.

My question:

Is there anything I forgot to do in order to make the data provider appear?

解决方案

Open your Registry editor and check if RegKey HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoft.NETFrameworkv4.0.30319AssemblyFoldersExodp.net.managed exists. It contains only the (Default) value with location of your Oracle.ManagedDataAccess.dll.

Add the key in case it is missing, example:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoft.NETFrameworkv4.0.30319AssemblyFoldersExodp.net.managed]
@="c:\oracle\product\12.1\odp.net\managed\common"

You can also try the Oracle config scripts at {ORACLE HOME}odp.netmanagedx64configure.bat and {ORACLE HOME}odp.netmanagedx86configure.bat, they should do the same

Then check your compile options whether you selected target Framework at least to .NET Framework 4.

Update for Release 12.2

Key odp.net.managed seems to be used in old version 12.1. Latest release uses Oracle.ManagedDataAccess:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoft.NETFrameworkv4.0.30319AssemblyFoldersExOracle.ManagedDataAccess]
@="C:\oracle\product\12.2\Client_x64\odp.net\managed\common"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoft.NETFrameworkv4.0.30319AssemblyFoldersExOracle.ManagedDataAccess.EntityFramework6]
@="C:\oracle\product\12.2\Client_x64\odp.net\managed\common\EF6"

这篇关于托管 ODP.NET 驱动程序未显示在数据源对话框中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！