Re: MTS/Oracle8/ODBC

>Only Microsoft's driver is certified by MS to be used with Oracle & MTS.
Oracle has its own MTS integration component and it ships with Oracle8i on NT. Oracle's ODBC and OO4O are compatible with that.

Sunil

On Tue, 10 Aug 1999 15:07:51 GMT, jim_covington_at_my-deja.com wrote:

>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 Wed Aug 11 1999 - 17:10:20 CDT