(* Sorry about my english , I am from Israel *)

I admit it , I cant handle it anymotre , If you wont help i will die.

Please take a loot on this code:

Public Function DeleteCustomer(strCustomerID As String) As Boolean

some code against DB

end function


WOOHOO! its works fine (100% fine - even after i compile the client to exe and the Middle Tier to dll.

but This code isnt working for me!:


Public Function DeleteCustomer(strCustomerID As String) As Boolean

on error goto ErrHandler
Dim objContext As ObjectContext
Set objContext = GetObjectContext

some code against DB

objContext.SetComplete

exit function
ErrHandler:

objContext.SetAbort

end function


Thats it. just added some simple MTS code , i changed the MTStransactionMode
property to 2 (requeird trans) and i made a ref for the COM+ (i am working with win2k but its the same at NT 4 (right?)


After i recomplie both exe and dll and run it again , the SAME code not working for me!!
i got error msg: object variable do not set , but this is not the reason...

PLEASE any idea whats the porblem will help a lot,
I wait for your reply!!

Thanks!
Namo.