Biztalk 32bit or 64bit? Event ID 5754

SQL adapter data adapter is used in the XXXX Project (name cannot be written), because the BizTalk Server runs on a 64-bit operating system in the development environment, the host instance runs in the 32bit only mode. The development and test operations are normal and Data Reading and writing are fine. However, when the exported MSI file is installed on a 64-bit operating system, in addition, when the BizTalk host is imported in a 64-bit test environment, the result of the first test process is too disappointing. An error event with the error ID 5754 is returned:

Event Type: Error
Event Source: Biztalk Server 2006
Event Type: Biztalk Server 2006
Event ID: 5754
Date: 2009-04-13
Event: 17:51:35
User: N/
COMPUTER: XXXXX-XXXXX
Description:
The message sent to the adapter biztalkmessagingengine on the sending port "execinfoxmltodb" (URI is "SQL: //./xxxdb/") has been suspended.
Error details: the 64-bit host instance does not support the sending adapter of this sending port. Make sure that the sending adapter is associated with a 32-bit processor only.
Message ID: {7ab79f0a-daad-4f03-8d27-fee220ed253f}
Instance id: {639a8435-2c96-47f3-836c-0b52bdf6f417}

For more information, see Help and Support Center in http://go.microsoft.com/fwlink/events.asp.

So I began to doubt:

Isn't the BizTalk application released as a 64-bit program? However, we chose the ". Net" Active solution platform during deployment. In other words, it supports 32-bit and 64-bit environments...

Is there a problem with the SQL 2005 installation or patch package? After reading the installed program, it's okay. The configuration is the same as that in the development environment.
............

Is it because of the BizTalk 64-bit host instance ??? When I gradually ruled out my own reasons, I finally put my responsibilities to the MS side :(
So Google finally saw a similar problem in a Foreign Development Forum. A link pushed me to the helpless abyss:
Http://msdn.microsoft.com/en-us/library/aa560166.aspx
**************************************** ***********************
The English official documents are described as follows:

Which adapters are capable of running in 64-Bit mode?

By default, all adapters can run in 32-Bit mode on 32-bit windows and on wow64 on 64-bit windows. The following adaptersCan run in native 64-Bit mode(In either IIS or btsntsvc as the host process ):

• HTTP
• Soap
• File
• SMTP
• MSMQ
• MQSeries
• WCF

Note
The MQSeries adapter is supported in both 32-bit and 64-bit processes. the adapter has a MQSeries agent that runs on IBM WebSphere MQ server on Windows. with MQ Fix Pack 6.0.2.1 the agent is supported as a 32-bit process running under wow64.

Note
Running the WSE adapter, FTP adapter,SQL Adapter, POP3 adapter, and mime DecoderOn 64-bit host instances is not supported.

**************************************** *********************
Local Chinese Document Description:

Which adapters can run in 64-Bit mode?
By default, all adapters can run in 32-bit windows in 32-Bit mode, and in 64-bit windows in wow64. The following adapters can run in local 64-Bit mode (When IIS or btsntsvc is used as the host process ):

HTTP
Soap
File
SMTP
MSMQ
MQSeries
Note:
Both 32-bit and 64-bit processes support MQSeries adapters. This adapter depends on the ibm api of the MQSeries proxy. Currently, IBM only supports it on 32-bit windows.
**************************************** *********************
Not Supported... this is the latest BizTalk Server 2006 R2 description (SQL adpater is not described in the Chinese Document of my development environment ), explicitly specifying that the SQL adapter is not welcome under a 64-bit host instance! So I called Ms again to ask this question, and there was no fix package or DLL patch, and the answer was as follows:

 

Therefore, if you want to run the SQL adapter on a 64-bit machine, You must select the host of the host instance that runs the BizTalk application as 32-bit only. According to the event log you provided, the following error messages are also mentioned in the Log Warning:

The message sent to the adapter biztalkmessagingengine on the "execinfoxmltodb" (URI: "SQL: //./twfdb/") on the "sending port" has been suspended.

Error details: the 64-bit host instance does not support the sending adapter of this sending port. Make sure that the sending adapter is associated with a 32-bit processor only. "

Therefore, we recommend that you use 32-bit only to design your application ......

 

It seems that we only accept this arrangement, so we created a host and a 32-bit host instance, and bound the SQL port running host instance to the new host instance, the main application is also bound to the default host instance, that is, the 64-bit host instance. As expected, the program runs normally, and the long-overdue btsntsvc and... btsntsvc64are displayed in the Process Manager! Solved the problem harmoniously...

I don't know how many of these 64-bit + 32-bit running modes affect the performance of BTS, and whether the entire BizTalk system can take advantage of the 64-Bit performance, however, it is clear that the dual-process consumes a considerable amount of memory and CPU resources.

We sincerely hope that developers and managers can take the precaution. when building a project architecture, we must also read the support and implementation of the real operating environment for the extended architecture.
It really makes me uncomfortable. It really makes me uncomfortable.

Biztalk Server 2009...SQL adapter event ID 5754 will go on???