"Method '~' of object '~' failed" error

Hi,
I'm using ADO.NET command to execute a stored procedure which will do a
bounch of deletes and inserts on database side. If the data is not too big,
it's fine, but if there is a lot of data needs to be proceeded, sometime I
got error of "Method '~' of object '~' failed", sometime I got "Import of
MSDTC transaction failed: Result Code = 0x8004d00e." as well. When I ran the
stored procedure manually with same parameters, no any problems.
What could be the problem?

Thanks.

william

Sahil
Mon Jan 03 22:13:59 CST 2005

Sounds like an error coming from the OLEDB layer .. what data provider are
you using? ODBC/OLEDB by any chance?

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik


"william" <william@discussions.microsoft.com> wrote in message
news:2A29495C-2DC3-4732-A58A-9124E46EF000@microsoft.com...
> Hi,
> I'm using ADO.NET command to execute a stored procedure which will do a
> bounch of deletes and inserts on database side. If the data is not too
> big,
> it's fine, but if there is a lot of data needs to be proceeded, sometime I
> got error of "Method '~' of object '~' failed", sometime I got "Import of
> MSDTC transaction failed: Result Code = 0x8004d00e." as well. When I ran
> the
> stored procedure manually with same parameters, no any problems.
> What could be the problem?
>
> Thanks.
>
> william
>
>
>

william
Tue Jan 04 09:51:02 CST 2005

I used SQLClient.
Thanks.

william

"Sahil Malik" wrote:

> Sounds like an error coming from the OLEDB layer .. what data provider are
> you using? ODBC/OLEDB by any chance?
>
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
>
>
> "william" <william@discussions.microsoft.com> wrote in message
> news:2A29495C-2DC3-4732-A58A-9124E46EF000@microsoft.com...
> > Hi,
> > I'm using ADO.NET command to execute a stored procedure which will do a
> > bounch of deletes and inserts on database side. If the data is not too
> > big,
> > it's fine, but if there is a lot of data needs to be proceeded, sometime I
> > got error of "Method '~' of object '~' failed", sometime I got "Import of
> > MSDTC transaction failed: Result Code = 0x8004d00e." as well. When I ran
> > the
> > stored procedure manually with same parameters, no any problems.
> > What could be the problem?
> >
> > Thanks.
> >
> > william
> >
> >
> >
>
>
>

Miha
Tue Jan 04 10:04:50 CST 2005

Is this a COM+ based application?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"william" <william@discussions.microsoft.com> wrote in message
news:2A29495C-2DC3-4732-A58A-9124E46EF000@microsoft.com...
> Hi,
> I'm using ADO.NET command to execute a stored procedure which will do a
> bounch of deletes and inserts on database side. If the data is not too
> big,
> it's fine, but if there is a lot of data needs to be proceeded, sometime I
> got error of "Method '~' of object '~' failed", sometime I got "Import of
> MSDTC transaction failed: Result Code = 0x8004d00e." as well. When I ran
> the
> stored procedure manually with same parameters, no any problems.
> What could be the problem?
>
> Thanks.
>
> william
>
>
>

william
Thu Jan 06 08:03:03 CST 2005

Yes.
I have a COM+ which is used to access database(execute stored procedure),
other applications use this COM+ to call a stored procedure.
Thanks.

william


"Miha Markic [MVP C#]" wrote:

> Is this a COM+ based application?
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> SLODUG - Slovene Developer Users Group
> www.rthand.com
>
> "william" <william@discussions.microsoft.com> wrote in message
> news:2A29495C-2DC3-4732-A58A-9124E46EF000@microsoft.com...
> > Hi,
> > I'm using ADO.NET command to execute a stored procedure which will do a
> > bounch of deletes and inserts on database side. If the data is not too
> > big,
> > it's fine, but if there is a lot of data needs to be proceeded, sometime I
> > got error of "Method '~' of object '~' failed", sometime I got "Import of
> > MSDTC transaction failed: Result Code = 0x8004d00e." as well. When I ran
> > the
> > stored procedure manually with same parameters, no any problems.
> > What could be the problem?
> >
> > Thanks.
> >
> > william
> >
> >
> >
>
>
>