Thomas,
I've had success with the following, but not 100%; it seems that sometimes
the PC used can play a role in whether or not you get a dedicated or shared
session; I have not yet had time to chase this down, as it would involve a
level 16 trace.
IPMQA_SHARED.NORWOOD.US.CATALINK.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phoenix)(PORT = 1530))
)
(CONNECT_DATA =
(SERVICE_NAME=IPMQA)
(SRVR=SHARED) <- here's what works most of the time
)
)
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax - 781-278-8341 (office)
email - [EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, February 25, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
All,
We are writing a Web Application using VB/ADO/COM+. Some of the data that
we display on the web pages come from another Oracle database, and we are
getting this data using database links.
So far, everything is going fine.
When we are in the middle of performing an update, and at the end of the
update we wish to query across the database link again (to display a new
screen), we are getting ORA-24777 which is telling me that the application
is using dedicated connections, and that I need to use Oracle Multi-Threaded
server connections to query across the link. If we do not query across the
db link, everything is fine.
I set MTS up on my machine (NT, 817). The dispatcher and server processes
are up and running, but I cannot for the life of me connect via a shared
server (V$SESSION.SERVER column=DEDICATED). I am also running through
Oracle Name server, if this matters.
Anybody got an idea of what I'm missing?
Thanks in advanced
Tom Mercadante
Oracle Certified Professional
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Paul R.
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
