Hi, newbie here...
I have installed the ODP via ODAC.
I can successfully connect to Oracle db from WebMatrix if I add the connection information manually. But I am unable to do so from Visual Studio. The oracle.data.provider does not appear as a data provider choice in my Add Connection wizard from Visual Studio.
I have multiple Oracle homes, could it be that Visual Studio is not pointed at the correct Oracle client/home??
Thanks in advance for any help offered.
I don't believe WebMatrix supports Visual Studio DDEX, which is the kit that makes Visual Studio extensibility possible and what Oracle uses to expose its tooling. That's more likely the issue. In the past, MS has not made DDEX available in its free IDE products. However, if the only DB-related tooling is the Add Connection wizard, then perhaps some WebMatrix-specific integration is what is necessary. Let me look into this.
Hi Alex, thanks....
I am able to connect with WebMatrix....
My problem is with Visual Studio 2010. I have followed it's instructions for an Oracle connection, so, I'm sure it is supported by the IDE. It seems as though it cannot find the oracle provider.
Sorry, misread your email then.
For VS 2010, did you also install Oracle Developer Tools for Visual Studio 2010? That is required for all the tooling that comes with using ODP.NET in VS.
The Oracle tools are bundled with the ODAC, which is the install you likely got ODP.NET. The standard Oracle Client doesn't have the tools, only ODAC installs do.
Edited by: Alex Keh - Oracle Product Manager on May 1, 2012 10:20 AM
I do not see "Oracle Developer Tools for Visual Studio 2010" in my list of Installed Products from the universal installer. Nor do I see an option from the UI to install it.
I do see "Oracle Data Access Components Documentation for Visual Studio 188.8.131.52.0".
Perhaps this is my issue?
I am running Visual Studio Express?
From the Oracle docs: "Note: Visual Studio Express Editions are not supported with the Oracle Developer Tools. However, ODP.NET is supported with Visual Studio Express Edition"
What does that mean, that "ODP.NET is supported? but the Developer tools is not?
Yes, that is the issue. I know for sure that VS Express doesn't support DDEX, which means no Oracle tools (or any other tools) are supported besides what MS provides by default. VS Express is a free product and certainly MS wants you to use a paid product if you're doing any major DB development. Since Oracle gives away its tools for free, Oracle would be fine supporting VS Express if MS ever enabled DDEX there.
ODP.NET is an ADO.NET provider, which means ODP.NET is an API, not a GUI tool. It's unaffected by whatever IDE you are using. The Oracle tools are a GUI tool specifically integrated with Visual Studio. It requires that DDEX be present so that Oracle tooling can integrate with the IDE.
If you're interested in WebMatrix extensibility with Oracle, MS has told me you can add your WebMatrix feature requests here:
One of the things they are considering is an extensibility model, which is what Oracle would need before it could consider supporting WebMatrix.