Biztalk Adapters

1101 of 1205 | News: Workbench lets guitarists customize Variax guitars - You already have a Variax guitar, which lets you instantly model more than two dozen different classic guitars. But what happens if you want more On Wednesday Line 6 announced Variax Workbench, a combination of USB adapter and software that offers Variax guitarists a "virtual custom shop" to enable them to design their own custom guitars using Line 6`s Variax 300, 500 or 700 models....

1102 of 1205 | BizTalk and Hyper-Threaded Processors - This great new article from the BizTalk Performance Blog has reminded me of a potentially nasty issue when you have Hyper-Threading enabled processors on your BizTalk box. BizTalk comes out of the box with some default performance tuning settings which seem to work well on the whole, you can see these in the adm_ServiceClass table of the BizTalkMgmtDb, you might need to adjust these during your performance tuning the normal disclaimers apply!   They are all documented in the Performance Characteristics paper Ive pulled out some of the key ones that I tend to adjust during scale and perf exercises: Name Low Watermark High Watermark Low Sessionmark High Sessionmark XLANG/s (Orches......

1103 of 1205 | BizTalk and Hyper-Threaded Processors - This great new article from the BizTalk Performance Blog has reminded me of a potentially nasty issue when you have Hyper-Threading enabled processors on your BizTalk box. BizTalk comes out of the box with some default performance tuning settings which seem to work well on the whole, you can see these in the adm_ServiceClass table of the BizTalkMgmtDb, you might need to adjust these during your performance tuning the normal disclaimers apply!   They are all documented in the Performance Characteristics paper Ive pulled out some of the key ones that I tend to adjust during scale and perf exercises: Name Low Watermark High Watermark Low Sessionmark High Sessionmark XLANG/s (Orches......

1104 of 1205 | Memory Growth in BizTalk Messaging - By Kartik Paramasivam and Raied Malhas In this document we list various reasons that might lead BizTalk to get into an Out Of Memory situation and then suggest mitigations/solutions for such conditions. 1.  Introduction to BizTalk Hosts: Before discussing Out of Memory conditions, let us talk about hosts and how adapters are mapped to hosts. Adapters (receive and send) and orchestrations run under the BizTalk NT Service.   An instance of the BizTalk NT Service is called a host instance. There can also be receive adapters (HTTP/SOAP) which can run under in any other process (e.g. IIS) instead of the BizTalk NT Service. Such adapters are called isolated adapters. Hosts in BizTalk have 1 or mo......

1105 of 1205 | Memory Growth in BizTalk Messaging - By Kartik Paramasivam and Raied Malhas In this document we list various reasons that might lead BizTalk to get into an Out Of Memory situation and then suggest mitigations/solutions for such conditions. 1.  Introduction to BizTalk Hosts: Before discussing Out of Memory conditions, let us talk about hosts and how adapters are mapped to hosts. Adapters (receive and send) and orchestrations run under the BizTalk NT Service.   An instance of the BizTalk NT Service is called a host instance. There can also be receive adapters (HTTP/SOAP) which can run under in any other process (e.g. IIS) instead of the BizTalk NT Service. Such adapters are called isolated adapters. Hosts in BizTalk have 1 or mo......

1106 of 1205 | Memory Growth in BizTalk Messaging - By Kartik Paramasivam and Raied Malhas In this document we list various reasons that might lead BizTalk to get into an Out Of Memory situation and then suggest mitigations/solutions for such conditions. 1.  Introduction to BizTalk Hosts: Before discussing Out of Memory conditions, let us talk about hosts and how adapters are mapped to hosts. Adapters (receive and send) and orchestrations run under the BizTalk NT Service.   An instance of the BizTalk NT Service is called a host instance. There can also be receive adapters (HTTP/SOAP) which can run under in any other process (e.g. IIS) instead of the BizTalk NT Service. Such adapters are called isolated adapters. Hosts in BizTalk have 1 or mo......

1107 of 1205 | Why I`m falling in love with BizTalk - The top 5 reasons why I`m falling in love with BizTalk:BizTalk == XML messaging. BizTalk is the onlyshipping Microsoft technologythat is truly built on an XML messaging foundationthrough and through.Even its internal publish/subscribe architecture is built on this foundation. The entire experience revolves around the transmission, processing, and translation of XML messages, resulting in powerful flexibility and simplified integration opportunities.BizTalk == multi-transport. Despite the hype surrounding SOA and Web services, BizTalk is a technology grounded in reality. It realizes that enterprises don`t have the luxury of throwing away existing investments (in order to republish them via W......

1108 of 1205 | New Blog - BizTalk Server Performance & Stress Team! - Hey check out the new action from the BizTalk Server Performance & Stress Team! http://blogs.msdn.com/biztalkperformance/ The first blog dives into understanding the throughput and capacity of BizTalk Server 2004 SP1 and how to monitor and observe your system behavior.  Looks like they plan to provide a host of entries on optimizing, tracking, adapter performance details, host configuration, and lots more!...

1109 of 1205 | Understanding BizTalk Server 2004 SP1 Throughput and Capacity - By Wayne Clark What is Sustainable Of primary concern when planning, designing, and testing business solutions built on BizTalk Server 2004 SP1 is that the solutions must be able to handle the expected load and meet required service levels over an indefinite period of time.  Given the number of solution architectures, configurations, and topologies possible on BizTalk Server 2004 SP1, there are many things to consider when evaluating a proposed or existing deployment.  The purpose of this, our inaugural BizTalk Performance blog posting, is to provide guidance on: Understanding BizTalk Server SP1 throughput and backlog capacity behavior and how to observe the behavior of your system. Cri......

1110 of 1205 | Understanding BizTalk Server 2004 SP1 Throughput and Capacity - By Wayne Clark What is Sustainable Of primary concern when planning, designing, and testing business solutions built on BizTalk Server 2004 SP1 is that the solutions must be able to handle the expected load and meet required service levels over an indefinite period of time.  Given the number of solution architectures, configurations, and topologies possible on BizTalk Server 2004 SP1, there are many things to consider when evaluating a proposed or existing deployment.  The purpose of this, our inaugural BizTalk Performance blog posting, is to provide guidance on: Understanding BizTalk Server SP1 throughput and backlog capacity behavior and how to observe the behavior of your system. Cri......

1111 of 1205 | Understanding BizTalk Server 2004 SP1 Throughput and Capacity - By Wayne Clark What is Sustainable Of primary concern when planning, designing, and testing business solutions built on BizTalk Server 2004 SP1 is that the solutions must be able to handle the expected load and meet required service levels over an indefinite period of time.  Given the number of solution architectures, configurations, and topologies possible on BizTalk Server 2004 SP1, there are many things to consider when evaluating a proposed or existing deployment.  The purpose of this, our inaugural BizTalk Performance blog posting, is to provide guidance on: Understanding BizTalk Server SP1 throughput and backlog capacity behavior and how to observe the behavior of your system. Cri......

1112 of 1205 | 5 New BizTalk White Papers Including Convoy Deep Dive - Microsoft has released 5 new White Papers today in a “Beta” mode.  Full details on all 5 are available here.    They include the following: - BizTalk  Server 2004 Web Services (Brian Loesgen) - BizTalk Server Internal Workings (Internal) - SQL Adapter Deep Dive (Todd Uhl) - Convoy Deep Dive (Stephen W. Thomas) - Extending BizTalk Server with Host Integration Server (Jon Fancy)   They all look like great reading.  I’m rather fond of the Convoy Deep Dive paper myself.    As always, feedback is welcome....

1113 of 1205 | I`m still alive! 5 New Whitepapers for Community Review - Its been a while, and I`ve been working on multiple exciting projects - mostly NDA -  as well as directly managing 7 people so life is entertaining and there is lots of innovation going on in BizTalk land.  No doubt we will have a bunch of interesting things to talk about at TechEd and PDC later in the year.  Below are 5 new whitepapers on various aspects of the product.  I`d like to personally thank all the whitepaper authors below.  These papers are still "beta" so feel free to provide feedback in the comments and we will address what is required.  The whitepapers are hosted in the msn group biztalkserverstuff as my personal web space just ran out of quota... BizTalk Server 2004 Web Servi......

1114 of 1205 | Some MSMQ properties doesn`t work - I was playing around with the new MSMQ Adapter for BizTalk Server 2004 and saw a strange thing. I want to use a property MSMQ.SourceMachine, its handy when u want to drop a response massage on the same machine. What I saw in the Message Context that this property wasn`t there. Strange Anyone got a idea ...

1115 of 1205 | Some MSMQ properties doesn`t work - I was playing around with the new MSMQ Adapter for BizTalk Server 2004 and saw a strange thing. I want to use a property MSMQ.SourceMachine, its handy when u want to drop a response massage on the same machine. What I saw in the Message Context that this property wasn`t there. Strange Anyone got a idea ...

1116 of 1205 | Large Messages Causing Large Problems in BizTalk Server 2004 - Recently I have seen a lot of talk about large message support in BizTalk 2004.  The most interesting and depressing was on the BizTalk Core Engine WebLog.  It seems that large messages do not work as well in BizTalk 2004 as I would have hoped.   I have had success with some types of large messages using the file adapter and mapping.  I have gotten it to work with messages up to 500 MB but in a production environment this would not be a viable or supported solution.    During some recent testing, I discovered the follow condition that rather surprised me.   Scenario I was returning an unpredictable amount of data out of an Oracle database using .net code.  This data can be 1 MB or up to ......

1117 of 1205 | WiebeTech offers new Combo Adapters - WiebeTech LLC on Tuesday introduced new Combo Adapters, designed to work with WiebeTech's ComboDock. The two devices let IT personnel, forensic investigators, techs and others mount a wide variety of hard drives on their computers....

1118 of 1205 | Bug in Setup BizTalk Server 2004 Adapter for MSMQ v2.0 - At one of my customers I use the new BizTalk 2004 MSMQ Adapter. I read this Adapter is much beter in performance then the Out-of-the-Box MSMQT Adapter therefor I want to use this new Adapter. You can download the Adapter here After the installation of the Adapter I wanted to send messages to a Private MSMQ. I get the following error : The Messaging Engine failed to create the receive adapter "MSMQ".Reason: "File or assembly nameMicrosoft.Samples.BizTalk.Adapters.MSMQC.Runtime.dll, or one of itsdependencies, was not found.". Microsoft Comment : This is a bug, and here is the solution.(1) Open your Adm_Adapter table in BizTalkMgmtDB database that your Biztalk server is using.(2) Identify th......

1119 of 1205 | Bug in Setup BizTalk Server 2004 Adapter for MSMQ v2.0 - At one of my customers I use the new BizTalk 2004 MSMQ Adapter. I read this Adapter is much beter in performance then the Out-of-the-Box MSMQT Adapter therefor I want to use this new Adapter. You can download the Adapter here After the installation of the Adapter I wanted to send messages to a Private MSMQ. I get the following error : The Messaging Engine failed to create the receive adapter "MSMQ".Reason: "File or assembly nameMicrosoft.Samples.BizTalk.Adapters.MSMQC.Runtime.dll, or one of itsdependencies, was not found.". Microsoft Comment : This is a bug, and here is the solution.(1) Open your Adm_Adapter table in BizTalkMgmtDB database that your Biztalk server is using.(2) Identify th......

1120 of 1205 | Service Orientation, the Hype Cycle, and a RESTaurant - Edd Dumbill has a funny retrospective on the SOA hype: 2005 Will Be the Year of SOA -- Are You Ready (.NET Developer`s Journal) 2004: The year of the SOA (ZapThink, searchwebservices.com) Predicts 2003: SOA Comes of Age via Web Services (Gartner) Bowstreet Predicts 2002 Will Be The `Year of Web Services` (Bowstreet press release) I remember having a bit of a tiff with someone from ZapThink about the time that "2004: The year of the SOA" piece came out: Looking back on the OO "revolution" of 15 years or so ago, what would one think of a 1990 analyst report that pointed to a window of opportunity that would be closed by 1992 as C++ and CORBA mature and standardize That`s about where the......

1121 of 1205 | Service Orientation, the Hype Cycle, and a RESTaurant - Edd Dumbill has a funny retrospective on the SOA hype: 2005 Will Be the Year of SOA -- Are You Ready (.NET Developer`s Journal) 2004: The year of the SOA (ZapThink, searchwebservices.com) Predicts 2003: SOA Comes of Age via Web Services (Gartner) Bowstreet Predicts 2002 Will Be The `Year of Web Services` (Bowstreet press release) I remember having a bit of a tiff with someone from ZapThink about the time that "2004: The year of the SOA" piece came out: Looking back on the OO "revolution" of 15 years or so ago, what would one think of a 1990 analyst report that pointed to a window of opportunity that would be closed by 1992 as C++ and CORBA mature and standardize That`s about where the......

1122 of 1205 | BizTalk Static Oracle Adapter Sample - The Microsoft BizTalk Server 2004 Adapter for oracle uses ADO.NET. The idea is developing an easy to use efficient adapter that connects modern SOA based applications to Oracle databases, the adapter supports Oracle version 8.0i and later. Goals: Developing an adapter capable of - Transmitting messages to Oracle database - Receiving messages from Oracle database - Dynamic Schema Generation - Executing Oracle o Functions o Stored Procedures o Statements. - handling the extreme differences between Oracle data types and CLR data types. Very cool stuff developed in the land of the Sphinx and recently posted to gotdotnet.  Big thanks to Khaled M. Hnidk of Link.NET....

1123 of 1205 | Invalidating cached result sets using SQL Server Query Notification - Anyone who has written a web application has probably experienced the cost of doing a database round trip for fetching a result set everytime a web user loads a page. In fact, handling a page request may involve more than one queries (imagine 20 drop-down boxes, each of which must be populated). A fix to this problem is caching frequently requested result sets in memory to avoid the database round trip. The cache can be invalidated periodically get a  more recent version of the actual data. This technique seems to work fine if the data is not updated frequently and the application does not really need the result sets to be fresh. What would be ideal in this case is for the database to noti......

1124 of 1205 | Invalidating cached result sets using SQL Server Query Notification - Anyone who has written a web application has probably experienced the cost of doing a database round trip for fetching a result set everytime a web user loads a page. In fact, handling a page request may involve more than one queries (imagine 20 drop-down boxes, each of which must be populated). A fix to this problem is caching frequently requested result sets in memory to avoid the database round trip. The cache can be invalidated periodically get a  more recent version of the actual data. This technique seems to work fine if the data is not updated frequently and the application does not really need the result sets to be fresh. What would be ideal in this case is for the database to noti......

1125 of 1205 | MSMQ Adapter Notes - Steve and I wound up working on the same problem at the same time (probably for the same person…)   When working with the MSMQ adapter, keep in mind that you must reference the Microsoft.BizTalk.Adapter.MSMQ.MsmqAdapterProperties.dll to have access to MSMQ-specific properties.  (The list of properties available is in the adapter documentation.)   Why The intellisense in the expression shape (when using the parentheses syntax on messages, ports, etc.) is looking for classes derived from Microsoft.XLANGs.BaseTypes.PropertyBase to present in the drop down list.  Some of those classes are part of your "native" BizTalk installation, some are provide......

1126 of 1205 | MSMQ Adapter Notes - Steve and I wound up working on the same problem at the same time (probably for the same person…) When working with the MSMQ adapter, keep in mind that you must reference the Microsoft.BizTalk.Adapter.MSMQ.MsmqAdapterProperties.dll to have access to MSMQ-specific properties.  (The list of properties available is in the adapter documentation.) Why? The intellisense in the expression shape (when using the parentheses syntax on messages, ports, etc.) is looking for classes derived from Microsoft.XLANGs.BaseTypes.PropertyBase to present in the drop down list.  Some of those classes are part of your "native" BizTalk installation, some are provided by add-on ad......

1127 of 1205 | BizTalk MSMQ Adapter and the MsmqAdapterProperties.dll - I have been working on an application which needs to send a message to a queue in which the queue location was contained in the incoming XML Message.  This was simple as you can just set the send port binding to Dynamic and provide the address through a distinguished field using an expression shape and the following code; MSMQSend(Microsoft.XLANGs.BaseTypes.Address) = ;.  The address needs to be in the following syntax; "MSMQ://FORMATNAME:DIRECT=OS:MachineName/Private$/QueueName.   The difficult part came into play when I then needed to set a label on the outgoing message as well as set the queue transaction property to true (which by default is false).   When I looked at all of the propert......

1128 of 1205 | Nice article by Jess on BizTalk Adapter for MQSeries - Check it out here. This article covers how to use the BizTalk Adapter for MQSeries v2.0 with the WebSphere MQ transport for SOAP to invoke web service operations using MQSeries as transport protocol. ...

1129 of 1205 | Get BizTalk 2004 SP1 Installed! - If you havent already done so please consider moving your development and live servers to BizTalk Server 2004 SP1 wherever possible. It does really make a difference to common scenarios; it helped us out in the Scalability Lab recently with regard to SQL Server deadlocking under high load and also fixes a tricky bug whereby if your were using the SOAP adapter via dynamic ports you were prevented from moving the Adapter into another host to avoid the thread starvation problems. It also introduced a few new handy performance counters as listed in the Readme (which we all read dont we J), most notable are the new counters for the Messaging engine giving you a bit more view into the plumbing.......

1130 of 1205 | Handy BizTalk Service WMI Scripts - Im a nightmare for actually getting around to writing scripts to save me time; I have a list as long as my arm J    This script is dead simple and largely based on samples from Script Center, which if you havent seen it is a goldmine of scripts for virtually any Windows task you can imagine and is great for forming the basis of scripts. This script is particularly useful when you have a farm of BizTalk servers and want to reset them prior to starting a performance test for example, the script will also handle stopping any extra BizTalk hosts you may have deployed (to host Adapters, etc.) The script could of course take command line parameters and be prettier but theyre functional and you ......

1131 of 1205 | Hidden gem in SP1 ... cleaning up the msgbox in a test environment - So now that Jean is posting, this blog should get pretty interesting. Jean is the man, behind the man, behind the man. :) On the current BizTalk team he is about employee number 5 or so which makes him a true wealth of knowledge and I have been working with him for 5 1/2 years and he hasn`t killed me yet so he must have a lot of patience too. :) Good to have him on board. :) :) I have gotten many questions over time from people asking how to cleanup their messagebox when they are running in a *test* environment without having to reconfigure all of the databases. Sometimes you run a test and something fails and you get 1000s of suspended messages in the database that you don`t know what to d......

1132 of 1205 | Hidden gem in SP1 ... cleaning up the msgbox in a test environment - So now that Jean is posting, this blog should get pretty interesting. Jean is the man, behind the man, behind the man. :) On the current BizTalk team he is about employee number 5 or so which makes him a true wealth of knowledge and I have been working with him for 5 1/2 years and he hasn`t killed me yet so he must have a lot of patience too. :) Good to have him on board. :) :) I have gotten many questions over time from people asking how to cleanup their messagebox when they are running in a *test* environment without having to reconfigure all of the databases. Sometimes you run a test and something fails and you get 1000s of suspended messages in the database that you don`t know what to d......

1133 of 1205 | SOAP Adapter Error Messages - Hi, Again in the scalability lab recently we were seeing a number of errors being raised by the SOAP adapter some of them were down to the remote Web Service cowering in the corner when the might of BizTalk hit it all at once J We were seeing a mixture of Timeout errors and the following being logged by the SOAP Adapter to the Event Viewer: The SOAP adapter is suspending an outbound message going to destination URL: http://YourServer/WS.asmx. Details: Object reference not set to an instance of an object. To cut a long story short, we managed to eradicate a number of these by ensuring the remote Web Service had a method level try/catch block to ensure any unhandled exceptions didnt get pro......

1134 of 1205 | Connection options for VS and .NET - Interop bonanza.  For those keeping score at home, IBM has DB2 add-ins for VS, along with a DB2 managed ADO.NET provider.  IBM also has Tivoli AccessManager for .NET and MQ Classes for .NET Oracle will soon shipp Oracle tool add-ins for Visual Studio to complement the ODP.NET ADO.NET data provider.(the tools are in beta2 now) Sybase:  in the Visual Studio Industry Program, not sure of their ship plans.   SAP provides the .NET Connector, and the Portal Development Kit for VS. OTP Systems produces a Tuxedo connector for .NET.  No VS tool add-ins. Lots of 3rd party VS add-ins for connecting to Mainframes BizTalk Server has adapters for nearly everything. WS-I has stipulated rules for web......

1135 of 1205 | Large messages in BizTalk 2004, what`s the deal - The large message support story in BizTalk Server 2004 is a complex one, mainly because the definition of large message varies significantly. This, in turn, is complicated by the fact that our customers expect everything to work with all of the possible variations of "large message". So, how large a message can BizTalk Server 2004 really handle The real answer is "it depends", but the number of considerations varies about as much as there are large message cases, so below I give some rules of thumb to attempt to go by. This post is an attempt to characterize the major classes of scenarios we have seen that require transfer of significant sizes of data, and for each, which features in the c......

1136 of 1205 | Large messages in BizTalk 2004, what`s the deal - The large message support story in BizTalk Server 2004 is a complex one, mainly because the definition of large message varies significantly. This, in turn, is complicated by the fact that our customers expect everything to work with all of the possible variations of "large message". So, how large a message can BizTalk Server 2004 really handle The real answer is "it depends", but the number of considerations varies about as much as there are large message cases, so below I give some rules of thumb to attempt to go by. This post is an attempt to characterize the major classes of scenarios we have seen that require transfer of significant sizes of data, and for each, which features in the c......

1137 of 1205 | MSMQ Adapter if available now (alternative to MSMQT Adapter) - BTW, MSMQ adapter for BizTalk 2004, that I referred to before, is now available for download at http://www.microsoft.com/downloads/details.aspxFamilyID=cba87d07-7f50-4d7b-a888-388d123f736e&DisplayLang=en That`s the same adapter, I previously referred to as "MSMQ/C". This is a pretty good alternative to MSMQT adapter shipped in-box. Here are just few thinmgs that differs between MSMQ/T and MSMQ Adapters: If you want to... MSMQ/T Adapter (in-box) MSMQ Adapter (new) Run other applications that use MSMQ API (or simply use MSMQ API at all.) Only if you install Windows message queuing (MSMQ) side by side with MSMQT. Automatically granted, in fact, MSMQ Adapter itself is using Windows MSMQ API......

1138 of 1205 | Tomcat Connection Pooling with DBCP - What is Connection Pooling Connection pooling is a technique of creating and managing a pool of connections that are ready for use by any thread that needs them. This technique of "pooling" connections is based on the fact that most applications only need a thread to have access to a JDBC connection when they are actively processing a transaction, which usually take only milliseconds to complete. When not processing a transaction, the connection would otherwise sit idle. Instead, connection pooling allows the idle connection to be used by some other thread to do useful work. In practice, when a thread needs to do work against a MySQL or other database with JDBC,......

1139 of 1205 | Get local DNS server addresses and domain name. - Here is a way to get the host, domain name, and DNS servers of local machine. using System;using System.Net;using System.Collections;using System.Runtime.InteropServices;using MVPTools; namespace MVPTools.Net{ ///  /// Summary description for IPConfig. ///  public class IPConfig {  private string hostName;  private string domainName;  private IPAddress[] dnsServers;   public IPConfig()  {   GetParms();  }   private void GetParms()  {   uint uintBufferSize = 0;    ArrayList dnsIPList = new ArrayList();   IPAddress dnsIP;   Native.IP_ADDR_STRING DNSIP;    //run the method once to find the size of the buffer required    if( Native.GetNetworkParams(IntPtr.Zero , ref uintBufferSize) != 111 )    ......

1140 of 1205 | Microsoft BizTalk Adapter for MSMQ is Now Available! - We are very proud to announce the release of the Microsoft BizTalk Adapter for MSMQ. The adapter is a feature rich solution for BizTalk Message Queuing integration, and has raised the bar on quality for BizTalk adapters. The BizTalk 2004 Adapter for MSMQ provides support for sending and receiving messages using MSMQ 2.0 and 3.0, and takes advantage of the new features in MSMQ 3.0. Major features of the adapter include support for: MSMQ 2.0 and 3.0 Multi-threading option for faster performance Guaranteed delivery when using transactional queues Reading from remote non-transactional queues Dynamic send ports Support for messages up to 2 Gigabytes in size This is one that customers have bee......

1141 of 1205 | MSMQ adapter error if MSMQ/C adapter was installed - My client had a preview of the MSMQ/C adapter and was using it in their development environment.  When the new MSMQ adapter came out they installed that and promptly received the following error:   The Messaging Engine failed to create the receive adapter "MSMQ". Reason: "Could not load type Microsoft.BizTalk.MsmqAdapter.MsmqReceiver, Microsoft.BizTalk.Adapter.MSMQ.MsmqAdapter,   We were able to fix the problem by following the steps below   Open the Adm_Adapter table in BizTalkMgmtDB database that Biztalk is pointing to In the Name column, find the row with value of MSMQ Delete the value in the InboundAssemblyPath column Delete the value in the OutboundAssemblyPath column as well Restart......

1142 of 1205 | BizTalk ODBC Adapter - A colleague of mine, Todd Van Nurden, has written an ODBC adapter for BizTalk Server 2004.  Download it from the GotDotNet workspace.  The ODBC adapter addresses some of the limitations of the SQL Adapter.  For example, it supports stored procedures that return multiple recordsets... The Quick list:Stored Procedures with out parameters (If the ODBC driver supports them)Compound queries More then one query performed in a single passParameterization of raw SQL Statements (Enter your own SQL statements with parameters)Batched queries The request XML document can be nested with multiple parameter sets It`s all good......

1143 of 1205 | BizTalk ODBC Adapter - A colleague of mine, Todd Van Nurden, has written an ODBC adapter for BizTalk Server 2004.  Download it from the GotDotNet workspace.  The ODBC adapter addresses some of the limitations of the SQL Adapter.  For example, it supports stored procedures that return multiple recordsets... The Quick list:Stored Procedures with out parameters (If the ODBC driver supports them)Compound queries More then one query performed in a single passParameterization of raw SQL Statements (Enter your own SQL statements with parameters)Batched queries The request XML document can be nested with multiple parameter sets It`s all good......

1144 of 1205 | Biztalk Server 2004 ODBC Adapter Community Supported Sample - I found a few more interesting things in my email.  He`s the first one:Apparently lots of people want a generic database adapter for BizTalk Server. On our product planning list it was "one below the cut-off line" for BizTalk Server 2006 - ie. it didn`t quite make it but it was close.  Where was I.  So you want an ODBC adapter Ok.  Todd Van Nurden - super star MS technology specialist -has been using his "spare" time constructively to create a pretty fully fledged ODBC Adapter for BizTalk Server 2004.  Its a sample (ie. not supported offering) but it comes with complete source code and its pretty fully featured (including add generate items!).  It uses ADO.NET and he has done smoke-screen ......

1145 of 1205 | MSMQ Adapter for BizTalk Server 2004 Released - Yesterday Microsoft released a BizTalk 2004 Adapter for MSMQ v2.0.  This works with MSMQ 2.0 and 3.0.    Here are the key features from the download site:   The BizTalk 2004 Adapter for MSMQ provides support for sending and receiving messages using MSMQ 2.0 and 3.0, and takes advantage of the new features in MSMQ 3.0. Major features of the adapter include support for: • MSMQ 2.0 and 3.0• Multi-threading option for faster performance• Guaranteed delivery when using transactional queues• Reading from remote non-transactional queues• Dynamic send ports• Support for messages up to 2 Gigabytes in size   Download this adapter here.  ...

1146 of 1205 | New Adapters for BizTalk 2004 - Microsoft has a new MSMQ Adapter for BizTalk 2004.  We can finally say goodbye to MSMQT!!!  You can install MSMQT and MSMQ on the same machine, but just make sure you follow the instructions.  I`ve installed and tested this adapter and everything seems to work fine. Another Adapter out is an ODBC Adapter.  This has been tested using Oracle, DB2, SQL, MySQL and SQLLite.  I haven`t tested this one yet, but it looks interesting!...

1147 of 1205 | Adapter Migration Toolkit is released on 01/21 - This little piece is designed to help migrating your BizTalk 2002 components (AICs, custom preprocessors) to BizTalk 2004 by providing shims. It`s downloadable at the MS download center. Also, please, notice the whitepaper on BizTalk 2002 to BizTalk 2004 migration in the same download location -- see the link on the right in "Related resources. It`s a self-extracting zip file....

1148 of 1205 | Getting Multiple Virtual PCs to Work Together - I`m a big fan of using multple Microsoft Virtual PC images, especially for demos and development.  My current machine has a second hard disk that is dedicated to images that I use for such work. One of the problems I`ve run into in the past is getting multiple Virtual PC instances to talk nicely together over a network - regardless of whether the host machine is connected or not.  On frequent occasions I`ve turned up to do demos only to find out that Virtual PC #1 cannot see Virtual PC #2 on the network - even though they are on the same machine! This week I`ve been putting together a demo that involves 4 Virtual PCs talking to each other simultaneously (showing interop between different ve......

1149 of 1205 | Using SQLXML`s at-identity with BizTalk 2004 (UpdateGram) - Last year we tried to insert multiple parent-child tables with the SQL Adapter by Updategrams at one of our customers. But without results. Now Stephen Kaufman wrote a nice article about this to get it done. This reduces roundtrips in your BizTalk Server Business Processes and ofcourse Persistance Points. Read his article here...

1150 of 1205 | Using SQLXML`s at-identity with BizTalk 2004 (UpdateGram) - Last year we tried to insert multiple parent-child tables with the SQL Adapter by Updategrams at one of our customers. But without results. Now Stephen Kaufman wrote a nice article about this to get it done. This reduces roundtrips in your BizTalk Server Business Processes and ofcourse Persistance Points. Read his article here...