Re: MTS/Oracle8/ODBC

Only Microsoft's driver is certified by MS to be used with Oracle & MTS.

In article <379cf59e.625966515_at_newshost.us.oracle.com>,   smushran_at_nospam.us.oracle.com (smushran) wrote:
> Have you tried Oracle's ODBC driver?
>
> sm
>
> On Fri, 23 Jul 1999 10:27:09 +0100, "Julian Cowking"
> <jcowking_at_hrmsoftware.com> wrote:
>
> >Hi,
> >
> >I'm writing and application using MTS and connecting to either SQL
Server 7
> >or Oracle database (depending upon client's preference).
> >
> >Although the performance of both databases is comparible, there is
one area
> >where using an Oracle database is proving much slower. This is
caused when
> >establishing an ODBC connection (using Microsoft's ODBC driver for
Oracle)
> >from MTS. It takes AGES (about 2secs)! This proves to be a problem
because a
> >new connection is required *per process* - and my application uses
many
> >processes (many MTS packages) - so, if a user has been hanging about
for a
> >while (more than 60 seconds or whatever the 'timeout' for pooled ODBC
> >connections is) the execution of the next request will take a long
time to
> >complete since, maybe, 3 connections need to be established.
> >
> >Now MTS caches ODBC connections and, when the connection is cached
the
> >performance is, as you would expect, excellent. The problem is when
the
> >connection has not been used for a while (60 seconds by default) the
> >connection is torn down (to free resources) and the next request will
> >require the creation of another connection.
> >
> >So, my question - is there a way to speed up the time required to
establish
> >a connection to an Oracle database from ODBC/MTS?
> >
> >Many thanks,
> >
> >Julian
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 10 1999 - 10:07:51 CDT