Hello. I'm quite new to COM+, but I have managed to make a Component which 

returns calculated values to an ASP page. However, when I added 

functionality to connect to SQL Server using ADO, IIS reports a 

Catastrophic Failure.



I have read somewhere that the component is supposed to be transactional 

to avoid such a problem and I think I have set it up to be. These are my 

COM+ settings, can anyone tell me what I am doing wrong....?



Transactions: Required

Security: Perform at Process and Component Level, Authentication=None, 

Impersonate, Enforce Component Level Access Checks

Activation: Server

Queueing: (Nothing selected)

Advanced: (Nothing Selected)

Activation: Just-in-time, Component Supports Events and Statistics





Here is the Delphi function that is failing:

--------------------------------------------

procedure TTestCOMplus1.LogDateTime;

begin

     TransDataModule.SP_LogDateTime.ExecProc;

     getobjectcontext().SetComplete;

     EnableCommit;

end;





Here is the ASP VBscript code that calls it:

--------------------------------------------

Dim objCOMtest2

Set objCOMtest2 = CreateObject("ComPlusTest2", "\\servername")

objCOMtest2.LogDateTime