Re: Oracle client problem via dllhost.exe
"DeRemer, Bob" <[email protected]> Tue, 22 Oct 2002 04:02:29 -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_01C279BA.832EDE40
Content-Type: text/plain;
charset="iso-8859-1"
Sorry. I inferred that from the ASP statement. In any case, what Bob
Beauchemin mentioned is in line with what I was thinking (i.e. run under a
an account that has proper privilege - in this case, try yourself to test it
out). Hope this helps.
-bob
-----Original Message-----
From: Alan Gamboa [mailto:[email protected]]
Sent: Tuesday, October 22, 2002 12:06 AM
To: [email protected]
Subject: Re: Oracle client problem via dllhost.exe
bob,
thanks for the info, but i am not running any managed code at this time.
-Alan
-----Original Message-----
From: DeRemer, Bob
To: 'Alan Gamboa '
Sent: 10/21/02 7:29 PM
Subject: RE: Oracle client problem via dllhost.exe
From my experience, I have seen problems when trying to do various tasks
[running under ASP.NET] that require some form of authentication
[because the IWAM account is meaningless off machine]. By changing the
user account that the aspnet_wp.exe process runs under, I was able to
fix most problems. Specifically, by setting the value in the ASP.NET
web.config file, you should be able test this out.
-bob
-----Original Message-----
From: Alan Gamboa
To: [email protected]
Sent: 10/21/02 3:23 PM
Subject: 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 <http://discuss.develop.com> <
http://discuss.develop.com <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_01C279BA.832EDE40
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>RE: Oracle client problem via dllhost.exe</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=256210011-22102002><FONT face=Arial color=#0000ff
size=2>Sorry. I inferred that from the ASP statement. In any case,
what Bob Beauchemin mentioned is in line with what I was thinking (i.e. run
under a an account that has proper privilege - in this case, try yourself to
test it out). Hope this helps.</FONT></SPAN></DIV>
<DIV><SPAN class=256210011-22102002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=256210011-22102002><FONT face=Arial color=#0000ff
size=2>-bob</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, October 22, 2002 12:06
AM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> Re: Oracle
client problem via dllhost.exe<BR><BR></FONT></DIV>
<P><FONT size=2>bob,</FONT> </P>
<P><FONT size=2>thanks for the info, but i am not running any managed code at
this time.</FONT> </P>
<P><FONT size=2>-Alan</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
DeRemer, Bob</FONT> <BR><FONT size=2>To: 'Alan Gamboa '</FONT> <BR><FONT
size=2>Sent: 10/21/02 7:29 PM</FONT> <BR><FONT size=2>Subject: RE: Oracle
client problem via dllhost.exe</FONT> </P>
<P><FONT size=2>From my experience, I have seen problems when trying to do
various tasks</FONT> <BR><FONT size=2>[running under ASP.NET] that require
some form of authentication</FONT> <BR><FONT size=2>[because the IWAM account
is meaningless off machine]. By changing the</FONT> <BR><FONT
size=2>user account that the aspnet_wp.exe process runs under, I was able
to</FONT> <BR><FONT size=2>fix most problems. Specifically, by setting
the value in the ASP.NET</FONT> <BR><FONT size=2>web.config file, you should
be able test this out.</FONT> </P>
<P><FONT size=2>-bob </FONT></P>
<P><FONT size=2>-----Original Message----- </FONT><BR><FONT size=2>From: Alan
Gamboa </FONT><BR><FONT size=2>To: [email protected]
</FONT><BR><FONT size=2>Sent: 10/21/02 3:23 PM </FONT><BR><FONT
size=2>Subject: Oracle client problem via dllhost.exe </FONT></P>
<P><FONT size=2>I have a COM object that uses OLEDB to access either an Oracle
or MS Sql</FONT> </P>
<P><FONT size=2>database. Using a C++ testclient w/ smart pointers to my
object, </FONT><BR><FONT size=2>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> </P><BR>
<P><FONT size=2> </FONT><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 </FONT><BR><FONT size=2>provider I get a pop window asking me if i want
to send the error to </FONT><BR><FONT size=2>Microsoft, the basic message is
"COM Surrogate has encountered a problem</FONT> </P>
<P><FONT size=2>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,</FONT> </P>
<P><FONT size=2>I don't even get the pleasure of an E_FAIL as a returned
HRESULT. The </FONT><BR><FONT size=2>code is wrapped in the try/catch
block and never gets a chance to </FONT><BR><FONT size=2>"catch" </FONT></P>
<P><FONT size=2>the biggest difference that i can see is that the c++
testclient is </FONT><BR><FONT size=2>using my security credentials where as
the .asp page is entering via </FONT><BR><FONT size=2>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>
<P><FONT size=2>You can read messages from the OLEDB_DEV archive, unsubscribe
from </FONT><BR><FONT size=2>OLEDB_DEV, or subscribe to other DevelopMentor
lists at </FONT><BR><FONT size=2><A href="http://discuss.develop.com"
target=_blank>http://discuss.develop.com</A> <<A
href="http://discuss.develop.com"
target=_blank>http://discuss.develop.com</A>> . </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></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_01C279BA.832EDE40--