Re: Oracle client problem via dllhost.exe
Alan Gamboa <[email protected]> Tue, 22 Oct 2002 00:06:19 -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_01C27980.5FFE4F30
Content-Type: text/plain;
charset="iso-8859-1"
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> .
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_01C27980.5FFE4F30
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: Oracle client problem via dllhost.exe</TITLE>
</HEAD>
<BODY>
<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>
</BODY>
You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.
</HTML>
------_=_NextPart_001_01C27980.5FFE4F30--