Re: Oracle8i, Microsoft Transaction Server & VB

Throw away MTS and through away the VB module :=)

Seriously, make sure that the ODBC driver that you are using is multi-threaded and has the Bill Gates stamp of approval for use with Microsoft MTS. This is most likely your problem.

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

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 Wed Aug 18 1999 - 22:01:22 CDT