Sunday, February 19, 2012

Benchmark of ODBC vs Oracle Net8 for Connectivity

Do any one have any unbiased benchmarks of the performance differences of
connecting an Oracle 9i DB to MS SQL Server 2000 via ODBC vs NET8?
References for any pros and cons.
Any guidance would be appreciated!!!!
Don't think you can really compare the two in terms of
connecting with SQL Server. You need to use ODBC or OLE DB
to connect to an Oracle database. The server needs to have
the Oracle client installed. You don't use just the Oracle
components (such as Net 8) to connect to Oracle but the
Oracle client components are a part of the connectivity when
using ODBC or OLE DB against an Oracle database.
-Sue
On Fri, 10 Sep 2004 15:05:02 -0700, "Mike"
<Mike@.discussions.microsoft.com> wrote:

>Do any one have any unbiased benchmarks of the performance differences of
>connecting an Oracle 9i DB to MS SQL Server 2000 via ODBC vs NET8?
>References for any pros and cons.
>Any guidance would be appreciated!!!!

No comments:

Post a Comment