Re: Oracle8i, Microsoft Transaction Server & VB

From: Jeff Hunter <>
Date: Tue, 17 Aug 1999 22:56:29 -0400
Message-ID: <>

There are some views that need to be created ($ORACLE_HOME/rdbms/admin/xaview.sql) for the distrubuted transactions to work. Also, you have to bump up some parameters in the init.ora file (don't have them now, but got all the info from ms website...

Jon Unwin wrote in message <7pc2pf$spm$>...
>Can anyone out there help me with this connectivity problem?
> I have a Sun Unix box with Oracle 8i running on it and a Windows NT server
>with MTS on it. I have a VB module that uses ADO & ODBC to connect to the
>Oracle database. When the VB module is under MTS the communication fails.
>The 'Oracle Manger for MTS Services' returns a message stating that the
>id does not have the required access to the MTS_PROXY_INFO table and
>disconnects. When the module is not run under MTS it executes without a
>problem. If the user connects to the Oracle DB manually then they have
>access to the table but there is nothing in it. I have looked on a number
>websites including MS and Oracle technets and support. Does anyone know why
>I can not aquire the connection or somewhere where I could find the
>to this problem?
>Thanks for the help.
Received on Wed Aug 18 1999 - 04:56:29 CEST

Original text of this message