Re: MTS & Oracle 8i

Actually, we are using it so that we can pool the connection threads through MTS, rather than keeping one connection open throughout a "batch job" session. This was recommended by Microsoft.

Each time we run a CRUD statement, we open a new connection, run the statement and close the connection. Supposedly, MTS will take care of the commit and rollback through the SetAbort/SetComplete ObjectContext commands, as long as we are building our objects to Require Transactions (which opens up an entirely different can of worms). Ms says this is more efficient.

    We are not working strictly with Oracle either. Our objects can also connect to SQL Server (never simultaniously though. It is intended that the user choose either/or).

MMayer3077 <mmayer3077_at_aol.com> wrote in message news:20000417210105.15549.00001918_at_ng-cr1.aol.com...
> Wait a second. I think that by using the MTS against an ORACLE instance
 you
> are doing too much. VB works fine against ORACLE. The MTS is the
 transaction
> server which was built to host a mult user envirorment which is what
 ORACLE is
> a already all about. I would suggest just trying to get to your ORACLE
 thru
> the OLE interface. I don't see why you want MTS to talk to ORACLE
 unless it
> would be to try to SYNC to databases sharing common data etc.
Received on Tue Apr 18 2000 - 00:00:00 CDT