Hello ,

When a task is starting, an error code 8004d00a is generated
'The new task caonnot register in the specified task coordinator'
ISQLWorker->Execute

RFSQL Envent ID 10

BTS 2002 on W2k3
SQL 2000 on W2k

Does the Adapter for SQL work on Win 2003 ?
Security / Login/ Identity problem ?

Thank you for your help
Eric

I use the SQL adapter as well but our BTS 2002 is on a Win 2000 machine. You may want to post this to a BTS newsgroup on the MS site as well. I don't know if there is a problem or not with Win 2003 but I wouldn't think there would be.
- Phil

**
thanks,
Phil
**

It's a Win 2003 features
Component services / My computer properties / MSDTC / Security
-> Enable Network DTC access & network transaction

see MS KB329332

Install MSXML 3 for the biztalk adapter for SQL
MSXML 4 does not work

Eric

I am try to use then RFSQLCOM COM Object method "executesql" from xlang to call a stored proc on SqlServer. I am not using a Receive Function "Job". I keep getting a hResult of 80004005 and a return code -2147467259. Object has 4 params: connectionstring,sql,file,rootnode
and returns the rootnode and hResult.
Its seems straight forward to make the call, but im not having any luck. Any feedback would be much appreceiated.-Ben