Forum Replies Created
-
Posts
-
As a teacher, I always taught that the things in the Visual Studio Reference List were those things in the GAC.
You mean of course when you right click \”add reference\”, then the leftmost tab called \”.NET\”.
But I later learned that putting in the GAC is not enough. There is also a registry entry (or something else that registers it).
Neal Walters
http://Biztalk-Training.comAlso check http://Topxml.com. I think they have a reasonably priced alternative.
Neal Walters
http://Biztalk-Training.comYou can send the entire XML to the stored procedure, then parse it in the stored proc using \”OpenXML\” (which basically parses the string into an XML Document object and then uses the xpath inside the stored proc to process it). Just do a google search or SQL Books Online on \”OpenXML\” to learn more. We actually used it for the first time about two months ago.
Neal Waltes
I dont’ know how I missed it, maybe because it wasn’t a \”schemas\” directory.
I just put my own schema in this directory:
c:\\Program Files\\Microsoft BizTalk Server 2004\\Developer Tools\\BizTalkProjectItems
It works like a charm.
Neal Walters
http://Biztalk-Training.comThe best place is probably Microsoft’s website: http://www.microsoft.com/biztalk/default.mspx
I have seen power points for 2004 on the site at one point plus a 20 minute video. I’m not sure if they have that for 2006 as well.
Microsoft has a Partner Toolkit that I think has some nice info. But, not sure how you could get a copy of that.
Hope this helps.
Check out the ScheduledTask adapter on GotDotNet:
[url]http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=E473FC93-5081-44C7-A9C9-84BF4E783728[/url]This will enable you to do the error check once per day.
The core of Biztalk is the messagebox, receive ports and orchestrations publish messages into the messagebox and send ports and orchestrations subscribe to messages from the messagebox.
If you publish a message to the messagebox with no enlisted subscriber then you will get this error.
You can view the active subscriptions using the Biztalk admin console:
[url]http://geekswithblogs.net/sthomas/archive/2005/10/03/55872.aspx[/url]A subscription is basically a filter on promoted context properties.
For straight thru processing you declare a receive port and a send port. The send port will have the a filter of BTS.ReceivePortName = [i:dc6d4ac4c9]receive port name[/i:dc6d4ac4c9]. So it will subscribe to all messages coming from the named receive port.A send port without a filter has no subscription – although if bound to an orchestration the subscription is created when the orchestration is enlisted.
Check your message context properties and see if they match any of the subscriptions
I appreciate the effort and really like the site. lots of good info here !
While its true true that I can write the same code as gets put in the odx file its not dynamic until I can make the orchestration name a variable 🙂
I’ll check back here occasionaly to see if anyone figues this one out
Tim
Thanks Stephen,
I renamed teh .dll file and tried building it, it worked. For some reason some process was suing that file. Later I deleted teh renamed file.
Thankshi acarr260, i’m also in the beta 2 program of Biztalk 2006, as far as i know HWS is more or less the same as in BTS 2004, as it states that this feature will be removed in the next release of BTS.
Can it be that your friend mean the Windows Workflow Foundation that will replace HWS in the future?
About the K2 product, I’ve been tolded from some colleagues as well the same story about HW, so hope it will come a new version for BTS 2006 with some good new features.
Visual Studio 2005 JACKS UP BizTalk 2004. Don’t even install it or SQL 2005 on a vital development box unless you want trouble. I suggest setting all that up on Virtual PC until MS gets it BizTalk to play nice with Visual Studio 2005. My company issued ticket with them today, finally.
You won’t be able to use the Web Service Publishing Wizard anymore, and the SQL adapter will give you MSDTC errors when trying to generate schemas for stored procedures or updategrams. Beware…
That being said, BizTalk 2006 Beta works well and VS 2005 is sweet, but keep them seperate if you make your money building BizTalk solutions.
Good luck
Hello,
You can loop/iterate through nodes in an XML message using the loop shape in BizTalk. You just need to supply the XPATH statement that will isolate the nodes to loop through. You could call your stored procedures on each node. I think it would probably help to promote the values you are looking for or use the mapper when creating the message used to call the stored procedure.I would personally recommend either using updategrams or perhaps OPENXML. I have found that a combination of OPENXML in my stored procedures and \”FOR XML AUTO\” select statements can give you more flexibility than updategrams. Good luck
There is a stand alone version of the biztalk explorer than can operate without visual studio. I think this is the link to the one I use.
http://www.gotdotnet.com/workspaces/workspace.aspx?id=992ca223-553c-475a-ac87-da7ae2c9016a
Anyway, here is a link to some other fun BTS 2004 tools.
Both Attunity (http://www.attunity.com/biztalk/index.html) and WRQ (http://www.attachmate.com/en-US/Partners/BizTalk+Server) offer DB2 adapters. I have no clue how much the cost.
I have not worked with either one myself though.
