Re: Oracle client problem via dllhost.exe
"DeRemer, Bob" <[email protected]> Tue, 22 Oct 2002 13:13:34 -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_01C27A07.7FB87530
Content-Type: text/plain;
charset="iso-8859-1"
Glad you got it going. Oracle is always a "bit" more challenging than
hooking MS to MS.
-----Original Message-----
From: Beauchemin, Bob [mailto:[email protected]]
Sent: Tuesday, October 22, 2002 4:05 PM
To: [email protected]
Subject: Re: Oracle client problem via dllhost.exe
I'd bet on \oracle\yourversion\bin.
Bob Beauchemin
http://staff.develop.com/bobb <http://staff.develop.com/bobb>
-----Original Message-----
From: Alan Gamboa [mailto:[email protected]]
Sent: Tuesday, October 22, 2002 12:48 PM
To: [email protected]
Subject: Re: [OLEDB_DEV] Oracle client problem via dllhost.exe
Bob B. and Bob D.
thanks, that did the trick - now I gotta figure out where IWAM_MACHINENAME
needs permissions :)
-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
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.
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.
Hope this helps,
Bob Beauchemin
http://staff.develop.com/bobb <http://staff.develop.com/bobb>
-----Original Message-----
From: Alan Gamboa [mailto:[email protected]]
Sent: Monday, October 21, 2002 3:23 PM
To: [email protected]
Subject: [OLEDB_DEV] Oracle client problem via dllhost.exe
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
MSDAORA.1
OraOLEDB.Oracle.1
when i try to access the object from a .asp page via the follwoing code:
set obj = Server.CreateObject("MyObject.MyTable")
set rs = obj.myMethod(params)
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:
ds.OpenWithServiceComponents(...);
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?
thank.
Alan Gamboa
CCG Systems, inc.
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.
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.
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_01C27A07.7FB87530
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">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=207031320-22102002><FONT face=Arial color=#0000ff size=2>Glad
you got it going. Oracle is always a "bit" more challenging than hooking
MS to MS.</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Beauchemin, Bob
[mailto:[email protected]]<BR><B>Sent:</B> Tuesday, October 22, 2002 4:05
PM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> Re: Oracle
client problem via dllhost.exe<BR><BR></FONT></DIV>
<DIV><SPAN class=356310320-22102002><FONT face=Arial color=#0000ff size=2>I'd
bet on \oracle\yourversion\bin.</FONT></SPAN></DIV>
<DIV><SPAN class=356310320-22102002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=356310320-22102002><FONT face=Arial color=#0000ff size=2>Bob
Beauchemin</FONT></SPAN></DIV>
<DIV><SPAN class=356310320-22102002><FONT face=Arial color=#0000ff size=2><A
href="http://staff.develop.com/bobb">http://staff.develop.com/bobb</A></FONT></SPAN></DIV>
<DIV><SPAN class=356310320-22102002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us 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, October 22, 2002
12:48 PM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> Re:
[OLEDB_DEV] Oracle client problem via dllhost.exe<BR><BR></FONT></DIV>
<DIV><SPAN class=923005419-22102002><FONT face=Arial color=#0000ff
size=2>Bob B. and Bob D.</FONT></SPAN></DIV>
<DIV><SPAN class=923005419-22102002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=923005419-22102002><FONT face=Arial color=#0000ff
size=2>thanks, that did the trick - now I gotta figure out where
IWAM_MACHINENAME needs permissions :)</FONT></SPAN></DIV>
<DIV><SPAN class=923005419-22102002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=923005419-22102002><FONT face=Arial color=#0000ff
size=2>-Alan</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Beauchemin, Bob
[mailto:[email protected]]<BR><B>Sent:</B> Monday, October 21, 2002 9:17
PM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> Re:
[OLEDB_DEV] Oracle client problem via dllhost.exe<BR><BR></FONT></DIV>
<DIV><SPAN class=538160901-22102002><FONT face=Arial color=#0000ff
size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=538160901-22102002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=538160901-22102002><FONT face=Arial color=#0000ff
size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=538160901-22102002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=538160901-22102002><FONT face=Arial color=#0000ff
size=2>Hope this helps,</FONT></SPAN></DIV>
<DIV><SPAN class=538160901-22102002><FONT face=Arial color=#0000ff
size=2>Bob Beauchemin</FONT></SPAN></DIV>
<DIV><SPAN class=538160901-22102002><FONT face=Arial color=#0000ff
size=2><A
href="http://staff.develop.com/bobb">http://staff.develop.com/bobb</A></FONT></SPAN></DIV>
<DIV><SPAN class=538160901-22102002></SPAN> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Alan
Gamboa [mailto:[email protected]] <BR><B>Sent:</B> Monday, October 21,
2002 3:23 PM<BR><B>To:</B>
[email protected]<BR><B>Subject:</B> [OLEDB_DEV] Oracle
client problem via dllhost.exe<BR><BR></FONT></DIV>
<P><FONT size=2>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:</FONT></P>
<P> <FONT
size=2>SQLOLEDB.1</FONT> <BR>
<FONT size=2>MSDAORA.1</FONT>
<BR> <FONT
size=2>OraOLEDB.Oracle.1</FONT> </P>
<P><FONT size=2>when i try to access the object from a .asp page via the
follwoing code:</FONT> <BR>
<BR><FONT size=2> set obj =
Server.CreateObject("MyObject.MyTable")</FONT> <BR><FONT
size=2> set rs = obj.myMethod(params)</FONT> </P>
<P><FONT size=2>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"</FONT></P>
<P><FONT size=2>I messagebox trace my code to the following call:</FONT>
</P>
<P> <FONT
size=2>ds.OpenWithServiceComponents(...);</FONT> </P>
<P><FONT size=2>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"</FONT></P>
<P><FONT size=2>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.</FONT></P>
<P><FONT size=2>does anyone have any insight/solution to my
situation?</FONT> </P>
<P><FONT size=2>thank.</FONT> </P>
<P><FONT size=2>Alan Gamboa</FONT> <BR><FONT size=2>CCG Systems,
inc.</FONT> </P>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>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>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>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_01C27A07.7FB87530--