Compiler Error Message: CS0234: The type or namespace name 'OracleClient' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

Question

2.50/5 (2 votes)

See more:

I run 'Build' on my project without any error. Then I run Debugging, and got

HTML

Compiler Error Message: CS0234: The type or namespace name 'OracleClient' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

on

C#

using System.Data.OracleClient;

In my project References, System.Data.OracleClient is in the list.
What's wrong here? Thanks.

Posted 12-Mar-14 6:46am

Member 10454592

Add a Solution

Comments

Pranav-BiTwiser 12-Mar-14 12:52pm

using Oracle.DataAccess.Client;

[no name] 12-Mar-14 14:04pm

PB: Used Oracle.DataAccess.Client and revised my code a little bit, the compiling error was gone. Thanks. Please re-post your thread into Solution, so I can credit your recommendation. Thanks again.

Pranav-BiTwiser 18-Mar-14 14:20pm

done..!! n thanks:)
your name?

[no name] 13-Mar-14 15:15pm

PB: Did you read my message yesterday? I want to credit your work and then close this thread. Thanks.

[no name] 12-Mar-14 13:07pm

1) What connection method I should use if using Oracle.DataAccess?
2) Just realized that System.Data.OracleClient.OracleConnection is obsolete, but it is still available?
Thanks.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Mar-14 13:26pm

Have you added reference System.Data.OracleClient.dll?

[no name] 12-Mar-14 13:30pm

Yes. I DID. I also tried to removed it and re-added it again. When I run build, there is no error. But when I run debugging, it shows the Compile error (not runtime error).

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Mar-14 13:33pm

If you don't debug, it works or not?

[no name] 12-Mar-14 13:42pm

Will not work since it pops up the 'Compilation Error'. From http://go.microsoft.com/fwlink/?LinkID=144260, it mentions:
You also must include a reference to the DLL when you compile your code. For example, if you are compiling a C# program, your command line should include:
csc /r:System.Data.OracleClient.dll
I usually compile in VS. Per this comment, should I compile the project not in VS? Thanks.

Pranav-BiTwiser 18-Mar-14 13:28pm

done..!! welcome member10417613...:)
by the way ur name??

3 solutions

Solution 1

You are missing assembly reference. What is unclear? Add reference. Use "Add Reference" node in Solution Explorer. There is a separate assembly "System.Data.OracleClient". See the documentation on any of the Oracle-related classes to see it, for example: http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oraclecommand%28v=vs.110%29.aspx[^].

It looks like you are not yet ready for database development and other advanced topics (UI, network, virtually nothing). First, you need to learn .NET basics. In particular, such things as
http://msdn.microsoft.com/en-us/library/ms973231.aspx[^].

—SA

Posted 12-Mar-14 7:14am

Sergey Alexandrovich Kryukov

Comments

[no name] 12-Mar-14 13:28pm

SA: I did use the same procedure as you mentioned your Solution to Add Reference. This dll has been registered and is located at C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.Data.OracleClient.dll. For the document, I also realized that the System.Data.OracleClient is obsolete. I did NOT miss the assembly reference. As I mentioned, it is appears to be strange somehow that no build error but displayed a compile error when when running debugging.
I wish you understood my question and then made a conclusion. Thanks anyway.

Sergey Alexandrovich Kryukov 12-Mar-14 13:37pm

I am sorry, but this is what I could see from your question that it wasn't references, because you have correct namespace; there is no other way to have this error message. Maybe you added the reference later; I don't know.

Look, I'm really sorry if I made some wrong conclusion, but this is only because you formulated the question the way you did.

Having some obsolete API is a different question; you never mentioned it in first place.

—SA

[no name] 12-Mar-14 13:45pm

SA: Thanks for your comment here. I just got a problem I have never seen. I will try for the solution. Per your post, it alerts me to write clearer statement in my posted thread. I will try to improve it. Thanks again.

[no name] 12-Mar-14 14:05pm

Problem solved by using using Oracle.DataAccess. See my respond to Pranav Bilurkar. Thanks for your review.

Sergey Alexandrovich Kryukov 12-Mar-14 14:35pm

Great. And I really appreciate your understanding and your very constructive approach to responding to some criticism. This is one of the main prerequisites for success.
—SA

Solution 2

Problem solved by adding reference: using Oracle.DataAccess.Client;
The solution was proposed by Pranav Bilurkar in his comment.

Posted 18-Mar-14 7:09am

Member 10454592

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pranav-BiTwiser · Accepted Answer · 2014-03-18T07:26:00

Solution 3

using Oracle.DataAccess.Client;

Posted 18-Mar-14 7:26am

Pranav-BiTwiser