Where Learning is Pleasure

Jayaram Krishnaswamy

Subscribe to Jayaram Krishnaswamy: eMailAlertsEmail Alerts
Get Jayaram Krishnaswamy: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Related Topics: Oracle Journal, Enterprise Application Performance, Microsoft Developer

Blog Feed Post

Turn off Microsoft Oracle Client and turn on ODP.NET

Excellent support from Oracle to its products has prompted (it appears) Microsoft

Excellent support from Oracle to its products has prompted (it appears) Microsoft to deprecate the System.Data.OracleClient. The developers will of course migrate their applications that use this product.

The comparison listing of ODP.NET and Microsoft Oracle Client shows a lot of no's for Microsoft and lots of yes's for Oracle's ODP.NET. Of course you want to join the "yes" gang.

The ODAC downloads are on this page for specified versions of Visual Studio and Oracle versions here.

For example the ODAC 11g include the following:

a) Oracle Providers for ASP.NET (
b) Orale Data Provider for .NET 2.0 (
c) Oracle Data Provider for .NET 1.x (
d) Oracle Developer Tools for Visual Studio (
e) Oracle Database Extensions for .NET 2.0 ( -- upgrade only
f) Oracle Database Extensions for .NET 1.x ( -- upgrade only
g) Oracle Provider for OLE DB (
h) Oracle Objects for OLE (
i) Oracle ODBC Driver (
j) Oracle Services for Microsoft Transaction Server (
k) Oracle SQL*Plus (
l) Oracle Instant Client (

In order to install the above Visual Studio 2008 and Oracle 11g Servers are needed. While installing make sure that there are no white spaces in the installation folders and sub-directories.

I tried to install with my 10G XE and I got this:

Read the original blog entry...

More Stories By Jayaram Krishnaswamy

Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. 3. "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. 4. "Microsoft Visual Studio LightSwitch Business Application Development [Paperback] "(2011) was published by Packt Publishing Inc. 5. "Learning SQL Server Reporting Services 2012 [Paperback]" (June 2013) was Published by Packt Publishing Inc. Visit his blogs at: http://hodentek.blogspot.com http://hodentekHelp.blogspot.com http://hodnetekMSSS.blogspot.com http://hodnetekMobile.blogspot.com He writes articles on several topics to many sites.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.