Re: Accessing Oracle 9i tables on a Linux box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Roy Fine (rlfine_at_twt.obfuscate.net)
Date: 07/21/04 

Date: Tue, 20 Jul 2004 21:24:02 -0400

Ron,

The Oracle .Net Managed client is built upon the Oracle Call Interface
(OCI) - and that is the same interface that the MSFT provider is built upon.
OCI is in turn implemented upon the Net8 protocol stack and the Two Task
Layer - which will effectively isolate you from any of the database server
implementation details. You should not be concerned with the platform used
by the server - it could be Solaris, HP, Linux, Windows NT/2000, etc - it
all works the same from the client side.

With respect to the ODP.NET implementation - I have found it quite stable.
Having programming in VC++ and OCI for the past 5 years, the .NET and C# are
a very welcome productivity boost, and performance with respect to OCI is
not noticably different on the things that we do - and with array binding,
and collection pararmeters with bulk binding for stored procedure, moving
large amounts of data across the network is VERY much improved over other
provider implementations.

regards
roy fine

"Ron Fluegge" <rmflugge@swbell.net> wrote in message
news:uUrOirrbEHA.1408@TK2MSFTNGP12.phx.gbl...
> Will ADO.NET have any problems accessing Oracle 9i tables running on a
Linux
> box using the Microsoft .net managed provider for Oracle?
>
> I am assuming not, but it won't be the first time that I have seriously
> underestimated the issues involved in such a project.
>
> I have looked at Oracle's .net managed provider and am not happy with
their
> implementation for our specific use.
>
> Sorry for asking such dumb questions, but we are under a short timeframe
to
> respond to the client.
>
> Thanks for any advice and comments...
>
> Ron
>
> RonFlueggeATswbellDOTnet
>
>

Relevant Pages

  • Re: DBD::Oracle 1.19 failing to make
    ... Your Oralce client 8.0.5.0.0 is most likly too old to use the latest version of DBD. ... There were a number of changes in the OCI for the 9x version especially in the area of Batch feeding and this is where you are getting your errors. ... Can you tell me which version of the Oracle client you are using as I also see a funny warning in that it cannot find SQL*Plus. ...
    (perl.dbi.users)
  • Re: Oracle Provider with Unicode support
    ... > not using Oracle client version 8.1.7 or above. ... but it is not supported by this Provider. ... > have Unicode support. ... The microsoft layer runs on top of the Oracle layer (you can have the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Data Provider for Oracle: MS version vs. Oracle?
    ... and myCustomer is a Customer entity filled from Oracle using ODP.NET. ... but that doesn't mean my int customerID code ... mappings which differ alot between ODP.NET and MS' oracle provider. ... rely on the Oracle CLI (client interface). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Data Provider for Oracle: MS version vs. Oracle?
    ... that's great but my experiences are different. ... differ alot between ODP.NET and MS' oracle provider. ... on the Oracle CLI (client interface). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Data Provider for Oracle: MS version vs. Oracle?
    ... swap providers, because of the NUMBER-> .NET type mappings which ... differ alot between ODP.NET and MS' oracle provider. ... ODP.NET and MS' provider are on par with performance, ... on the Oracle CLI (client interface). ...
    (microsoft.public.dotnet.framework.adonet)