Solved

Cannot import System.Data.OracleClient

Posted on 2013-01-23
4
379 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 75

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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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…

752 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