ODP.Net vs OO4O

[Julia Sats]

Hi,

I use in VB6 OO4O for connecting to Oracle, run procedures, sql queryes and
so on.
Now I am going to move to VB.Net. And I found that Oracle developer ODP.Net

Please give advice do I need to use ODP or continue to use OO4O?
If I need to move to ODP why it is better then OO4O?

Thanks

[Ken Tucker [MVP]]

Hi,

Take a look at System.Data.OracleClient in the framework version
1.1.

Ken
----------------
"Julia Sats" <ju********@sympatico.ca> wrote in message
news:VZ********************@news20.bellglobal.com. ..

Hi,

I use in VB6 OO4O for connecting to Oracle, run procedures, sql queryes and so on.
Now I am going to move to VB.Net. And I found that Oracle developer ODP.Net
Please give advice do I need to use ODP or continue to use OO4O?
If I need to move to ODP why it is better then OO4O?

Thanks

[Paul Clement]

On Tue, 4 Nov 2003 22:16:02 -0500, "Julia Sats" <ju********@sympatico.ca> wrote:

¤ Hi,
¤
¤ I use in VB6 OO4O for connecting to Oracle, run procedures, sql queryes and
¤ so on.
¤ Now I am going to move to VB.Net. And I found that Oracle developer ODP.Net
¤
¤ Please give advice do I need to use ODP or continue to use OO4O?
¤ If I need to move to ODP why it is better then OO4O?

ODP is a native .NET provider and you will probably get better performance than using OO40 with COM
Interop. Just keep in mind that ODP requires the Oracle 9i client software.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Miha Markic]

Hi Paul,

"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:16********************************@4ax.com...

On Tue, 4 Nov 2003 22:16:02 -0500, "Julia Sats" <ju********@sympatico.ca> wrote:
¤ Hi,
¤
¤ I use in VB6 OO4O for connecting to Oracle, run procedures, sql queryes and ¤ so on.
¤ Now I am going to move to VB.Net. And I found that Oracle developer ODP.Net ¤
¤ Please give advice do I need to use ODP or continue to use OO4O?
¤ If I need to move to ODP why it is better then OO4O?

ODP is a native .NET provider and you will probably get better performance than using OO40 with COM Interop. Just keep in mind that ODP requires the Oracle 9i client

software.

From the info on the Oracle web site it seems that Oracle8 is enough.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

[David Browne]

"Miha Markic" <miha at rthand com> wrote in message
news:OW**************@TK2MSFTNGP10.phx.gbl...

Hi Paul,

"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:16********************************@4ax.com...

On Tue, 4 Nov 2003 22:16:02 -0500, "Julia Sats"

<ju********@sympatico.ca> wrote:

¤ Hi,
¤
¤ I use in VB6 OO4O for connecting to Oracle, run procedures, sql

queryes and

¤ so on.
¤ Now I am going to move to VB.Net. And I found that Oracle developer ODP.Net

¤
¤ Please give advice do I need to use ODP or continue to use OO4O?
¤ If I need to move to ODP why it is better then OO4O?

ODP is a native .NET provider and you will probably get better

performance than using OO40 with COM

Interop. Just keep in mind that ODP requires the Oracle 9i client

software.

From the info on the Oracle web site it seems that Oracle8 is enough.

ODP.NET requires the Oracle 9i client (and installs it too).

The database can be Oracle 8.

David