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$1_at_news1.cableinet.co.uk>...
>Hi.
>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
user
>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
of
>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
solution
>to this problem?
>
>Thanks for the help.
>Jon.
>junwin_at_fdgroup.co.uk
>
>
Received on Tue Aug 17 1999 - 21:56:29 CDT
