BizTalk 2006 SQL Adapter on 64 bit machines

BizTalk 2006 SQL adapter will not run on 64 bit host instance so we need to create one more instance of BizTalk server that runs on 32 bit and assign sql adapter to run this 32 bit instance.BizTalk 2006 supported adapters on 64 bit machines is found on the link http://msdn2.microsoft.com/en-us/library/aa560166.aspx

Next issue we have seen is that when you run 32 bit program VS 2005 on 64 bit machines you will get the following error also
When trying to deploy BizTalk assemblies you will get this error

error DEPLOY: COM+ was unable to talk to the Microsoft Distributed Transaction Coordinator (Exception from HRESULT: 0x8004E00F)

There is an hot fix for the above issue.For more details
http://support.microsoft.com/kb/910907