Oracle ADO.NET classes ??

5 Feb 2006 7:37 PM

Mark

I'm confused ... I've read in a number of places that in VS2005, ADO.NET
contains Oracle specific classes under the System.Data namespace (actually
this was supposed to be available for the v1.1 framework). But I don't see
the Oracle stuff in the Object Browser.

I see:
System.Data.Common
System.Data.Odbc
System.Data.OleDb
System.Data.Sql
System.Data.SqlClient
System.Data.SqlTypes

(only System.Data.Sql is new relative to the v1.1 framework)

So where is the Oracle stuff ? What am I missing??

Thanks

5 Feb 2006 9:25 PM

Elton W

Hi Mark,

You need add reference by

Website -> Add Reference â€¦
In Add Reference window, select System.Data.OracleClient

HTH

Elton Wang

Show quote

"Mark" wrote:

> I'm confused ... I've read in a number of places that in VS2005, ADO.NET
> contains Oracle specific classes under the System.Data namespace (actually
> this was supposed to be available for the v1.1 framework). But I don't see
> the Oracle stuff in the Object Browser.
>
> I see:
>   System.Data.Common
>   System.Data.Odbc
>   System.Data.OleDb
>   System.Data.Sql
>   System.Data.SqlClient
>   System.Data.SqlTypes
>
> (only System.Data.Sql is new relative to the v1.1 framework)
>
> So where is the Oracle stuff ? What am I missing??
>
> Thanks
>
>
>

6 Feb 2006 2:26 AM

Mark

Thanks Elton ... I guess that's a big "Duh!" :-)

Show quote

"Elton W" <Elt***@discussions.microsoft.com> wrote in message
news:64705012-67BE-4835-961E-15E784261BB1@microsoft.com...
> Hi Mark,
>
> You need add reference by
>
> Website -> Add Reference .
> In Add Reference window, select System.Data.OracleClient
>
> HTH
>
> Elton Wang
>
> "Mark" wrote:
>
>> I'm confused ... I've read in a number of places that in VS2005, ADO.NET
>> contains Oracle specific classes under the System.Data namespace
>> (actually
>> this was supposed to be available for the v1.1 framework). But I don't
>> see
>> the Oracle stuff in the Object Browser.
>>
>> I see:
>>   System.Data.Common
>>   System.Data.Odbc
>>   System.Data.OleDb
>>   System.Data.Sql
>>   System.Data.SqlClient
>>   System.Data.SqlTypes
>>
>> (only System.Data.Sql is new relative to the v1.1 framework)
>>
>> So where is the Oracle stuff ? What am I missing??
>>
>> Thanks
>>
>>
>>

6 Feb 2006 4:00 PM

Cowboy (Gregory A. Beamer) - MVP

Make a reference to the Oracle DLL and then the using statement.

Note that ODP.NET (free download from Oracle TechNet) is a better library if
you are into serious Oracle development.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

Show quote

"Mark" wrote:

> I'm confused ... I've read in a number of places that in VS2005, ADO.NET
> contains Oracle specific classes under the System.Data namespace (actually
> this was supposed to be available for the v1.1 framework). But I don't see
> the Oracle stuff in the Object Browser.
>
> I see:
>   System.Data.Common
>   System.Data.Odbc
>   System.Data.OleDb
>   System.Data.Sql
>   System.Data.SqlClient
>   System.Data.SqlTypes
>
> (only System.Data.Sql is new relative to the v1.1 framework)
>
> So where is the Oracle stuff ? What am I missing??
>
> Thanks
>
>
>