Can I download/re-install MS built-in Oracle data provider for VisualStudio ?

[Peter Hann]

As far as I know VisualStudio contains a MS built-in data provider for accessing
Oracle databases.

Is this built-in MS data provider only in the "full" VisualStudio Edition or in the Express
edition as well ?

Can I download this built-in MS Data Provider for Oracle databases separately and/or
re-install it somehow again ?

Peter

 

[Christof Nordiek]

As far as I know VisualStudio contains a MS built-in data provider for
accessing
Oracle databases.

Is this built-in MS data provider only in the "full" VisualStudio Edition
or in the Express
edition as well ?

AFAIK, this buildt in DataProvider is part of the framework not if VS.
Maybe, there is some additional designer support for it in VS.

Christof

 

[Hans Kesting]

As far as I know VisualStudio contains a MS built-in data provider for

accessing Oracle databases.

Is this built-in MS data provider only in the "full" VisualStudio
Edition or in the Express edition as well ?

Can I download this built-in MS Data Provider for Oracle databases
separately and/or re-install it somehow again ?

Peter

You need an extra reference in your project to be able to access that namespace
(System.Data.OracleClient.dll)

Hans Kestin

 

[Mr. Arnold]

As far as I know VisualStudio contains a MS built-in data provider for
accessing
Oracle databases.

Yes that would be in the System namespace System.Data.Oracleclient, part of
the .Net Framework.

http://msdn2.microsoft.com/en-us/library/system.data.oracleclient(VS.71).aspx

Is this built-in MS data provider only in the "full" VisualStudio Edition
or in the Express
edition as well ?

It's dll is part of the .NET Framework so it doesn't matter which VS is
using it, you just set reference in you project and use it.

Can I download this built-in MS Data Provider for Oracle databases
separately and/or
re-install it somehow again ?

There is also the Oracle Data provider for .Net, which is another dll with
an Oracle namespace and is not part of the .Net Framework, where you set
reference to the dll in your project and use it.

http://aspalliance.com/560#Page1

 

[cjard]

As far as I know VisualStudio contains a MS built-in data provider for accessing
Oracle databases.

System.Data.Oracle.dll, part of .NET FW< not specifically VS. VS has
some understanding of Oracle SQL, and you can visually design simple
queries and datasets with it. All of the Express editions are knobbled
to be able to connect to Microsoft database technologies only.

Is this built-in MS data provider only in the "full" VisualStudio Edition or in the Express
edition as well ?

System.Data.Oracel.dll is present in the framework itself. As noted,
Express editions cannot use it.

Can I download this built-in MS Data Provider for Oracle databases separately and/or
re-install it somehow again ?

If you are asking in order to get an Express verion of the IDE to talk
to Oracle, then No.


You should also be aware that yes, you get System.Data.Oracle.dll
with .NET but you still have to install the oracle client software to
access a database. Its a bit like Yes, you get a graphics card with
your PC but you still have to install the driver to use it.

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

As far as I know VisualStudio contains a MS built-in data provider for accessing
Oracle databases.

Is this built-in MS data provider only in the "full" VisualStudio Edition or in the Express
edition as well ?

Can I download this built-in MS Data Provider for Oracle databases separately and/or
re-install it somehow again ?

If you have .NET then you have it.

So I guess that is not your problem.

What your problem could be is that the Oracle ADO.NET provider
requires Oracle client software installed on the PC !

Arne

 

[Christof Nordiek]

What your problem could be is that the Oracle ADO.NET provider
requires Oracle client software installed on the PC !

Yes, oracle needs client installation to be accessed, but this surely is
accessible where a Oracle-Server exists.
AFAIK there is no limitation on installing the client components.

But this is also not part of VS. So, no difference of VS and Express here.

Christof

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Yes, oracle needs client installation to be accessed, but this surely is
accessible where a Oracle-Server exists.
AFAIK there is no limitation on installing the client components.

But this is also not part of VS. So, no difference of VS and Express here.

He can install it.

And no differences in VS versions.

But since he is asking, then it is not working.

And it is not the Oracle ADO.NET provider that are missing.

The idea that something else necessary was missing was
rather obvious to me.

Arne