Re: Oracle client problem via dllhost.exe
"Beauchemin, Bob" <[email protected]> Tue, 22 Oct 2002 13:05:17 -0700
| Newsgroups | gmane.comp.windows.devel.oledb.devel |
|---|---|
| Message-ID | <94FD4438D783D74EA86DC692E776C127023835B8@la-infoserver.develop.com> |
This is a multi-part message in MIME format.
------_=_NextPart_001_01C27A06.5780E093
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I'd bet on \oracle\yourversion\bin.
=20
Bob Beauchemin
http://staff.develop.com/bobb
=20
-----Original Message-----
From: Alan Gamboa [mailto:[email protected]]=20
Sent: Tuesday, October 22, 2002 12:48 PM
To: [email protected]
Subject: Re: [OLEDB_DEV] Oracle client problem via dllhost.exe
=09
=09
Bob B. and Bob D.
=20
thanks, that did the trick - now I gotta figure out where
IWAM_MACHINENAME needs permissions :)
=20
-Alan
-----Original Message-----
From: Beauchemin, Bob [mailto:[email protected]]
Sent: Monday, October 21, 2002 9:17 PM
To: [email protected]
Subject: Re: [OLEDB_DEV] Oracle client problem via
dllhost.exe
=09
=09
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.=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_01C27A06.5780E093
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=3D356310320-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2>I'd=20
bet on \oracle\yourversion\bin.</FONT></SPAN></DIV>
<DIV><SPAN class=3D356310320-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D356310320-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2>Bob=20
Beauchemin</FONT></SPAN></DIV>
<DIV><SPAN class=3D356310320-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=3D356310320-22102002><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></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> Tuesday, October 22, =
2002 12:48=20
PM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> Re:=20
[OLEDB_DEV] Oracle client problem via dllhost.exe<BR><BR></FONT></DIV>
<DIV><SPAN class=3D923005419-22102002><FONT face=3DArial =
color=3D#0000ff size=3D2>Bob=20
B. and Bob D.</FONT></SPAN></DIV>
<DIV><SPAN class=3D923005419-22102002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D923005419-22102002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>thanks, that did the trick - now I gotta figure out where=20
IWAM_MACHINENAME needs permissions :)</FONT></SPAN></DIV>
<DIV><SPAN class=3D923005419-22102002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D923005419-22102002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>-Alan</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Beauchemin, Bob=20
[mailto:[email protected]]<BR><B>Sent:</B> Monday, October 21, 2002 =
9:17=20
PM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> =
Re:=20
[OLEDB_DEV] Oracle client problem via =
dllhost.exe<BR><BR></FONT></DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Does IWAM_MACHINENAME have access to the Oracle client =
libraries?=20
I've seen recently where some versions of Oracle client will install =
on some=20
OSs with very limited permissions. In addition, bear in mind that =
your=20
security principal may write client trace files on various =
directories of=20
the machine under various circumstances (look for files that end in =
".ora")=20
and may actually require write permissions in this =
case.</FONT></SPAN></DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial =
color=3D#0000ff=20
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=20
fixes the problem.</FONT></SPAN></DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Hope this helps,</FONT></SPAN></DIV>
<DIV><SPAN class=3D538160901-22102002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Bob 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=20
3:23 PM<BR><B>To:</B> =
[email protected]<BR><B>Subject:</B>=20
[OLEDB_DEV] 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=20
Oracle or MS Sql database. Using a C++ testclient w/ smart =
pointers to my=20
object, everything works fine when the provider is any of the=20
following:</FONT></P>
<P> <FONT=20
size=3D2>SQLOLEDB.1</FONT> =
<BR> =20
<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=20
either oracle provider I get a pop window asking me if i want to =
send the=20
error to Microsoft, the basic message is "COM Surrogate has =
encountered a=20
problem and needs to close. We are sorry for the=20
inconvenience"</FONT></P>
<P><FONT size=3D2>I messagebox trace my code to the following =
call:</FONT>=20
</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=20
never 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=20
entering via dllhost.exe as IWAM_MACHINENAME.</FONT></P>
<P><FONT size=3D2>does anyone have any insight/solution to my=20
situation?</FONT> </P>
<P><FONT size=3D2>thank.</FONT> </P>
<P><FONT size=3D2>Alan Gamboa</FONT> <BR><FONT size=3D2>CCG =
Systems,=20
inc.</FONT> </P>You can read messages from the OLEDB_DEV archive,=20
unsubscribe from OLEDB_DEV, or subscribe to other DevelopMentor =
lists at=20
http://discuss.develop.com. </BLOCKQUOTE>You can read messages =
from the=20
OLEDB_DEV archive, unsubscribe from OLEDB_DEV, or subscribe to other =
DevelopMentor lists at http://discuss.develop.com. </BLOCKQUOTE>You =
can read=20
messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV, or =
subscribe=20
to other DevelopMentor lists at http://discuss.develop.com.=20
</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_01C27A06.5780E093--