Oracle client problem via dllhost.exe
Alan Gamboa <[email protected]> Mon, 21 Oct 2002 18:23:16 -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_01C27950.77271370
Content-Type: text/plain;
charset="iso-8859-1"
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.
------_=_NextPart_001_01C27950.77271370
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>Oracle client problem via dllhost.exe</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>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=3D2>SQLOLEDB.1</FONT>
<BR> <FONT =
SIZE=3D2>MSDAORA.1</FONT>
<BR> <FONT =
SIZE=3D2>OraOLEDB.Oracle.1</FONT>
</P>
<P><FONT SIZE=3D2>when i try to access the object from a .asp page via =
the follwoing code:</FONT>
<BR> =20
<BR><FONT SIZE=3D2> set obj =3D =
Server.CreateObject("MyObject.MyTable")</FONT>
<BR><FONT 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 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=3D2>I messagebox trace my code to the following =
call:</FONT>
</P>
<P> <FONT =
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 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=3D2>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=3D2>does anyone have any insight/solution to my =
situation?</FONT>
</P>
<P><FONT SIZE=3D2>thank.</FONT>
</P>
<P><FONT SIZE=3D2>Alan Gamboa</FONT>
<BR><FONT SIZE=3D2>CCG Systems, inc.</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_01C27950.77271370--