By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,102 Members | 1,484 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,102 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Jun 11 '07 #1
Share this Question
Share on Google+
7 Replies


P: n/a
"Peter Hann" <pe*******@hotmail.comschrieb im Newsbeitrag
news:46***********************@newsspool3.arcor-online.net...
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
Jun 11 '07 #2

P: n/a
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 Kesting
Jun 11 '07 #3

P: n/a

"Peter Hann" <pe*******@hotmail.comwrote in message
news:46***********************@newsspool3.arcor-online.net...
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/lib...nt(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

Jun 11 '07 #4

P: n/a
On Jun 11, 11:37 am, peterh...@hotmail.com (Peter Hann) wrote:
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.

Jun 11 '07 #5

P: n/a
Peter Hann wrote:
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
Jun 12 '07 #6

P: n/a
"Arne Vajhøj" <ar**@vajhoej.dkschrieb
>
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
Jun 12 '07 #7

P: n/a
Christof Nordiek wrote:
"Arne Vajhøj" <ar**@vajhoej.dkschrieb
>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.
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
Jun 13 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.