Method '~' of Object '~' failed Error

I'm facing the error mentioned at this question title.
I have a COM+ component that is called from an ASP page, when I call a method of the component and an error occurs, the error information is not passed to the page. The component try to call Err.Raise with the error description but the page receives that message.

At MSDN there is an article to fix this bug, but it didn't work with me:

http://support.microsoft.com/support/kb/articles/Q264/7/01.ASP

Apparently it has some relation with functions that pass ado recordsets by reference. I don't know how to solve this.
RobertoTYAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
Question placed in PAQ

Computer101
E-E Moderator
0
 
Anthony PerkinsCommented:
It sounds like you do not have the correct ADO version installed on the server.  In other words your COM+ component may be referencing a different version of ADO than what is on the server.

I suspect the error is raised when you create the first ADO object in your COM component.

The solution is to make sure to install the same Mdac_type.exe on the server that was used to develop the COM component (or vice versa).

Hope this helps.
0
 
RobertoTYAuthor Commented:
All the envirorment is at my workstation. The sql server, iis and com+ components.

I don't think it is a MDAC version problem. I've applied sp3 of sql7 and sp2 of win2k and the problem still persists.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Hornet241Commented:
I have had this error before with a Com object(DLL) in Com+ and found that when I remove the DLL from the Com+ application it works flawlessly.  I haven't had the chance to research the problem(I did not write the DLL), but I am pretty sure the DLL was not designed properly for Com+.  

This DLL does not use any Database references and I pass only strings to it and receive a Long value as return.

0
 
Richie_SimonettiIT OperationsCommented:
Sp has nothing to do with!
If you were installed your component through P&DW, do this:
Search on your HD for the same SP that you have installed on Development machine.
There is two files (i am not sure), mdactyp.exe and a cab file with the same name.
Take both and install on server AGAIN.
SP are applied to programs but, for a strange reason, it didn't applies for P&DW.
Good luck
0
 
RobertoTYAuthor Commented:
Richie,
I think you did not read the article i put in my question. Microsoft says that you should apply the last sps for mdac and win2k to solve the problem.

I didnt understand what you meant with P&DW
0
 
mpaul4uCommented:
hi,
THE ANSWER IS THAT the
Check the component IN MTS property+TRANSACTION MODE.
if part of transaction make sure that MSDTC service is started.This is problem with Transactions.
regards
Martin
0
 
Valliappan ANSenior Tech ConsultantCommented:
RobertoTY,

Just check if you have all objects in the database part.

Since, just now, we faced the same error, in SQL 2000, in our VB application. Then found, that tables was missing.

Could it be a similar reason, in your case?

Cheers.
0
 
RobertoTYAuthor Commented:
MSDTC service is already running in my machine. I've tried some test with the service started and running and saw no difference.
0
 
Valliappan ANSenior Tech ConsultantCommented:
RobertoTY,

Did you check with the tables, fields, other objects etc. in your database part?

Try, may be like this, running a specific part of the ado recordset references, in a separate one, and check if you get the same error.
0
 
DanRollinsCommented:
Hi RobertoTY,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:

    Save as PAQ -- No Refund.

EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.