I went into the debugger and the dataset.update() method=20
is throwing the OleDb.DbException ...

What is curious is that the data is reflected in the=20
database and the same method=20
(ABCDService.LogABCDTransaction) when called from the=20
checkout.aspx instead of from the pipeline component does=20
not behave like this...

Even in the pipeline, this error is returned the SECOND=20
time around...

>-----Original Message-----
>Let me explain the scenario..
>
>Created a custom resource (.Net Component) called=20
>ABCDService which uses ADO.Net with oleDb resources to=20
do=20
>read and writes to the database.
>
>This custom resource is instantiated using a custom=20
>commerce module CommerceABCDModule...
>
>There are two pipeline components...
> 1. ComputeABCDPoints - this component calculates values=20
>based on the user_id and order totals and stores them=20
>into the basket.
>
> 2. RecordABCDPoints - this component reads the values=20
>previously created and writes them into the database.
>
>Both these pipeline components are registered for COM=20
>Interop and registered for the "Accept" stage.
>
>Within the ABCDService, the required resource tables are=20
>loaded into a DataSet during the Initialise phase. the=20
>second component RecordABCDPoints is calling a=20
>method "LogABCDTransaction" which is adding a record to=20
>one of the tables in the DataSet and calls=20
>DataSet.AcceptChanges() on successfull write.
>
>Both these components are part of the checkout pipeline=20
>which runs in a transacted mode.
>
>The Custom Commerce Module, the pipeline components, the=20
>ABCD Service class are all part of one project which is=20
>registered for COM Interop and loaded using regasm /tlb:=20
>and gacutil /i...
>
>The Pipeline Components have a GUID attribute defined.
>
>The ABCDService is NOT a serviced component.
>
>Does this help you ?
>
>Regards.
> 
>the internals of your=20 
chance? =20[vbcol=seagreen]
>Generally you do=20 
>themselves are=20 
>settings of the=20 
>site using=20 
>PooledPipeline, which may=20 
>as poolable (marked=20 
>pipeline that it meets the=20 
>what line of code=20 
>your component the=20 
and=20[vbcol=seagreen]
>confers no rights. 
>Corporation.  All rights 
>(0x80004002). 
>microsoft.public.commerceserver.general:14178 
>The=20 
>.
>

[ Post a follow-up to this message ]