Hi Everybody!!
I need your suggestion to solve this problem.
error '80004005'
Unspecified error
function.asp, line 188

set obj = server.CreateObject("lstproject.lstclass")
 recordset= obj.RsExec(conn_in,param1,is_Err) //line 188

here conn_in is an Array,that contains session varaibale,sql statement,connection string ,that is used by the dll to execute the sql,and return the recordset.

Why I am getting this error??
Even this is running fine on another Server(local).
Is there any issues concern with registring dll with regsvr32 and MTS??
Again sometimes it still don't run on Other Server.Just play like Hide and Seek :)
Looking for Suggestions and Solutions??
I have search many sites for this ,still looking for Great Solution



Cheers :)

vinod

__________________
Cheers :)

vinod

so you are trying to call a COM object on another server from an asp page, right?

Could be all sorts of things involved here, example:

You mention MTS, is the object running in an MTS/COM+ package on the other server? Did you create a proxy from that other server and install it on your web server?
Check the MTS settings, for example does your asp user have authority to the component?
Do you have firewall or DNS issues communicating from web to other server? What's on the Activation tab of the MTS proxy (if there is one) - machine name or IP address?
Are you trying to pass any objects to/from the method? If so can those objects be marshalled across a machine boundary? (of the ADO objects I believe only a disconnected recordset can be)

error '80004005' is not very nice to diagnose. Do you have any other clues - anything in the event logs on either server? have you run SQL Profiler to see whether the database call is being made?

hth
Phil

hii pgtips!!
Actually ,this "conn_in" is an array that passes values(connectionstring,sql) to the Dll method,and this method returns recordset object.
Ya i have local server that run fine,while with the Client Server,all the setting has been done successfuly,i m wonder why it's giving this error message on his server.
Even i tried this link n looking for possible solution
http://support.microsoft.com/kb/237536/EN-US/

Cheers :)

vinod