Lisa,
Dont ever use Oracle 8/8i drivers. I had a pretty bad experience
with them.
I was
called at a clients place to check their web app. they were using silk test to
check the load performance against SQL Server 7 and Oracle 8i.
when
connected to SQL Server the app was reporting an avg response of 1.5 secs,
whereas with Oracle it was around 17 secs.
After
checking it was found that the Oracle odbc driver was the culprit. after
switching to MS provided Oracle driver, Oracle performance was a
beau.
I have
all the statspack reports before and after the driver switch
-Mandar
-----Original Message-----
From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 3:11 PM
To: Multiple recipients of list ORACLE-L
Subject: OT: ODBC version errorsHi everyone -
I have several developers telling me that their web applications (some are purchased packages and some are developed in-house) do not work with Oracle ODBC drivers if they are version 8. Every one of their applications seems to run fine with the 7.3.4 ODBC drivers. They get a variety of errors - some get odd messages when they try to login, others get Dr. Watson errors when there are more than x number of users connecting.
Does anyone know of existing problems (or fixes) related to the 8 (both 8.0 and 8.1) drivers? ........ or, can you point me to any documents / sites / user groups that could better answer my question?
Thanks very much -
Lisa
