|
Subject:
|
Adapter for SQL
|
|
Posted By:
|
erisa
|
Post Date:
|
10/22/2003 1:04:55 AM
|
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
|
|
Reply By:
|
pjconrad
|
Reply Date:
|
10/22/2003 8:29:12 AM
|
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
**
|
|
Reply By:
|
erisa
|
Reply Date:
|
10/23/2003 4:19:01 AM
|
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
|
|
Reply By:
|
benlorenzo
|
Reply Date:
|
2/25/2004 8:28:03 AM
|
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
|
