Re: Oracle 9i (release 2) and COM+
"DeRemer, Bob" <[email protected]> Tue, 10 Sep 2002 13:20:15 -0700
| Newsgroups | gmane.comp.windows.devel.oledb.devel |
|---|---|
| Message-ID | <[email protected]> |
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C25907.79166870
Content-Type: text/plain;
charset="iso-8859-1"
I have done this using Oracle 8.1.7 and COM+ under Win2K SP1. It was a real
pain, but was doable. First off, I don't know what may have changed
architecturally from 8i to 9i, so take this with a grain of salt.
The key problem I had when configuring my COM+ server to work with Oracle
was that the various COM+/MTS related services needed to be running under
with a valid domain identity. When running as localsystem, things would not
connect up. I found quite a bit of information on the Oracle Partners site
[under the 8i Windows documentation]. I would imagine the 9i docs for
windows should be available. Like most other things on the Oracle site,
however, you'll probably have to dig for a while to find it.
Hope this helps,
Bob DeRemer
-----Original Message-----
From: Alan Gamboa [mailto:[email protected]]
Sent: Tuesday, September 10, 2002 4:05 PM
To: [email protected]
Subject: Oracle 9i (release 2) and COM+
I am getting an XACT_E_NOENLIST error when using Oracle's OLE DB driver to
access and Oracle 9iR2 database via a COM+ component. (WIth the MS driver
for Oracle, I get XACT_E_TMNOTAVAILABLE). Of course everything works great
with MS SQL Server. Inquire type queries work fine, I only get the error
when I try modify anything (which, of course, is where transactions are
used)
I've been scanning the archives and searching for help on both the Oracle
and MS sites, but there is no definitive "This is how you set all this up"
Has anyone successfully setup COM+ using an Oracle OLE DB driver to access
an Oracle 9i database using transactions?
or does anyone know of a definitive resource that explains "exactly" how to
tie everything together?
TIA
Alan Gamboa
Senior Systems Engineer
CCG Systems, Inc.
612 Colonial Avenue
Norfolk, VA 23507-1806
voice: 757-623-1700 ext. 109
fax: 757-625-5114
email: [email protected]
web: www.ccgsystems.com
You can read messages from the OLEDB_DEV archive, unsubscribe from
OLEDB_DEV, or subscribe to other DevelopMentor lists at
http://discuss.develop.com.
You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.
------_=_NextPart_001_01C25907.79166870
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=610071620-10092002><FONT face=Arial color=#0000ff size=2>I have
done this using Oracle 8.1.7 and COM+ under Win2K SP1. It was a real pain,
but was doable. First off, I don't know what may have changed
architecturally from 8i to 9i, so take this with a grain of
salt.</FONT></SPAN></DIV>
<DIV><SPAN class=610071620-10092002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610071620-10092002><FONT face=Arial color=#0000ff size=2>The
key problem I had when configuring my COM+ server to work with Oracle was that
the various COM+/MTS related services needed to be running under with a valid
domain identity. When running as localsystem, things would not connect
up. I found quite a bit of information on the Oracle Partners site [under
the 8i Windows documentation]. I would imagine the 9i docs for windows
should be available. Like most other things on the Oracle site, however,
you'll probably have to dig for a while to find it.</FONT></SPAN></DIV>
<DIV><SPAN class=610071620-10092002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=610071620-10092002><FONT face=Arial color=#0000ff size=2>Hope
this helps,</FONT></SPAN></DIV>
<DIV><SPAN class=610071620-10092002><FONT face=Arial color=#0000ff size=2>Bob
DeRemer</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Alan Gamboa
[mailto:[email protected]]<BR><B>Sent:</B> Tuesday, September 10, 2002 4:05
PM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> Oracle 9i
(release 2) and COM+<BR><BR></FONT></DIV>
<DIV><SPAN class=234355319-10092002><FONT face=Arial size=2>I am getting an
XACT_E_NOENLIST error when using Oracle's OLE DB driver to access and
Oracle 9iR2 database via a COM+ component. (WIth the MS driver for
Oracle, I get XACT_E_TMNOTAVAILABLE). Of course everything works great
with MS SQL Server. Inquire type queries work fine, I only get the error
when I try modify anything (which, of course, is where transactions are
used)</FONT></SPAN></DIV>
<DIV><SPAN class=234355319-10092002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234355319-10092002><FONT face=Arial size=2>I've been scanning
the archives and searching for help on both the Oracle and MS sites, but there
is no definitive "This is how you set all this up"</FONT></SPAN></DIV>
<DIV><SPAN class=234355319-10092002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234355319-10092002><FONT face=Arial size=2>Has anyone
successfully setup COM+ using an Oracle OLE DB driver to access an Oracle 9i
database using transactions?</FONT></SPAN></DIV>
<DIV><SPAN class=234355319-10092002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234355319-10092002><FONT face=Arial size=2>or does anyone
know of a definitive resource that explains "exactly" how to tie everything
together?</FONT></SPAN></DIV>
<DIV><SPAN class=234355319-10092002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=234355319-10092002><FONT face=Arial
size=2>TIA</FONT></SPAN></DIV>
<DIV><SPAN class=234355319-10092002></SPAN><SPAN
class=234355319-10092002></SPAN><SPAN class=234355319-10092002><FONT
face=Arial size=2></FONT></SPAN> </DIV>
<DIV align=left>
<DIV align=left><FONT face=Arial size=2>Alan Gamboa</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Senior Systems Engineer</FONT></DIV>
<DIV align=left><B><FONT face=Arial size=2>CCG Systems, Inc.</FONT></B></DIV>
<DIV align=left><FONT face=Arial size=2>612 Colonial Avenue</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Norfolk, VA
23507-1806</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>voice:
757-623-1700 ext. 109</FONT></DIV>
<DIV align=left><FONT face=Arial
size=2>fax: 757-625-5114</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>email:
[email protected]</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>web:
www.ccgsystems.com</FONT></DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>You can read messages from the
OLEDB_DEV archive, unsubscribe from OLEDB_DEV, or subscribe to other
DevelopMentor lists at http://discuss.develop.com. </BLOCKQUOTE></BODY></HTML>
You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.
------_=_NextPart_001_01C25907.79166870--