Sign in
 
SQL Server Developer Center > SQL Server Forums > SQL Service Broker > Service Broker and AS400 MQ Series
Ask a questionAsk a question
Search Forums:
 

AnswerService Broker and AS400 MQ Series

  • Tuesday, February 13, 2007 4:37 PMshafiqm Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Hi,

    Does anyone using SQL Server broker to send message to a queue outside SQL Server. I mean to non-SQL environment like AS400 MQ Series.

     

    Thanks

    Shafiq

     

Answers

  • Wednesday, February 14, 2007 7:05 PMRushi Desai Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    Service Broker uses proprietary wire protocol to communicate between SQL server instances. Hence it cannot directly talk to MQ Series. However, you could build an adapter service that can receive messages from a service broker queue and send them to an MQ Series queue in a distributed transaction.
     

All Replies

  • Wednesday, February 14, 2007 7:05 PMRushi Desai Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    Service Broker uses proprietary wire protocol to communicate between SQL server instances. Hence it cannot directly talk to MQ Series. However, you could build an adapter service that can receive messages from a service broker queue and send them to an MQ Series queue in a distributed transaction.
     
  • Tuesday, February 20, 2007 12:10 AMshafiqm Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Is there any example code or url reference regarding building adapter service?
     
  • Tuesday, October 27, 2009 3:56 PMpjmurray Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I'm interested in this scenario as well. I've just begun to research the possiblities.  Anyone familiar with MQ?  Wouldn't it be possible to send and received messages between the two systems via web services?  Does anyone know if there is something already built on the MQ side to facilitate this scenario?

    Thanks
    Paul
     
  • Wednesday, October 28, 2009 5:00 PMPawel MarciniakAnswererUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    This article may be helpful: http://support.microsoft.com/kb/555070