Tuesday, October 05, 2004

System.Data.OracleClient not working

This is third time that this question has come up and perhaps it is good to have solution up there at the blog...
Please read down to up...
hi vishal,
Thank you very much for your help. I downloded that dll and it worked by adding reference.
I also found 1 more solution. Similar to microsoft, oracle provides driver as well which is downloadable frm its site. Its abt 80 MB.
veeral Oza
From: Vishal Joshi [mailto:Vishal_Joshi@MVPs.org]
Sent: Wednesday, October 06, 2004 7:28 AM
To: Veeral Oza; gangadhara.deepadiah@morganstanley.com; 'Sarang Datye'; sdatye@yahoo.com; scripthappens@hotmail.com
Subject: RE:
Please go manually and add reference to Program Files\Microsoft.NET\OracleClient.Net\System.Data.OracleClient.dll it should work then... If you do not have the same dll on your machine then go to the below location to download and install it on your machine...
warm regards,
Vishal Joshi
Microsoft MVP .Net
If You Think YOU CAN... You Can...
From: Veeral Oza [mailto:VeeralO@KPITCummins.com]
Sent: Tuesday, October 05, 2004 7:34 AM
To: gangadhara.deepadiah@morganstanley.com; Sarang Datye; sdatye@yahoo.com; vishal_joshi@mvps.org; scripthappens@hotmail.com
To connect to a oracle 9i database, we have to start with this syntax
Imports System.Data.OracleClient(for VB.Net)
I do hav dotnet framework 1.1 running on my PC, but it still gives me an error
"Namespace or type 'oracleclient' for the Imports
'System.Data.oracleclient' cannot be found."
The connectivity works fine with SQL server.
What might be the reason that I m getting this error?
Veeral Oza
Systems Executive


Santron said...
This comment has been removed by the author.
Santron said...

I have all namespaces in c:\windows\assembly but it is not importable at .net 2005. Please help.

Vishal R Joshi said...

Can you please clarify what you mean by not importable... Are you still having issues with this...

Santron said...

If i give imports statement, it is not visible in IDE. Whereas other namespaces are visible.

Vishal R Joshi said...

Did you add reference to the file explicitly...? It will start showing after you add a reference... Import statement will just pull in the reference into the class...

Santron said...

Thanks it works.
Is there any way to permanently add all the namespaces in assembly folder to add to the IDE.

Vishal R Joshi said...

Well as IDE supports least common denominator and as orcale is not used by everyone hence we do not permanently add the reference... It is certainly possible, I will check with a few experts and ask them to comment...

Vishal R Joshi said...

I discussed with Bill Hiebert who is an expert in this area and below are his comments:
"They could:
1) hand modify the project templates to add this reference.
2) Write and addin that monitors when projects are created and programmatically adds the reference"

Hope this helps...

Santron said...

Thanks a lot for taking risk to help me friend.

xxxx said...

Many many thanks......

Anonymous said...

Right Click solution explorer and select add reference,There select System.Data.OracleClient ,it will add that dll to your project..