[n] System.Data.OracleClient not visible in VS.NET Framework 1.1

[niravpatel]

Hi,
VS.NET 2k3 provides OralceClient for Data Access and it's inbuilt in .NET Framework 1.1.
Though, I'm not able to see in VS.NET intellisense!
I can rerefrence thoruh explicite reference adding but, not without it?
Is there any procedure for making it available without explicite referencing?
It's also there in Global Assembly Cache...

Is there any conflict among .NET Framework version, VS.NET version and Provider dll version?

Any idea?

Thanks.
Nirav


Nirav Patel
#include<NoOneLivesForever>

 

[ca8msm]

If you have the Oracle Client installed on your machine it should be added to VS for you. Make sure you have it installed correctly (try to re-install it if you are not sure).

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[niravpatel]

Hi ca8mam,
It's not the oracle client that is needed, we need a driver and that comes with .NET framework or VS.NET or one can donwload from Microsoft.

I forgot to add the reference!

Now, it's coming in VS.NET. one problem is solved but second has come up
The sample app from MSDN for oracle oledb is giving error with driver saying "... need client with version >= 8.1.x..."

any idea on that?

Thanks.
Nirav

Nirav Patel
#include<NoOneLivesForever>

 

[ca8msm]

It is the client that you need as this contains the correct driver (which I don't think ships with the .NET Framework or VS.NET as you stated).

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[chrissie1]

sorry ca8msm but you are only partly correct in VS2003 the oracleclient is in the framework. You just need to add it to your toolbox (right click...). But you still need to install the client tools from oracle wich are not in the framework because you will use the ora.net configuration to make the connection and yes you need to install these tools on every computer you want to use your program on. You could make an install that does this for you but I haven't done that yet, beccause I use SQL-server and a linked server to oracle. So no they didn't make it easy.

BTW the linked server is a lot slower then the vb.net oracleclient but who cares.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[chiph]

Chrissie1 is correct - the managed provider that comes with the 1.1 framework doesn't include the Oracle oci network layer -- you need to install the Oracle Client software to get that.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[chrissie1]

Why does everybody always want to say I'm correct???

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[chiph]

I dunno. Because you usually are?
;-) ;-)

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[ca8msm]

Thanks for the correction chrissie

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.