Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Biztalk
|
Biztalk General discussion about Biztalk server.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 22nd, 2003, 01:04 AM
Registered User
 
Join Date: Oct 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Adapter for SQL

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

 
Old October 22nd, 2003, 08:29 AM
Authorized User
 
Join Date: Oct 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
**
 
Old October 23rd, 2003, 04:19 AM
Registered User
 
Join Date: Oct 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old February 25th, 2004, 09:28 AM
Registered User
 
Join Date: Feb 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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







Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL table Adapter kalas Visual Basic 2005 Basics 5 September 18th, 2008 04:21 AM
using two-way sql adapter to insert into 2 tables? shazza Biztalk 0 May 14th, 2007 01:18 PM
BTS 2002 Adapter for SQL issue pjconrad Biztalk 1 July 23rd, 2004 10:07 AM
Sql statements in data adapter Raif ASP.NET 1.0 and 1.1 Basics 1 July 14th, 2004 08:50 AM
SQL Data Adapter jbenson001 ASP.NET 1.x and 2.0 Application Design 6 December 18th, 2003 12:13 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.