Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How do I get the Oracle 12c Visual Studio Tools to work?

user10703969Feb 15 2016 — edited Apr 12 2016

I work on Oracle about once every 5 years, so forgive any dumb questions or phrasing here...

I'm a programmer working in a new Windows 10 box with Visual Studio 2013.

So I installed Oracle 12c and it is up and running.  Except that the old Enterprise Manager doesn't seem to be there.  That was the web app that you did something like      localhost:5501/em   as the address in the browser.

So then I saw there were VS tools which I'm pretty sure I used to use, so I downloaded and installed that.

I was able to make a connection in the Server Explorer.  And I could expand the nodes of the tree.  But anything that I right click on and try to execute does nothing.

I presume that is related to the message I get that says:

"Oracle Data Provider for .Net has been installed without a machine-wide configuration. However, a version of Oracle Data Provider for .Net has been detected in the Global Assembly Cache which may be incompatible.  Please remove Oracle Data Provider for .Net from the Global Assembly Cache and restart Visual Studio."

It would have been better if it had had a button that said, "Click here to remove from cache the stuff that I don't want in the cache."   Been years since I looked in the cache.  I looked.  Of course, no idea what in there is to be removed.  Of course there are 3 folders there GAC32, GAC64, and GAC_MSIL  Don't know which one or more than one it is looking at and complaining.  My machine is 64 bit, so I guessed the 64 one.  Of course in there are a bunch of Oracle folders.  Don't know which one it might be that I need to delete something I don't know from.

I deleted the first folder I saw.  Apparently that was it because even after restarting VS, it was still complaining.  And I don't know if what I deleted was important for something else, nor if I should have just deleted SOME of what was there.

I also don't know if I should have deleted something in the 32 because maybe VS is 32 bit.

Anybody know what I should have done?  I DON'T want it to use the GAC because I know I need to distribute what I test with and, as I recall, having in the GAC was a problem.

Thanks for any help.

Comments

Ajay Shankar

I was getting exactly same error on my current environment and after installing "32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio" the issue went off.

My current environment: Windows 7 Enterprise

My IDE: Visual Studio 2013 Ultimate

What Caused Issue: Installed "Oracle Developer Tools for Visual Studio 2013" from Link#1

Link#1: Oracle Developer Tools for Visual Studio 2013 download page

Error: Oracle Data Provider for .Net has been installed without a machine-wide configuration. However, a version of Oracle Data Provider for .Net has been detected in the Global Assembly Cache which may be incompatible. Please remove Oracle Data Provider for .Net from the Global Assembly Cache and restart Visual Studio.

Resolution: Ideally I should have removed the above installed component (Link#1) and then install from link#2 but I kept the previous one and went ahead with Link#2.

Link#2: Oracle Data Access Components (ODAC) for Windows Downloads

Working Screenshot:

ODP_Issue.png

user12083568

Was a solution found for this ?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 10 2016
Added on Feb 15 2016
2 comments
10,937 views