Showing posts with label connectivity. Show all posts
Showing posts with label connectivity. Show all posts

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!!!!

Friday, February 10, 2012

BDE 5.01 not connecting to SQL2K after patching

Hello All,
I am experiencing unusual behaviour with a number of desktops (3 of 20) running the BDE and the SQL connectivity option from the sql cd. For reasons unknown the BDE suddenly stops connecting to the database and cant be fixed without a reimage. Appears t
o be a key or dll that is causing interoperability issues.
No idea what o/s patch is causing trouble at this stage but its a recent phenomena.
has anyone seen this type of behaviour with third part software using BDE/SQL connectivity ?
Brian in AU
+61 431 479 751
What error do you get?
Could the problem be something along these lines?
259569 PRB: Installing Third-Party Product Breaks Windows 2000 MDAC Registry
http://support.microsoft.com/?id=259569
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.