Re: Oracle client problem via dllhost.exe
"Beauchemin, Bob" <[email protected]> Mon, 21 Oct 2002 18:16:46 -0700
| Newsgroups | gmane.comp.windows.devel.oledb.devel |
|---|---|
| Message-ID | <94FD4438D783D74EA86DC692E776C12702D0A809@la-infoserver.develop.com> |
This is a multi-part message in MIME format.
------_=_NextPart_001_01C27968.B0BBBFF9
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Does IWAM_MACHINENAME have access to the Oracle client libraries? I've
seen recently where some versions of Oracle client will install on some
OSs with very limited permissions. In addition, bear in mind that your
security principal may write client trace files on various directories
of the machine under various circumstances (look for files that end in
".ora") and may actually require write permissions in this case.
=20
An easy test of this is to change the anonymous web user to run as you
(***only*** as a test and not on a live machine) to see if this fixes
the problem.
=20
Hope this helps,
Bob Beauchemin
http://staff.develop.com/bobb
=20
-----Original Message-----
From: Alan Gamboa [mailto:[email protected]]=20
Sent: Monday, October 21, 2002 3:23 PM
To: [email protected]
Subject: [OLEDB_DEV] Oracle client problem via dllhost.exe
=09
=09
I have a COM object that uses OLEDB to access either an Oracle
or MS Sql database. Using a C++ testclient w/ smart pointers to my
object, everything works fine when the provider is any of the following:
SQLOLEDB.1=20
MSDAORA.1=20
OraOLEDB.Oracle.1=20
when i try to access the object from a .asp page via the
follwoing code:=20
=20
set obj =3D Server.CreateObject("MyObject.MyTable")=20
set rs =3D obj.myMethod(params)=20
with SQLOLEDB.1 it works great (of course!) but with either
oracle provider I get a pop window asking me if i want to send the error
to Microsoft, the basic message is "COM Surrogate has encountered a
problem and needs to close. We are sorry for the inconvenience"
I messagebox trace my code to the following call:=20
ds.OpenWithServiceComponents(...);=20
via the .asp page, i get to the call in my code and it never
comes back, I don't even get the pleasure of an E_FAIL as a returned
HRESULT. The code is wrapped in the try/catch block and never gets a
chance to "catch"
the biggest difference that i can see is that the c++ testclient
is using my security credentials where as the .asp page is entering via
dllhost.exe as IWAM_MACHINENAME.
does anyone have any insight/solution to my situation?=20
thank.=20
Alan Gamboa=20
CCG Systems, inc.=20
You can read messages from the OLEDB_DEV archive, unsubscribe
from OLEDB_DEV, or subscribe to other DevelopMentor lists at
http://discuss.develop.com.=20
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_01C27968.B0BBBFF9
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2>Does=20
IWAM_MACHINENAME have access to the Oracle client libraries? I've seen =
recently=20
where some versions of Oracle client will install on some OSs with very =
limited=20
permissions. In addition, bear in mind that your security principal may =
write=20
client trace files on various directories of the machine under various=20
circumstances (look for files that end in ".ora") and may actually =
require write=20
permissions in this case.</FONT></SPAN></DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2>An=20
easy test of this is to change the anonymous web user to run as=20
you (***only*** as a test and not on a live machine) to see if this =
fixes=20
the problem.</FONT></SPAN></DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2>Hope=20
this helps,</FONT></SPAN></DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2>Bob=20
Beauchemin</FONT></SPAN></DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2><A=20
href=3D"http://staff.develop.com/bobb">http://staff.develop.com/bobb</A><=
/FONT></SPAN></DIV>
<DIV><SPAN class=3D538160901-22102002></SPAN> </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B> Alan =
Gamboa=20
[mailto:[email protected]] <BR><B>Sent:</B> Monday, October 21, 2002 =
3:23=20
PM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> =
[OLEDB_DEV]=20
Oracle client problem via dllhost.exe<BR><BR></FONT></DIV>
<P><FONT size=3D2>I have a COM object that uses OLEDB to access either =
an Oracle=20
or MS Sql database. Using a C++ testclient w/ smart pointers to my =
object,=20
everything works fine when the provider is any of the =
following:</FONT></P>
<P> <FONT =
size=3D2>SQLOLEDB.1</FONT>=20
<BR> <FONT =
size=3D2>MSDAORA.1</FONT>=20
<BR> <FONT=20
size=3D2>OraOLEDB.Oracle.1</FONT> </P>
<P><FONT size=3D2>when i try to access the object from a .asp page via =
the=20
follwoing code:</FONT> <BR> =20
<BR><FONT size=3D2> set obj =3D=20
Server.CreateObject("MyObject.MyTable")</FONT> <BR><FONT=20
size=3D2> set rs =3D obj.myMethod(params)</FONT> =
</P>
<P><FONT size=3D2>with SQLOLEDB.1 it works great (of course!) but with =
either=20
oracle provider I get a pop window asking me if i want to send the =
error to=20
Microsoft, the basic message is "COM Surrogate has encountered a =
problem and=20
needs to close. We are sorry for the inconvenience"</FONT></P>
<P><FONT size=3D2>I messagebox trace my code to the following =
call:</FONT> </P>
<P> <FONT=20
size=3D2>ds.OpenWithServiceComponents(...);</FONT> </P>
<P><FONT size=3D2>via the .asp page, i get to the call in my code and =
it never=20
comes back, I don't even get the pleasure of an E_FAIL as a returned=20
HRESULT. The code is wrapped in the try/catch block and never =
gets a=20
chance to "catch"</FONT></P>
<P><FONT size=3D2>the biggest difference that i can see is that the =
c++=20
testclient is using my security credentials where as the .asp page is =
entering=20
via dllhost.exe as IWAM_MACHINENAME.</FONT></P>
<P><FONT size=3D2>does anyone have any insight/solution to my =
situation?</FONT>=20
</P>
<P><FONT size=3D2>thank.</FONT> </P>
<P><FONT size=3D2>Alan Gamboa</FONT> <BR><FONT size=3D2>CCG Systems, =
inc.</FONT>=20
</P>You can read messages from the OLEDB_DEV archive, unsubscribe from =
OLEDB_DEV, or subscribe to other DevelopMentor lists at=20
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.
=00
------_=_NextPart_001_01C27968.B0BBBFF9--