Solved

ODP.NET data provider not available in VS 2012

Posted on 2014-02-10
14
2,866 Views
Last Modified: 2014-02-15
I have installed Oracle Developer Tools for Visual Studio 12.1.0.1.2 for VS 2012.
I am able to use the dlls for my project.

My problem is when i try to connect to the database i do not see the ability to use the ODP.NET data provider.  Only the deprocated Oracle data providers show...

The ODT has been reinstalled and so has the VS IDE.

I have attached a pic...

thanks
0
Comment
Question by:gdinunzio
  • 7
  • 6
14 Comments
 
LVL 12

Expert Comment

by:praveencpk
Comment Utility
>>I have installed Oracle Developer Tools for Visual Studio 12.1.0.1.2 for VS 2012.<<

Can you help us with the version of oracle developer tool which you installed and also let us know the database version you are using.

also go through the installation doc for proper installation.

http://www.oracle.com/technetwork/topics/dotnet/downloads/install121012-2088160.html

http://www.oracle.com/technetwork/topics/dotnet/downloads/install112021-200037.html
0
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
I would go with the fully-managed Oracle driver, which is available through a NuGet package.

Oracle Data Provider for .NET (ODP.NET) Managed Driver 121.1.1
http://www.nuget.org/packages/odp.net.managed/

You don't need to install a client, and there is only a single file dependency for the assembly reference (Oracle.ManagedDataAccess.dll).
0
 

Author Comment

by:gdinunzio
Comment Utility
Oracle Developer Tool is 12.1.0.1.2
Database is Oracle 12c

The installation seems to have gone without error as the code I wrote that references these oracle DLLs works fine.  

I cannot choose either of the new ODP.NET data providers from the "Oracle Database" data source, thereby not be able to use the developer tools in VS.

How will using the managed driver fix this problem?
0
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
If you are trying to use Oracle as a data source, the managed driver won't help you.  The installation for the managed driver is much easier, but the driver has missing functionality--missing UDTs.

What version of Visual Studio 2012 do you have?
0
 

Author Comment

by:gdinunzio
Comment Utility
Premium version.
0
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
Is this installed on a 32-bit or 64-bit operating system?  Does the bitness match the installed driver?
0
 

Author Comment

by:gdinunzio
Comment Utility
Oracle Developer Tools for Visual Studio is 32bit.  It is installed on a W7Pro 64 bit PC.  
I have this combination working on another PC.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
Are both machines running the same Update version (1, 2, 3, or 4)?
0
 

Author Comment

by:gdinunzio
Comment Utility
yes same update for VS 2012
0
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
Is there only one Oracle client installed on the non-working machine?
0
 

Author Comment

by:gdinunzio
Comment Utility
Yes...i only have 12.1 home installed
0
 
LVL 96

Expert Comment

by:Bob Learned
Comment Utility
I have Oracle 11, and the OLE DB driver is registered with COM, and here are the settings in the Windows registry:

Registry key = HKEY_CLASSES_ROOT\OraOLEDB.Oracle
PROGID = OracleOLEDB.Oracle


HKEY_CLASSES_ROOT\CLSID\{3F63C36E-51A3-11D2-BB7D-00C04FA30080}

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{3F63C36E-51A3-11D2-BB7D-00C04FA30080}

CLSID = 3F63C36E-51A3-11D2-BB7D-00C04FA30080
InprocServer32 = C:\Oracle\product\11.2.0\client_2\bin\OraOLEDB11.DLL

This might be an issue with how the OLE DB driver is registered with COM.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
Comment Utility
I am installing the same version 12c release 2 client from here on my Visual Studio 2013, and I will see if it works for me.

ODAC 12c Release 2 and Oracle Developer Tools for Visual Studio (12.1.0.1.2)
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
0
 

Author Closing Comment

by:gdinunzio
Comment Utility
The registry settings are the same.

I was getting more errors with VS.  When it could not find the "common" folder and editing the PATH in environmental variables, I decided to start fresh.  I had some time and did a full reinstall of the OS W7p, then VS 2012, and then ODAC 12cR2...this seems to have done the trick.  I even checked the ODT in VS after loading service pack 4 for VS and it still works.

The only thing I saw in the ODT readme from Oracle was make sure that ODT was only installed in ONE home.  I have to think that when I was using 2 homes (12.1 & 11.2) I must tried both at some point (even though there was no residual evidence after the 11.2 uninstall)

This "atomic bomb" approach isn't exactly the solution I was hoping for, considering the time it take for a reinstall, but it does give me a fresh start.

I am giving you full point for the effort.

Thanks
GL
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
levels for reporting 5 48
sql query 5 51
C# DataGridView_RowsAdded event not firing 1 36
Spacing between controls 4 15
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now