ODP.Net vs OO4O

  • Thread starter Thread starter Julia Sats
  • Start date Start date
J

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
 
Hi,

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

Ken
 
¤ 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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Hi Paul,

Paul Clement said:
¤ 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
Click to expand...
software.

From the info on the Oracle web site it seems that Oracle8 is enough.
Click to expand...
 
Miha Markic said:
Hi Paul,

Paul Clement said:
queryes performance
than using OO40 with COM
software.

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

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

The database can be Oracle 8.

David
Click to expand...
 
Back
Top