Oracle 9i (release 2) and COM+
Alan Gamboa <[email protected]> Tue, 10 Sep 2002 16:05:09 -0400
| 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_01C25905.5D79F460
Content-Type: text/plain;
charset="iso-8859-1"
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.
------_=_NextPart_001_01C25905.5D79F460
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.2719.2200" name=GENERATOR></HEAD>
<BODY>
<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></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_01C25905.5D79F460--