I am using MTS transaction server with Visual Basic 6.0 to create a
sample application. I have made a ActiveX Dll component which sends a
message in a message queue and after that it opens a SQL connection and
does some work on it.The ActiveX Dll is a apartment threaded. The
interface is marked as multiuse and requires transaction.The MSMQ
message sending works fine but after that if i open SQL Connection using
ADODB recordset Open method i get the error :[Microsoft][ODBC Driver
Manager] Illegal operation while in a transaction server component
transaction, Error Number = -2147168246. If i remove the MSMQ code than
it works fine. I have made a client Standard Exe which just calls this
interface method.

Hope I m clear. Thanx
Pinakin Shah