Sending message to MSMQ Server

Question

Post reply

Sending message to MSMQ Server

ekknaveen

SSCrazy

Points: 2317
More actions
January 20, 2016 at 12:50 am

#323766

Hi,
I need to send the messages whenever it comes to MSMQ Server on regular basis using SQL Server.
Could you please let me know how we can send the message to MSMQ Server.
Messages are simple like 01CMS93847TEST9873
Thanks in Advance
Naveen

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736254 More actions · Answer 1

create a .NET project to do so: https://support.microsoft.com/en-us/kb/555070

http://www.codeproject.com/Articles/18147/Accessing-MSMQ-from-Microsoft-SQL-Server

Could use sp_oaMethod as well: http://stackoverflow.com/questions/11550593/is-there-any-straightforward-way-to-send-a-message-to-msmq-inside-sp-in-sql-serv

AFAIK, there are no native interfaces inside of SQL Server to access MSMQ. I would recommend SQLCLR.

ekknaveen SSCrazy Points: 2317 More actions · Answer 2

Hi,

Thanks for your reply,

Could you please send sample code while will send messages to MQ either using SQL Server or VB6 only.

If requires any references from where i can add those references.

Thanks

Naveen

Steve Jones - SSC Editor SSC Guru Points: 736254 More actions · Answer 3

Steve Jones - SSC Editor

SSC Guru

Points: 736254

January 21, 2016 at 10:00 am

#1853551

Those links have some code.

ekknaveen SSCrazy Points: 2317 More actions · Answer 4

But i am looking in VB6 (not .NET) or SQL Server. When I checked those links, I am not able to find the MSMQ.dll there. It would be great if you tell me where can i get that dll, I checked it in control panel - > add and remove programs -> windows on or off -> installed MSMQ from there but still not able to locate that

Steve Jones - SSC Editor SSC Guru Points: 736254 More actions · Answer 5

I believe your DLL should be in

\WINNT\system32\MQOA.dll

That should be installed on your server system. Might need to add it to development.

This also might help: https://www.microsoft.com/msj/0599/msmq/msmq.aspx

ekknaveen SSCrazy Points: 2317 More actions · Answer 6

Thanks for the information provided....

When I copied the dll and also the code snipped from the link, and tried to execute it getting an error "The operation is not supported for Microsoft Queuing installed in workgroup domain."

Could you pls let me know what is missing. I tried to send the message to my computer itself to check.

Regards

Naveen

Steve Jones - SSC Editor SSC Guru Points: 736254 More actions · Answer 7

You will probably need to post this at an MSDN forum, but I did find this: https://support.microsoft.com/en-us/kb/884974

If you're using Messaging Queueing v1, then only in domain mode. It's possible that the version of the DLL you downloaded is v1. V2 supports workgroups. I'm guessing you don't have a domain, or aren't using a domain account to run this?

There's also a check for which mode in the registry here: http://stackoverflow.com/questions/2198681/how-to-change-msmq-configuration-from-workgroup-mode-to-domain-mode