Re: Oracle8i, Microsoft Transaction Server & VB
From: David Sisk <davesisk_at_ipass.net>
Date: Wed, 18 Aug 1999 23:01:22 -0400
Message-ID: <chKu3.1052$tp2.888_at_news.ipass.net>
Date: Wed, 18 Aug 1999 23:01:22 -0400
Message-ID: <chKu3.1052$tp2.888_at_news.ipass.net>
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>...Received on Thu Aug 19 1999 - 05:01:22 CEST
>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
>
>