Re: Oracle8i, Microsoft Transaction Server & VB

From: David Sisk <>
Date: Wed, 18 Aug 1999 23:01:22 -0400
Message-ID: <chKu3.1052$>

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
Like original music?  Listen to song samples and buy a CD at

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 Thu Aug 19 1999 - 05:01:22 CEST

Original text of this message