Solved

Cannot import System.Data.OracleClient

Posted on 2013-01-23
4
341 Views
Last Modified: 2014-02-07
I just got a new development laptop.  Trying to work through the normal pain of reinstalling everything for Visual Studio 2005 but this is stumping me:  Getting "Doesn't contain any public member or cannot be found" for Imports System.Data.oracleclient. Intellisense doesn't even show OracleClient.

I have the Oracle Client 10g software installed and can see the System.Data.OracleClient.dll in C:\WINNT\Microsoft.NET\Framework\v2.0.50727.  I have added a Reference to the project for System.Data.OracleClient V2.0 and can see it listed in the references section. I can connect to a database in the Net Manager app of oracle and also connected and updated the database using Toad for Oracle so the Oracle install seems solid.  Please help.
Screen-of-references.docx
0
Comment
Question by:bozworthy
  • 2
4 Comments
 
LVL 1

Author Comment

by:bozworthy
ID: 38812926
I should add that this same project worked on my old laptop.  I'm attempting to open the same folder on the new machine. Also, System.Data.OracleClient is importing successfully in ASP pages.  It is a VB module in the App_code folder that is having the problem.
0
 
LVL 74

Expert Comment

by:käµfm³d 👽
ID: 38812930
Did you install ODAC?
0
 
LVL 1

Author Comment

by:bozworthy
ID: 38812955
No I don't think so. I don't believe it's been required in the past. Can you address why the namespace loads in ASP pages but not the VB module in the App_Code section?
0
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 38816222
Visual Studio is quite old as far as systems have been evolving. I suspect that the version of the OracleClient.dll installed on your new laptop might be to high for Visual Studio 2005, while ASP is able to use it.

Also, you do not see it in that version of Visual Studio, but if you were on VS2010 or VS2012, when trying to use OracleClient you would get a warning that it is Obsolete and won't be supported in future versions. You are advised to use the ODP available on the Oracle site instead.

I suggest that you move up to Visual Studio 2012. If you are working as a full time programmer, you might prefer the Professional edition, but the Express edition is free and does almost as much as the Pro edition of VS2005 did. The newer edition would
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

760 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

21 Experts available now in Live!

Get 1:1 Help Now