Oracle

Hi,

My app needs support for Oracle 10 g database : reading (select ...) +
updating + calling stored procedures + distributed transactions eventually.
I built it in VS 2005 (ado.net 2.0).

What should I use ? Microsoft Oracle .NET Managed provider or Oracle Data
Provider for .NET 2.0 ?
I want to know the limitations of each one, tricky pbs, licensing. Microsoft
did release a new Oracle.NET for .NET 2.0 ?? I found only the version 1.0
(http://www.microsoft.com/downloads/details.aspx?FamilyID=4f55d429-17dc-45ea-bfb3-076d1c052524&DisplayLang=en).

Does anyone know if I can use promotable transactions (TransactionScope)
when working with Oracle 10g ?

Thanks for any advice



.

Relevant Pages

  • Re: Oracle
    ... Microsoft Oracle .NET Managed provider or Oracle Data ... Does anyone know if I can use promotable transactions ... technology provided by the database vendor. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle
    ... Microsoft Oracle .NET Managed provider or Oracle Data ... Does anyone know if I can use promotable transactions ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is Interbase still thriving?
    ... when faced with MSSQL and wether to adapt ... In Oracle/IB/Progress you have much less contention problems derived ... Oracle DB. ... It´s very important that you design your transactions to ...
    (borland.public.delphi.non-technical)
  • Re: AutoCommit - Oracle.
    ... > and invoked the stored procedures, the user would not have to worry about ... Oracle never autocommits. ... are only internal should not be used to control transactions. ...
    (microsoft.public.dotnet.framework.adonet)
  • EMN0 process memory leak.
    ... We have an SR open with oracle ... ... before placing a message on persistent queue from where it ... is sent across a dblink into a destination queue on the Datamart. ... what will be the impact on any transactions? ...
    (comp.databases.oracle.server)