Re: Oracle/MTS/Odbc

Oracle Service for MTS, an NT service, must be configured for Oracle8i (I hope that 8.0.5 is not different). This is an NT Service that can be installed on any NT machine on the network. This service co-ordinates the transactions.This service requires a login on the database that participates in the MTS transaction. Login owns a table MTS_PROXY_INFO table and MTS database users (who takepart in MTS transations) must have 'DML' privileges on the table. Documentation is available on the CD.

Thanks
Thomas

premal_shah_at_my-deja.com wrote:

> Hi! Folks:
>
> We are using the Data Direct ODBC driver 3.5 from Merant Corp. for
> talking to our Oracle databases from our client applications. We want
> MTS to manage our transactions. Our Oracle version is 8.0.5.1 on
> Solaris 2.6 on a SUN box.
>
> In MTS, we set the property "REQUIRES A TRANSACTION". When we connect
> via ODBC we get an error in the event viewer which says "Unable to
> communicate with DTC" and says failed to enlist in DTC.
>
> DTC is up and running. We also tried to view trace messages in MTS
> explorer but none are generated.
>
> Could you please let us know what the problem might be? Merant docs
> say this feature is supported.
>
> Thanks for your help.
>
> regards,
> premal
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Sep 10 1999 - 01:01:54 CDT